DBA Data[Home] [Help]

APPS.PAY_US_RSRW_UPGREV dependencies on PAY_PAYROLLS_F

Line 2807: ,pay_payrollS_f PRL

2803: ,ctx_payroll_id in number
2804: ,period_end_date in date) is
2805: select max(PTP.period_num)
2806: from per_time_periods PTP
2807: ,pay_payrollS_f PRL
2808: where PTP.payroll_id = ctx_payroll_id
2809: and PTP.payroll_id = PRL.payroll_id
2810: and PRL.business_group_id = ctx_bg_id
2811: and to_char(period_end_date, 'YYYY') = to_char(PTP.start_date, 'YYYY');

Line 2817: pay_payrolls_f PRL

2813: CURSOR csr_get_num_prd(ctx_bg_id in number
2814: ,ctx_payroll_id in number) IS
2815: select TPT.number_per_fiscal_year
2816: from per_time_period_types TPT,
2817: pay_payrolls_f PRL
2818: WHERE TPT.period_type = PRL.period_type
2819: AND PRL.business_group_id + 0 = ctx_bg_id
2820: AND PRL.payroll_id = ctx_payroll_id;
2821: