Investeam

select cb.paymentDate
from Tb_ProjectPayScheduleLine cb
inner join tb_allocationpayschedule allo on allo.tb_allocationpayschedule_ID=cb.tb_allocationpayschedule_ID
inner join Tb_ProjectPaySchedule ps on ps.Tb_ProjectPaySchedule_ID=1026142 --cb.Tb_ProjectPaySchedule_ID
where ps.c_project_ID=1001301 /*cp.c_project_ID*/ --and ps.isActive='Y'

select xa.paymentDate
from tb_allocationpayschedule x
inner join Tb_ProjectPayScheduleLine xa on xa.tb_allocationpayschedule_ID=x.tb_allocationpayschedule_ID
where x.c_project_ID=1001301