DBA Data[Home] [Help]

APPS.PAY_IN_PF_REPORTS dependencies on PAY_PAYROLL_ACTIONS

Line 1263: pay_payroll_actions ppa

1259: IS
1260: SELECT DISTINCT
1261: action_information20 pup
1262: FROM pay_action_information pai,
1263: pay_payroll_actions ppa
1264: WHERE pai.action_context_id = ppa.payroll_action_id
1265: AND ppa.action_type = 'X'
1266: AND ppa.action_status = 'C'
1267: AND ppa.report_type ='IN_PF_ARCHIVE'

Line 1437: pay_payroll_actions ppa

1433: IS
1434: SELECT DISTINCT
1435: pai.action_information1 bus_no
1436: FROM pay_action_information pai,
1437: pay_payroll_actions ppa
1438: WHERE pai.action_context_id = ppa.payroll_action_id
1439: AND ppa.action_type = 'X'
1440: AND ppa.action_status = 'C'
1441: AND ppa.report_type ='IN_PF_ARCHIVE'