DBA Data[Home] [Help]

APPS.CN_PAYGROUP_PVT dependencies on CN_PERIOD_STATUSES

Line 1051: cn_srp_pay_groups cspg,cn_payment_worksheets cpw,cn_payruns cp,cn_period_statuses cps

1047:
1048: if(l_valid_data = 1) then
1049: begin
1050: select max(cps.end_date) into l_pay_period_end_date from
1051: cn_srp_pay_groups cspg,cn_payment_worksheets cpw,cn_payruns cp,cn_period_statuses cps
1052: where
1053: cp.payrun_id = cpw.payrun_id and cp.pay_group_id = cspg.pay_group_id and
1054: cp.org_id = cpw.org_id and cp.org_id = cspg.org_id and
1055: cpw.salesrep_id = cspg.salesrep_id and cpw.org_id = cspg.org_id and