APPS.PAY_CORE_UPGRADE_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 812: from pay_payroll_actions ppa,

808: select ''
809: into l_dummy
810: from dual
811: where exists (select ''
812: from pay_payroll_actions ppa,
813: pay_assignment_actions paa
814: where paa.assignment_id = p_object_id
815: and paa.payroll_action_id = ppa.payroll_action_id
816: and action_type = 'L');

Line 840: from pay_payroll_actions

836: begin
837: --
838: select count(*)
839: into l_count
840: from pay_payroll_actions
841: where action_type = 'L';
842: --
843: if (l_count = 0) then
844: p_exists := 'FALSE';

Line 893: pay_payroll_actions PAY_ACTION,

889: ET PAY_ELEMENT_TYPES_F_PK)
890: */
891: DISTINCT ASGT_ACTION.assignment_action_id, EE.element_entry_id
892: FROM pay_assignment_actions ASGT_ACTION,
893: pay_payroll_actions PAY_ACTION,
894: pay_element_entries_f EE,
895: pay_element_types_f ET
896: WHERE ASGT_ACTION.assignment_id = p_asg_id
897: AND ASGT_ACTION.payroll_action_id = PAY_ACTION.payroll_action_id

Line 1024: from pay_payroll_actions ppa,

1020: select ''
1021: into l_dummy
1022: from dual
1023: where exists (select ''
1024: from pay_payroll_actions ppa,
1025: pay_assignment_actions paa
1026: where paa.assignment_id = p_object_id
1027: and paa.payroll_action_id = ppa.payroll_action_id
1028: and ppa.action_type = 'Q');

Line 1088: from pay_payroll_actions ppa,

1084: select ''
1085: into l_dummy
1086: from dual
1087: where exists (select ''
1088: from pay_payroll_actions ppa,
1089: pay_assignment_actions paa
1090: where paa.assignment_id = p_object_id
1091: and paa.payroll_action_id = ppa.payroll_action_id
1092: and action_type in ('R', 'Q', 'B', 'V', 'I'));

Line 1130: pay_payroll_actions pa

1126: cursor c_get_aas (p_assignment_id in number) is
1127: select /*+ ORDERED use_nl(aa pa)*/
1128: aa.assignment_action_id, pa.effective_date
1129: from pay_assignment_actions aa,
1130: pay_payroll_actions pa
1131: where aa.assignment_id = p_assignment_id
1132: and pa.payroll_action_id = aa.payroll_action_id
1133: and pa.action_type in ('R', 'Q', 'B', 'V', 'I');
1134: --

Line 1315: from pay_payroll_actions ppa,

1311: select ''
1312: into l_dummy
1313: from dual
1314: where exists (select ''
1315: from pay_payroll_actions ppa,
1316: pay_assignment_actions paa
1317: where paa.assignment_id = p_object_id
1318: and paa.payroll_action_id = ppa.payroll_action_id
1319: and action_type in ('R', 'Q', 'B', 'I'));

Line 1347: type t_action is table of pay_payroll_actions.action_type%type

1343: type t_rr_id is table of pay_run_results.run_result_id%type
1344: index by binary_integer;
1345: type t_td_id is table of pay_time_definitions.time_definition_id%type
1346: index by binary_integer;
1347: type t_action is table of pay_payroll_actions.action_type%type
1348: index by binary_integer;
1349: type date_tab is table of date index by binary_integer;
1350: --
1351: l_ee_tab t_ee_id;

Line 1373: pay_payroll_actions ppa,

1369: ) time_definition_id
1370: from pay_element_entries_f pee,
1371: pay_entry_process_details pepd,
1372: pay_assignment_actions paa,
1373: pay_payroll_actions ppa,
1374: per_time_periods ptp,
1375: pay_element_types_f pet
1376: where pee.creator_type in ('RR', 'EE')
1377: and pee.assignment_id = p_asg_id

Line 1400: pay_payroll_actions ppa,

1396: null) time_definition_id,
1397: ppa.action_type
1398: from
1399: pay_assignment_actions paa,
1400: pay_payroll_actions ppa,
1401: pay_element_types_f pet,
1402: pay_run_results prr
1403: where paa.assignment_id = p_asg_id
1404: and paa.assignment_action_id = prr.assignment_action_id