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_RUN_RESULTS

Line 904: FROM pay_run_results prr

900: -- ============================================================================
901: CURSOR c_get_retro_entry(c_element_type_id in number
902: ,c_assignment_action_id in number) IS
903: SELECT element_entry_id
904: FROM pay_run_results prr
905: WHERE prr.assignment_action_id = c_assignment_action_id
906: AND prr.element_type_id = c_element_type_id
907: ORDER BY element_entry_id;
908:

Line 917: FROM pay_run_results prr,

913: ,c_end_date in date
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

Line 980: FROM pay_run_results prr,

976: WHERE input_value_id = c_input_value_id
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

Line 1120: pay_run_results prr,

1116: ,fnd_number.canonical_to_number(prrv.result_value) ptp, 'Y' Yes
1117: FROM pay_element_entries_f peef,
1118: pay_element_links_f pelf,
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

Line 2311: FROM pay_run_results

2307: ,p_element_type_id IN NUMBER ) RETURN BOOLEAN IS
2308:
2309: CURSOR c_ass_act IS
2310: SELECT 1
2311: FROM pay_run_results
2312: WHERE assignment_action_id = p_ass_act_id
2313: AND element_type_id = p_element_type_id;
2314:
2315: l_dummy NUMBER;

Line 9063: FROM pay_run_results prr,

9059:
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

Line 9589: FROM pay_run_results prr,

9585:
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

Line 9932: FROM pay_run_results prr,

9928:
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

Line 10075: FROM pay_run_results prr,

10071: ,'FPU_E','C'
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

Line 10678: FROM pay_run_results prr,

10674: --
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

Line 11949: FROM pay_run_results prr,

11945:
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

Line 13363: FROM pay_run_results

13359: AND g_extract_params(p_business_group_id).extract_end_date
13360: AND paa.assignment_id = p_assignment_id
13361: AND paa.assignment_action_id IN
13362: (SELECT assignment_action_id
13363: FROM pay_run_results
13364: WHERE element_type_id IN
13365: (SELECT element_type_id
13366: FROM pay_element_type_extra_info,pqp_pension_types_f pty
13367: WHERE information_type = 'PQP_NL_ABP_DEDUCTION'

Line 13447: FROM pay_run_results prr,

13443: --in this period,and if so fetch the Scheme Prefix so that the basis balance name can be constructed
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

Line 13746: FROM pay_run_results

13742: AND g_extract_params(p_business_group_id).extract_end_date
13743: AND paa.assignment_id = p_assignment_id
13744: AND paa.assignment_action_id IN
13745: (SELECT assignment_action_id
13746: FROM pay_run_results
13747: WHERE element_type_id IN
13748: (SELECT element_type_id
13749: FROM pay_element_type_extra_info,pqp_pension_types_f pty
13750: WHERE information_type = 'PQP_NL_ABP_DEDUCTION'