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_NL_PENSION_EXTRACTS dependencies on PAY_PAYROLL_ACTIONS

Line 187: ,pay_payroll_actions ppa

183: ,ppa.effective_date
184: ,ppa.action_type
185: ,ppa.date_earned
186: FROM pay_assignment_actions paa
187: ,pay_payroll_actions ppa
188: WHERE paa.assignment_id = c_assignment_id
189: AND ppa.action_status = 'C'
190: AND paa.action_status = 'C'
191: AND ppa.action_type IN ('Q','R')

Line 213: ,pay_payroll_actions ppa

209: ,c_end_date IN Date
210: ) IS
211: SELECT max(paa.assignment_action_id)
212: FROM pay_assignment_actions paa
213: ,pay_payroll_actions ppa
214: WHERE paa.assignment_id = c_assignment_id
215: AND ppa.action_status = 'C'
216: AND ppa.action_type IN ('Q','R')
217: AND paa.action_status = 'C'

Line 236: ,pay_payroll_actions ppa

232:
233: ) IS
234: SELECT max(paa.assignment_action_id)
235: FROM pay_assignment_actions paa
236: ,pay_payroll_actions ppa
237: WHERE paa.assignment_id = c_assignment_id
238: AND ppa.action_status = 'C'
239: AND ppa.action_type IN ('Q','R')
240: AND paa.action_status = 'C'

Line 918: pay_payroll_actions ppa,

914: ,c_assignment_id in number
915: ,c_element_type_id in number) IS
916: SELECT element_entry_id
917: FROM pay_run_results prr,
918: pay_payroll_actions ppa,
919: pay_assignment_actions paa
920: WHERE paa.assignment_action_id = prr.assignment_action_id
921: AND paa.payroll_action_id = ppa.payroll_action_id
922: AND ppa.date_earned BETWEEN c_start_date

Line 981: pay_payroll_actions ppa,

