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 937: pay_payroll_actions ppa,

933: ,c_assignment_id in number
934: ,c_element_type_id in number) IS
935: SELECT element_entry_id
936: FROM pay_run_results prr,
937: pay_payroll_actions ppa,
938: pay_assignment_actions paa
939: WHERE paa.assignment_action_id = prr.assignment_action_id
940: AND paa.payroll_action_id = ppa.payroll_action_id
941: AND ppa.date_earned BETWEEN c_start_date

Line 1000: pay_payroll_actions ppa,

996: AND screen_entry_value IS NOT NULL
997: AND element_entry_id IN
998: (SELECT element_entry_id
999: FROM pay_run_results prr,
1000: pay_payroll_actions ppa,
1001: pay_assignment_actions paa
1002: WHERE paa.assignment_action_id = prr.assignment_action_id
1003: AND paa.payroll_action_id = ppa.payroll_action_id
1004: AND ppa.date_earned BETWEEN c_start_date

Line 1142: pay_payroll_actions ppa

1138: pay_element_entry_values_f peev,
1139: pay_run_results prr,
1140: pay_run_result_values prrv,
1141: pay_assignment_actions paa,
1142: pay_payroll_actions ppa
1143: WHERE ppa.date_earned BETWEEN peef.effective_start_date AND
1144: peef.effective_end_date
1145: AND ppa.date_earned BETWEEN pelf.effective_start_date AND
1146: pelf.effective_end_date

Line 5836: ,pay_payroll_actions ppa

5832: CURSOR c_is_payroll_run(p_asg_id NUMBER, p_bg_id NUMBER, p_payroll_id number, p_cons_id number)
5833: IS
5834: SELECT 1
5835: FROM pay_assignment_actions paa
5836: ,pay_payroll_actions ppa
5837: WHERE paa.assignment_id = p_asg_id
5838: AND ppa.BUSINESS_GROUP_ID = p_bg_id
5839: AND ppa.action_status = 'C'
5840: AND ppa.action_type IN ('Q','R')

Line 9403: pay_payroll_actions ppa,

9399: --cursor to check if run results exist for any FUR/IPAP Pension Types for this assignment
9400: CURSOR c_run_results_exist IS
9401: SELECT pty.pension_type_id
9402: FROM pay_run_results prr,
9403: pay_payroll_actions ppa,
9404: pay_assignment_actions paa,
9405: pay_element_type_extra_info pei,
9406: pqp_pension_types_f pty
9407: WHERE paa.assignment_action_id = prr.assignment_action_id

Line 9929: pay_payroll_actions ppa,

9925: --cursor to check if run results exist for any FUR Pension Types for this assignment
9926: CURSOR c_run_results_exist IS
9927: SELECT pty.pension_type_id
9928: FROM pay_run_results prr,
9929: pay_payroll_actions ppa,
9930: pay_assignment_actions paa,
9931: pay_element_type_extra_info pei,
9932: pqp_pension_types_f pty
9933: WHERE paa.assignment_action_id = prr.assignment_action_id

Line 10272: pay_payroll_actions ppa,

10268: /* Cursor changed for 6670714
10269: CURSOR c_rr_cur IS
10270: SELECT 1
10271: FROM pay_run_results prr,
10272: pay_payroll_actions ppa,
10273: pay_assignment_actions paa,
10274: pay_element_type_extra_info pei,
10275: pqp_pension_types_f pty
10276: WHERE paa.assignment_action_id = prr.assignment_action_id

Line 10415: pay_payroll_actions ppa,

10411: ,'FPU_R','A'
10412: ,'FPU_S','S'
10413: ,'FPU_T' ,'B') fpu_code
10414: FROM pay_run_results prr,
10415: pay_payroll_actions ppa,
10416: pay_assignment_actions paa,
10417: pay_element_type_extra_info pei,
10418: pqp_pension_types_f pty
10419: WHERE paa.assignment_action_id = prr.assignment_action_id

Line 11018: pay_payroll_actions ppa,

11014: CURSOR c_run_results_exist IS
11015: SELECT pty.pension_type_id
11016: ,pty.pension_sub_category sub_cat
11017: FROM pay_run_results prr,
11018: pay_payroll_actions ppa,
11019: pay_assignment_actions paa,
11020: pay_element_type_extra_info pei,
11021: pqp_pension_types_f pty
11022: WHERE paa.assignment_action_id = prr.assignment_action_id

Line 12319: pay_payroll_actions ppa,

12315: --cursor to check if run results exist for any IPAP Pension Types for this assignment
12316: CURSOR c_run_results_exist IS
12317: SELECT pty.pension_type_id
12318: FROM pay_run_results prr,
12319: pay_payroll_actions ppa,
12320: pay_assignment_actions paa,
12321: pay_element_type_extra_info pei,
12322: pqp_pension_types_f pty
12323: WHERE paa.assignment_action_id = prr.assignment_action_id

Line 12955: FROM pay_payroll_actions ppa,

12951: IF l_de_asg_act <> - 1 THEN
12952:
12953: SELECT date_earned
12954: INTO l_max_de
12955: FROM pay_payroll_actions ppa,
12956: pay_assignment_actions paa
12957: WHERE ppa.payroll_action_id = paa.payroll_action_id
12958: AND paa.assignment_action_id =l_de_asg_act;
12959: --

Line 13725: FROM pay_payroll_actions ppa,pay_assignment_actions paa

13721: --cursor to check if run results exist for any FUR Pension Types for this assignment
13722: --in this period
13723: CURSOR c_run_results_exist IS
13724: SELECT paa.assignment_action_id
13725: FROM pay_payroll_actions ppa,pay_assignment_actions paa
13726: WHERE paa.payroll_action_id = ppa.payroll_action_id
13727: AND ppa.date_earned BETWEEN g_extract_params(p_business_group_id).extract_start_date
13728: AND g_extract_params(p_business_group_id).extract_end_date
13729: AND paa.assignment_id = p_assignment_id

Line 13817: pay_payroll_actions ppa,

13813: CURSOR c_run_results_exist IS
13814: SELECT prr.assignment_action_id,
13815: pei.eei_information9
13816: FROM pay_run_results prr,
13817: pay_payroll_actions ppa,
13818: pay_assignment_actions paa,
13819: pay_element_type_extra_info pei,
13820: pqp_pension_types_f pty
13821: WHERE paa.assignment_action_id = prr.assignment_action_id

Line 14108: FROM pay_payroll_actions ppa,pay_assignment_actions paa

14104: --cursor to check if run results exist for any IPAP Pension Types for this assignment
14105: --in this period
14106: CURSOR c_run_results_exist IS
14107: SELECT paa.assignment_action_id
14108: FROM pay_payroll_actions ppa,pay_assignment_actions paa
14109: WHERE paa.payroll_action_id = ppa.payroll_action_id
14110: AND ppa.date_earned BETWEEN g_extract_params(p_business_group_id).extract_start_date
14111: AND g_extract_params(p_business_group_id).extract_end_date
14112: AND paa.assignment_id = p_assignment_id