APPS.PAY_NL_WAGE_REPORT_PKG dependencies on PAY_PAYROLLS_F

Line 4598: from pay_payrolls_f

4594:
4595: CURSOR C_ER_PYRLS(p_tax_unit_id NUMBER, p_bg_id NUMBER, p_start_date DATE, p_payroll_type VARCHAR2)
4596: IS
4597: select PAYROLL_ID
4598: from pay_payrolls_f
4599: where
4600: PRL_INFORMATION1 = to_char(p_tax_unit_id)
4601: AND BUSINESS_GROUP_ID = p_bg_id
4602: AND PERIOD_TYPE = DECODE(p_payroll_type,'MONTH','Calendar Month','WEEK','Week','LMONTH','Lunar Month')

Line 4672: pay_payrolls_f ppf

4668: select max(paa.assignment_action_id)
4669: from
4670: pay_payroll_actions ppa,
4671: pay_assignment_actions paa,
4672: pay_payrolls_f ppf
4673: where
4674: ppa.payroll_action_id = paa.payroll_action_id
4675: AND ppa.business_group_id = p_bg_id
4676: AND ppa.action_type IN ('R','Q')