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 923: FROM pay_run_results prr

919: -- ============================================================================
920: CURSOR c_get_retro_entry(c_element_type_id in number
921: ,c_assignment_action_id in number) IS
922: SELECT element_entry_id
923: FROM pay_run_results prr
924: WHERE prr.assignment_action_id = c_assignment_action_id
925: AND prr.element_type_id = c_element_type_id
926: ORDER BY element_entry_id;
927:

Line 936: FROM pay_run_results prr,

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

Line 999: FROM pay_run_results prr,

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

Line 1139: pay_run_results prr,

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

Line 2332: FROM pay_run_results

2328: ,p_element_type_id IN NUMBER ) RETURN BOOLEAN IS
2329:
2330: CURSOR c_ass_act IS
2331: SELECT 1
2332: FROM pay_run_results
2333: WHERE assignment_action_id = p_ass_act_id
2334: AND element_type_id = p_element_type_id;
2335:
2336: l_dummy NUMBER;

Line 9402: FROM pay_run_results prr,

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

Line 9928: FROM pay_run_results prr,

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

Line 10271: FROM pay_run_results prr,

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

Line 10414: FROM pay_run_results prr,

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

Line 11017: FROM pay_run_results prr,

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

Line 12318: FROM pay_run_results prr,

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

Line 13732: FROM pay_run_results

13728: AND g_extract_params(p_business_group_id).extract_end_date
13729: AND paa.assignment_id = p_assignment_id
13730: AND paa.assignment_action_id IN
13731: (SELECT assignment_action_id
13732: FROM pay_run_results
13733: WHERE element_type_id IN
13734: (SELECT element_type_id
13735: FROM pay_element_type_extra_info,pqp_pension_types_f pty
13736: WHERE information_type = 'PQP_NL_ABP_DEDUCTION'

Line 13816: FROM pay_run_results prr,

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

Line 14115: FROM pay_run_results

14111: AND g_extract_params(p_business_group_id).extract_end_date
14112: AND paa.assignment_id = p_assignment_id
14113: AND paa.assignment_action_id IN
14114: (SELECT assignment_action_id
14115: FROM pay_run_results
14116: WHERE element_type_id IN
14117: (SELECT element_type_id
14118: FROM pay_element_type_extra_info,pqp_pension_types_f pty
14119: WHERE information_type = 'PQP_NL_ABP_DEDUCTION'