DBA Data[Home] [Help]

APPS.PAY_AU_PAYSLIP_ARCHIVE dependencies on PAY_RUN_TYPES_F

Line 1312: from pay_run_types_f prt,

1308: (ppp.source_action_id is not null
1309: and cp_ppp_source_action_id is null
1310: and exists (
1311: select ''
1312: from pay_run_types_f prt,
1313: pay_assignment_actions paa_run,
1314: pay_payroll_actions ppa_run
1315: where paa_run.assignment_action_id
1316: = ppp.source_action_id

Line 1521: pay_run_types_f prt

1517: p_source_action_id pay_assignment_actions.assignment_action_id%type) IS
1518: SELECT paa.assignment_action_id
1519: FROM pay_assignment_actions paa,
1520: pay_action_interlocks pai,
1521: pay_run_types_f prt
1522: WHERE pai.locking_action_id = p_prepay_action_id
1523: and paa.assignment_action_id = pai.locked_action_id
1524: and paa.source_action_id = p_source_action_id
1525: and paa.run_type_id = prt.run_type_id;