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_ASSIGNMENT_ACTIONS

Line 885: index (PAA PAY_ASSIGNMENT_ACTIONS_N1)

881: ,p_date_earned DATE
882: )
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

Line 886: index (PAA PAY_ASSIGNMENT_ACTIONS_N51)

882: )
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

Line 890: FROM pay_assignment_actions paa

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
892: WHERE paa.assignment_id = p_assignment_id
893: AND ppa.action_status = 'C'
894: AND paa.action_status = 'C'

Line 909: FROM pay_assignment_actions paa

905: )IS
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'

Line 930: FROM pay_assignment_actions paa

926: ,p_element_entry_id NUMBER
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'

Line 1021: INDEX (BAL_ASSACT PAY_ASSIGNMENT_ACTIONS_PK )

1017: ,p_effective_date DATE
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)

Line 1023: INDEX (ASSACT PAY_ASSIGNMENT_ACTIONS_N51 )

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)
1027: INDEX (RR PAY_RUN_RESULTS_N51)

Line 1024: INDEX (ASSACT PAY_ASSIGNMENT_ACTIONS_N1 )

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)
1027: INDEX (RR PAY_RUN_RESULTS_N51)
1028: INDEX (RRV PAY_RUN_RESULT_VALUES_N50)

Line 1041: from pay_assignment_actions BAL_ASSACT,

1037: EE.source_id ee_source_id, -- this is run_result_id of parent element, of which this ele is a retro
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,

Line 1043: pay_assignment_actions ASSACT,

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,
1047: pay_run_result_values RRV