APPS.PAY_NO_SELF_CERTIFICATION_RPT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 67: ,pay_assignment_actions paa

63: pai.action_information2 employee_number,
64: pai.action_information3 full_name,
65: pai.action_information4 sc_days
66: FROM pay_action_information pai
67: ,pay_assignment_actions paa
68: WHERE pai.action_context_id = paa.assignment_action_id
69: AND paa.payroll_action_id = csr_v_pa_id
70: AND action_information_category ='EMEA REPORT INFORMATION'
71: AND action_information1 = 'PYNOSFCA';