977: AND screen_entry_value IS NOT NULL
978: AND element_entry_id IN
979: (SELECT element_entry_id
980: FROM pay_run_results prr,
981: pay_payroll_actions ppa,
982: pay_assignment_actions paa
983: WHERE paa.assignment_action_id = prr.assignment_action_id
984: AND paa.payroll_action_id = ppa.payroll_action_id
985: AND ppa.date_earned BETWEEN c_start_date

Line 1123: pay_payroll_actions ppa

1119: pay_element_entry_values_f peev,
1120: pay_run_results prr,
1121: pay_run_result_values prrv,
1122: pay_assignment_actions paa,
1123: pay_payroll_actions ppa
1124: WHERE ppa.date_earned BETWEEN peef.effective_start_date AND
1125: peef.effective_end_date
1126: AND ppa.date_earned BETWEEN pelf.effective_start_date AND
1127: pelf.effective_end_date

Line 9064: pay_payroll_actions ppa,

9060: --cursor to check if run results exist for any FUR/IPAP Pension Types for this assignment
9061: CURSOR c_run_results_exist IS
9062: SELECT pty.pension_type_id
9063: FROM pay_run_results prr,
9064: pay_payroll_actions ppa,
9065: pay_assignment_actions paa,
9066: pay_element_type_extra_info pei,
9067: pqp_pension_types_f pty
9068: WHERE paa.assignment_action_id = prr.assignment_action_id

Line 9590: pay_payroll_actions ppa,

9586: --cursor to check if run results exist for any FUR Pension Types for this assignment
9587: CURSOR c_run_results_exist IS
9588: SELECT pty.pension_type_id
9589: FROM pay_run_results prr,
9590: pay_payroll_actions ppa,
9591: pay_assignment_actions paa,
9592: pay_element_type_extra_info pei,
9593: pqp_pension_types_f pty
9594: WHERE paa.assignment_action_id = prr.assignment_action_id

Line 9933: pay_payroll_actions ppa,

9929: /* Cursor changed for 6670714
9930: CURSOR c_rr_cur IS
9931: SELECT 1
9932: FROM pay_run_results prr,
9933: pay_payroll_actions ppa,
9934: pay_assignment_actions paa,
9935: pay_element_type_extra_info pei,
9936: pqp_pension_types_f pty
9937: WHERE paa.assignment_action_id = prr.assignment_action_id

Line 10076: pay_payroll_actions ppa,

10072: ,'FPU_R','A'
10073: ,'FPU_S','S'
10074: ,'FPU_T' ,'B') fpu_code
10075: FROM pay_run_results prr,
10076: pay_payroll_actions ppa,
10077: pay_assignment_actions paa,
10078: pay_element_type_extra_info pei,
10079: pqp_pension_types_f pty
10080: WHERE paa.assignment_action_id = prr.assignment_action_id

Line 10679: pay_payroll_actions ppa,

10675: CURSOR c_run_results_exist IS
10676: SELECT pty.pension_type_id
10677: ,pty.pension_sub_category sub_cat
10678: FROM pay_run_results prr,
10679: pay_payroll_actions ppa,
10680: pay_assignment_actions paa,
10681: pay_element_type_extra_info pei,
10682: pqp_pension_types_f pty
10683: WHERE paa.assignment_action_id = prr.assignment_action_id

Line 11950: pay_payroll_actions ppa,

11946: --cursor to check if run results exist for any IPAP Pension Types for this assignment
11947: CURSOR c_run_results_exist IS
11948: SELECT pty.pension_type_id
11949: FROM pay_run_results prr,
11950: pay_payroll_actions ppa,
11951: pay_assignment_actions paa,
11952: pay_element_type_extra_info pei,
11953: pqp_pension_types_f pty
11954: WHERE paa.assignment_action_id = prr.assignment_action_id

Line 12586: FROM pay_payroll_actions ppa,

12582: IF l_de_asg_act <> - 1 THEN
12583:
12584: SELECT date_earned
12585: INTO l_max_de
12586: FROM pay_payroll_actions ppa,
12587: pay_assignment_actions paa
12588: WHERE ppa.payroll_action_id = paa.payroll_action_id
12589: AND paa.assignment_action_id =l_de_asg_act;
12590: --

Line 13356: FROM pay_payroll_actions ppa,pay_assignment_actions paa

13352: --cursor to check if run results exist for any FUR Pension Types for this assignment
13353: --in this period
13354: CURSOR c_run_results_exist IS
13355: SELECT paa.assignment_action_id
13356: FROM pay_payroll_actions ppa,pay_assignment_actions paa
13357: WHERE paa.payroll_action_id = ppa.payroll_action_id
13358: AND ppa.date_earned BETWEEN g_extract_params(p_business_group_id).extract_start_date
13359: AND g_extract_params(p_business_group_id).extract_end_date
13360: AND paa.assignment_id = p_assignment_id

Line 13448: pay_payroll_actions ppa,

13444: CURSOR c_run_results_exist IS
13445: SELECT prr.assignment_action_id,
13446: pei.eei_information9
13447: FROM pay_run_results prr,
13448: pay_payroll_actions ppa,
13449: pay_assignment_actions paa,
13450: pay_element_type_extra_info pei,
13451: pqp_pension_types_f pty
13452: WHERE paa.assignment_action_id = prr.assignment_action_id

Line 13739: FROM pay_payroll_actions ppa,pay_assignment_actions paa

13735: --cursor to check if run results exist for any IPAP Pension Types for this assignment
13736: --in this period
13737: CURSOR c_run_results_exist IS
13738: SELECT paa.assignment_action_id
13739: FROM pay_payroll_actions ppa,pay_assignment_actions paa
13740: WHERE paa.payroll_action_id = ppa.payroll_action_id
13741: AND ppa.date_earned BETWEEN g_extract_params(p_business_group_id).extract_start_date
13742: AND g_extract_params(p_business_group_id).extract_end_date
13743: AND paa.assignment_id = p_assignment_id