DBA Data[Home] [Help]

APPS.PAY_AU_PAYSLIP_ARCHIVE dependencies on PAY_RUN_TYPES_F

Line 1147: from pay_run_types_f prt,

1143: (ppp.source_action_id is not null
1144: and cp_ppp_source_action_id is null
1145: and exists (
1146: select ''
1147: from pay_run_types_f prt,
1148: pay_assignment_actions paa_run,
1149: pay_payroll_actions ppa_run
1150: where paa_run.assignment_action_id
1151: = ppp.source_action_id

Line 1356: pay_run_types_f prt

1352: p_source_action_id pay_assignment_actions.assignment_action_id%type) IS
1353: SELECT paa.assignment_action_id
1354: FROM pay_assignment_actions paa,
1355: pay_action_interlocks pai,
1356: pay_run_types_f prt
1357: WHERE pai.locking_action_id = p_prepay_action_id
1358: and paa.assignment_action_id = pai.locked_action_id
1359: and paa.source_action_id = p_source_action_id
1360: and paa.run_type_id = prt.run_type_id;