eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_PSI_FUNCTIONS dependencies on PAY_PAYROLL_ACTIONS

Line 887: index (PPA PAY_PAYROLL_ACTIONS_PK)*/

883: IS
884: SELECT /*+ ordered use_nl(PAA PPA)
885: index (PAA PAY_ASSIGNMENT_ACTIONS_N1)
886: index (PAA PAY_ASSIGNMENT_ACTIONS_N51)
887: index (PPA PAY_PAYROLL_ACTIONS_PK)*/
888: paa.assignment_action_id -- max(paa.assignment_action_id)
889: -- no longer using max, now pick all assignment runs
890: FROM pay_assignment_actions paa
891: ,pay_payroll_actions ppa

Line 891: ,pay_payroll_actions ppa

887: index (PPA PAY_PAYROLL_ACTIONS_PK)*/
888: paa.assignment_action_id -- max(paa.assignment_action_id)
889: -- no longer using max, now pick all assignment runs
890: FROM pay_assignment_actions paa
891: ,pay_payroll_actions ppa
892: WHERE paa.assignment_id = p_assignment_id
893: AND ppa.action_status = 'C'
894: AND paa.action_status = 'C'
895: AND paa.payroll_action_id = ppa.payroll_action_id

Line 910: ,pay_payroll_actions ppa

906:
907: SELECT paa.assignment_action_id -- min(paa.assignment_action_id)
908: -- ppa.date_earned
909: FROM pay_assignment_actions paa
910: ,pay_payroll_actions ppa
911: WHERE paa.assignment_id = p_assignment_id
912: AND ppa.action_status = 'C'
913: AND paa.action_status = 'C'
914: AND paa.payroll_action_id = ppa.payroll_action_id

Line 931: ,pay_payroll_actions ppa

927: )
928: IS
929: SELECT paa.assignment_action_id, paa.source_action_id
930: FROM pay_assignment_actions paa
931: ,pay_payroll_actions ppa
932: ,pay_run_results prr
933: WHERE paa.assignment_id = p_assignment_id
934: AND ppa.action_status = 'C'
935: AND paa.action_status = 'C'

Line 1022: INDEX (BACT PAY_PAYROLL_ACTIONS_PK)

1018: )
1019: IS
1020: select /*+ ORDERED USE_NL(BAL_ASSACT BACT ASSACT PACT EE RR RRV)
1021: INDEX (BAL_ASSACT PAY_ASSIGNMENT_ACTIONS_PK )
1022: INDEX (BACT PAY_PAYROLL_ACTIONS_PK)
1023: INDEX (ASSACT PAY_ASSIGNMENT_ACTIONS_N51 )
1024: INDEX (ASSACT PAY_ASSIGNMENT_ACTIONS_N1 )
1025: INDEX (PACT PAY_PAYROLL_ACTIONS_PK)
1026: INDEX (EE PAY_ELEMENT_ENTRIES_F_N50)

Line 1025: INDEX (PACT PAY_PAYROLL_ACTIONS_PK)

1021: INDEX (BAL_ASSACT PAY_ASSIGNMENT_ACTIONS_PK )
1022: INDEX (BACT PAY_PAYROLL_ACTIONS_PK)
1023: INDEX (ASSACT PAY_ASSIGNMENT_ACTIONS_N51 )
1024: INDEX (ASSACT PAY_ASSIGNMENT_ACTIONS_N1 )
1025: INDEX (PACT PAY_PAYROLL_ACTIONS_PK)
1026: INDEX (EE PAY_ELEMENT_ENTRIES_F_N50)
1027: INDEX (RR PAY_RUN_RESULTS_N51)
1028: INDEX (RRV PAY_RUN_RESULT_VALUES_N50)
1029: */

Line 1042: pay_payroll_actions BACT,

1038: RR.source_id rr_source_id,
1039: RR.status,
1040: RR.source_type
1041: from pay_assignment_actions BAL_ASSACT,
1042: pay_payroll_actions BACT,
1043: pay_assignment_actions ASSACT,
1044: pay_payroll_actions PACT,
1045: pay_element_entries_f EE,
1046: pay_run_results RR,

Line 1044: pay_payroll_actions PACT,

1040: RR.source_type
1041: from pay_assignment_actions BAL_ASSACT,
1042: pay_payroll_actions BACT,
1043: pay_assignment_actions ASSACT,
1044: pay_payroll_actions PACT,
1045: pay_element_entries_f EE,
1046: pay_run_results RR,
1047: pay_run_result_values RRV
1048: where BAL_ASSACT.assignment_action_id = p_assignment_action_id