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_ELEMENT_TYPE_EXTRA_INFO

Line 377: FROM pay_element_type_extra_info pei,

373: AND short_name = 'Adjustment'
374: AND component_name = 'Adjustment')
375: AND creator_type = 'ET'
376: AND creator_id = pet.element_type_id) py_cy_adj_retro_element_id
377: FROM pay_element_type_extra_info pei,
378: pay_element_types_f pet
379: WHERE pei.information_type = 'PQP_NL_ABP_DEDUCTION'
380: AND pei.eei_information_category = 'PQP_NL_ABP_DEDUCTION'
381: -- AND c_effective_date BETWEEN To_Date(pei.eei_information10,'DD/MM/RRRR') AND

Line 401: FROM pay_element_type_extra_info pei,

397: ,'02' code
398: ,-1 defined_bal_id
399: ,pei.eei_information18 cy_retro_element_id
400: ,pei.eei_information19 py_retro_element_id
401: FROM pay_element_type_extra_info pei,
402: pay_element_types_f pet
403: WHERE pei.information_type = 'PQP_NL_ABP_DEDUCTION'
404: AND pei.eei_information_category = 'PQP_NL_ABP_DEDUCTION'
405: AND c_effective_date BETWEEN To_Date(pei.eei_information10,'DD/MM/RRRR') AND

Line 425: FROM pay_element_type_extra_info pei,

421: ,'99' code
422: ,-1 defined_bal_id
423: ,pei.eei_information18 cy_retro_element_id
424: ,pei.eei_information19 py_retro_element_id
425: FROM pay_element_type_extra_info pei,
426: pay_element_types_f pet
427: WHERE pei.information_type = 'PQP_NL_ABP_DEDUCTION'
428: AND pei.eei_information_category = 'PQP_NL_ABP_DEDUCTION'
429: AND c_effective_date BETWEEN To_Date(pei.eei_information10,'DD/MM/RRRR') AND

Line 737: FROM pay_element_type_extra_info pei,

733: ,'PPP',11) code
734: ,sum(fnd_number.canonical_to_number(peev.screen_entry_value)) amount
735: ,pty.ee_contribution_bal_type_id
736: ,pty.er_contribution_bal_type_id
737: FROM pay_element_type_extra_info pei,
738: pay_element_types_f pet,
739: pay_element_entries_f peef,
740: pay_element_links_f pelf,
741: pay_element_entry_values_f peev,

Line 822: FROM pay_element_type_extra_info pei,

818: ,9 code
819: ,sum(fnd_number.canonical_to_number(peev.screen_entry_value)) amount
820: ,pty.ee_contribution_bal_type_id
821: ,pty.er_contribution_bal_type_id
822: FROM pay_element_type_extra_info pei,
823: pay_element_types_f pet,
824: pay_element_entries_f peef,
825: pay_element_links_f pelf,
826: pay_element_entry_values_f peev,

Line 9066: pay_element_type_extra_info pei,

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
9069: AND paa.payroll_action_id = ppa.payroll_action_id
9070: AND ppa.date_earned BETWEEN g_extract_params(p_business_group_id).extract_start_date

Line 9592: pay_element_type_extra_info pei,

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
9595: AND paa.payroll_action_id = ppa.payroll_action_id
9596: AND ppa.date_earned BETWEEN g_extract_params(p_business_group_id).extract_start_date

Line 9935: pay_element_type_extra_info pei,

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
9938: AND paa.payroll_action_id = ppa.payroll_action_id
9939: AND ppa.date_earned BETWEEN g_extract_params(p_business_group_id).extract_start_date

Line 10078: pay_element_type_extra_info pei,

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
10081: AND paa.payroll_action_id = ppa.payroll_action_id
10082: AND ppa.date_earned BETWEEN g_extract_params(p_business_group_id).extract_start_date

Line 10404: FROM pay_element_type_extra_info pei,

10400: ,pei.eei_information12 sub_cat
10401: ,pei.eei_information18 cy_retro_ele
10402: ,pei.eei_information19 py_retro_ele
10403: ,pei.eei_information2 pt_id
10404: FROM pay_element_type_extra_info pei,
10405: pay_element_types_f pet
10406: WHERE pei.information_type = 'PQP_NL_ABP_DEDUCTION'
10407: AND pei.eei_information_category = 'PQP_NL_ABP_DEDUCTION'
10408: AND p_effective_date BETWEEN To_Date(pei.eei_information10,'DD/MM/RRRR') AND

Line 10681: pay_element_type_extra_info pei,

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
10684: AND paa.payroll_action_id = ppa.payroll_action_id
10685: AND ppa.date_earned BETWEEN g_extract_params(p_business_group_id).extract_start_date

Line 11952: pay_element_type_extra_info pei,

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
11955: AND paa.payroll_action_id = ppa.payroll_action_id
11956: AND ppa.date_earned BETWEEN g_extract_params(p_business_group_id).extract_start_date

Line 13366: FROM pay_element_type_extra_info,pqp_pension_types_f pty

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'
13368: AND eei_information_category = 'PQP_NL_ABP_DEDUCTION'
13369: AND eei_information2 = Fnd_Number.number_to_canonical(pty.pension_type_id)
13370: AND pty.pension_sub_category = 'FUR_S'

Line 13450: pay_element_type_extra_info pei,

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
13453: AND paa.payroll_action_id = ppa.payroll_action_id
13454: AND ppa.date_earned BETWEEN g_extract_params(p_business_group_id).extract_start_date

Line 13749: FROM pay_element_type_extra_info,pqp_pension_types_f pty

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'
13751: AND eei_information_category = 'PQP_NL_ABP_DEDUCTION'
13752: AND eei_information2 = Fnd_Number.number_to_canonical(pty.pension_type_id)
13753: AND pty.pension_sub_category = 'IPAP'