APPS.PQP_GB_PSI_FUNCTIONS dependencies on PAY_PAYROLL_ACTIONS

Line 894: index (PPA PAY_PAYROLL_ACTIONS_PK)*/

890: IS
891: SELECT /*+ ordered use_nl(PAA PPA)
892: index (PAA PAY_ASSIGNMENT_ACTIONS_N1)
893: index (PAA PAY_ASSIGNMENT_ACTIONS_N51)
894: index (PPA PAY_PAYROLL_ACTIONS_PK)*/
895: paa.assignment_action_id -- max(paa.assignment_action_id)
896: -- no longer using max, now pick all assignment runs
897: FROM pay_assignment_actions paa
898: ,pay_payroll_actions ppa

Line 898: ,pay_payroll_actions ppa

894: index (PPA PAY_PAYROLL_ACTIONS_PK)*/
895: paa.assignment_action_id -- max(paa.assignment_action_id)
896: -- no longer using max, now pick all assignment runs
897: FROM pay_assignment_actions paa
898: ,pay_payroll_actions ppa
899: WHERE paa.assignment_id = p_assignment_id
900: AND ppa.action_status = 'C'
901: AND paa.action_status = 'C'
902: AND paa.payroll_action_id = ppa.payroll_action_id

Line 917: ,pay_payroll_actions ppa

913:
914: SELECT paa.assignment_action_id -- min(paa.assignment_action_id)
915: -- ppa.date_earned
916: FROM pay_assignment_actions paa
917: ,pay_payroll_actions ppa
918: WHERE paa.assignment_id = p_assignment_id
919: AND ppa.action_status = 'C'
920: AND paa.action_status = 'C'
921: AND paa.payroll_action_id = ppa.payroll_action_id

Line 938: ,pay_payroll_actions ppa

934: )
935: IS
936: SELECT paa.assignment_action_id, paa.source_action_id
937: FROM pay_assignment_actions paa
938: ,pay_payroll_actions ppa
939: ,pay_run_results prr
940: WHERE paa.assignment_id = p_assignment_id
941: AND ppa.action_status = 'C'
942: AND paa.action_status = 'C'

Line 1051: INDEX (BACT PAY_PAYROLL_ACTIONS_PK)

1047: )
1048: IS
1049: select /*+ ORDERED USE_NL(BAL_ASSACT BACT ASSACT PACT EE RR RRV)
1050: INDEX (BAL_ASSACT PAY_ASSIGNMENT_ACTIONS_PK )
1051: INDEX (BACT PAY_PAYROLL_ACTIONS_PK)
1052: INDEX (ASSACT PAY_ASSIGNMENT_ACTIONS_N51 )
1053: INDEX (ASSACT PAY_ASSIGNMENT_ACTIONS_N1 )
1054: INDEX (PACT PAY_PAYROLL_ACTIONS_PK)
1055: INDEX (EE PAY_ELEMENT_ENTRIES_F_N50)

Line 1054: INDEX (PACT PAY_PAYROLL_ACTIONS_PK)

1050: INDEX (BAL_ASSACT PAY_ASSIGNMENT_ACTIONS_PK )
1051: INDEX (BACT PAY_PAYROLL_ACTIONS_PK)
1052: INDEX (ASSACT PAY_ASSIGNMENT_ACTIONS_N51 )
1053: INDEX (ASSACT PAY_ASSIGNMENT_ACTIONS_N1 )
1054: INDEX (PACT PAY_PAYROLL_ACTIONS_PK)
1055: INDEX (EE PAY_ELEMENT_ENTRIES_F_N50)
1056: INDEX (RR PAY_RUN_RESULTS_N51)
1057: INDEX (RRV PAY_RUN_RESULT_VALUES_N50)
1058: */

Line 1071: pay_payroll_actions BACT,

1067: RR.source_id rr_source_id,
1068: RR.status,
1069: RR.source_type
1070: from pay_assignment_actions BAL_ASSACT,
1071: pay_payroll_actions BACT,
1072: pay_assignment_actions ASSACT,
1073: pay_payroll_actions PACT,
1074: pay_element_entries_f EE,
1075: pay_run_results RR,

Line 1073: pay_payroll_actions PACT,

1069: RR.source_type
1070: from pay_assignment_actions BAL_ASSACT,
1071: pay_payroll_actions BACT,
1072: pay_assignment_actions ASSACT,
1073: pay_payroll_actions PACT,
1074: pay_element_entries_f EE,
1075: pay_run_results RR,
1076: pay_run_result_values RRV
1077: where BAL_ASSACT.assignment_action_id = p_assignment_action_id