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_TYPES_F

Line 378: pay_element_types_f pet

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
382: -- To_Date(pei.eei_information11,'DD/MM/RRRR')

Line 402: pay_element_types_f pet

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
406: To_Date(pei.eei_information11,'DD/MM/RRRR')

Line 426: pay_element_types_f pet

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
430: To_Date(pei.eei_information11,'DD/MM/RRRR')

Line 757: pay_element_types_f pet,

753: ,sum(fnd_number.canonical_to_number(peev.screen_entry_value)) amount
754: ,pty.ee_contribution_bal_type_id
755: ,pty.er_contribution_bal_type_id
756: FROM pay_element_type_extra_info pei,
757: pay_element_types_f pet,
758: pay_element_entries_f peef,
759: pay_element_links_f pelf,
760: pay_element_entry_values_f peev,
761: pay_input_values_f pivf,

Line 795: FROM pay_element_types_f pet1

791: AND component_name = 'Adjustment')
792: AND creator_type = 'ET'
793: AND (creator_id = pei.element_type_id OR
794: creator_id IN (SELECT element_type_id
795: FROM pay_element_types_f pet1
796: WHERE pet1.element_name = pei.eei_information9 || ' ABP Employer Pension Contribution'
797: AND pet1.business_group_id = pet.business_group_id))) )
798: AND pelf.element_type_id = pet.element_type_id
799: AND pivf.element_type_id = pet.element_type_id

Line 842: pay_element_types_f pet,

838: ,sum(fnd_number.canonical_to_number(peev.screen_entry_value)) amount
839: ,pty.ee_contribution_bal_type_id
840: ,pty.er_contribution_bal_type_id
841: FROM pay_element_type_extra_info pei,
842: pay_element_types_f pet,
843: pay_element_entries_f peef,
844: pay_element_links_f pelf,
845: pay_element_entry_values_f peev,
846: pay_input_values_f pivf,

Line 958: ,pay_element_types_f pet

954: ,c_input_value_name in varchar2) IS
955: SELECT piv.input_value_id
956: ,pet.element_type_id
957: FROM pay_input_values_f piv
958: ,pay_element_types_f pet
959: WHERE piv.name = c_input_value_name
960: AND piv.element_type_id = pet.element_type_id
961: AND pet.element_name = c_element_name;
962:

Line 2877: FROM pay_element_types_f

2873: AND peef.element_link_id = pelf.element_link_id
2874: AND peef.assignment_id = p_assignment_id
2875: AND pelf.element_type_id =
2876: (SELECT element_type_id
2877: FROM pay_element_types_f
2878: WHERE element_name = 'ABP Pensions'
2879: AND TRUNC(g_extract_params(p_business_group_id).extract_start_date)
2880: BETWEEN effective_start_date AND effective_end_date);
2881:

Line 3473: l_ele_type_id pay_element_types_f.element_type_id%TYPE;

3469: l_rec_12_amt_sent_prev_r NUMBER;
3470: l_sent_to_abp NUMBER;
3471: l_rej_hf_ee NUMBER;
3472: i per_all_assignments_f.business_group_id%TYPE;
3473: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
3474: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
3475: l_proc_name VARCHAR2(150) := g_proc_name ||'Populate_Record_Structures';
3476: l_assig_rec csr_assig%ROWTYPE;
3477: l_Chg_Evt_Exists Varchar2(2);

Line 3474: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;

3470: l_sent_to_abp NUMBER;
3471: l_rej_hf_ee NUMBER;
3472: i per_all_assignments_f.business_group_id%TYPE;
3473: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
3474: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
3475: l_proc_name VARCHAR2(150) := g_proc_name ||'Populate_Record_Structures';
3476: l_assig_rec csr_assig%ROWTYPE;
3477: l_Chg_Evt_Exists Varchar2(2);
3478: l_effective_date Date;

Line 3559: ,pay_element_types_f pet

3555: SELECT piv.input_value_id start_dt_id, piv1.input_value_id end_dt_id
3556: ,pet.element_type_id
3557: FROM pay_input_values_f piv
3558: ,pay_input_values_f piv1
3559: ,pay_element_types_f pet
3560: WHERE piv.name = 'Start Date'
3561: AND piv.element_type_id = pet.element_type_id
3562: AND piv1.name = 'End Date'
3563: AND piv1.element_type_id = pet.element_type_id

Line 5860: FROM pay_element_types_f petf

5856: g_extract_params(p_business_group_id).extract_end_date BETWEEN peef.EFFECTIVE_START_DATE AND peef.EFFECTIVE_END_DATE
5857: )
5858: AND EXISTS
5859: (SELECT 1
5860: FROM pay_element_types_f petf
5861: WHERE
5862: peef.element_type_id = petf.element_type_id
5863: AND UPPER(element_name) like '%RETRO%ABP%'
5864: AND (g_extract_params(p_business_group_id).extract_start_date BETWEEN petf.EFFECTIVE_START_DATE AND petf.EFFECTIVE_END_DATE

Line 10744: pay_element_types_f pet

10740: ,pei.eei_information18 cy_retro_ele
10741: ,pei.eei_information19 py_retro_ele
10742: ,pei.eei_information2 pt_id
10743: FROM pay_element_type_extra_info pei,
10744: pay_element_types_f pet
10745: WHERE pei.information_type = 'PQP_NL_ABP_DEDUCTION'
10746: AND pei.eei_information_category = 'PQP_NL_ABP_DEDUCTION'
10747: AND p_effective_date BETWEEN To_Date(pei.eei_information10,'DD/MM/RRRR') AND
10748: To_Date(pei.eei_information11,'DD/MM/RRRR')

Line 11239: FROM pay_element_types_f petf

11235:
11236: --13571541
11237: CURSOR c_rec05_curr_ptp_end_date IS
11238: SELECT 'Y'
11239: FROM pay_element_types_f petf
11240: ,pay_element_entries_f peef
11241: WHERE petf.element_name = 'ABP flex workers PTP End Date'
11242: AND petf.element_type_id = peef.element_type_id
11243: AND peef.assignment_id = p_assignment_id

Line 14716: l_ele_type_id pay_element_types_f.element_type_id%TYPE;

14712: ,p_person_id IN Number
14713: ,p_no_asg_action IN OUT NOCOPY Number
14714: ,p_error_message OUT NOCOPY Varchar2)IS
14715:
14716: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
14717: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
14718: l_valid_action Varchar2(2);
14719: i per_all_assignments_f.business_group_id%TYPE;
14720: l_ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE;

Line 14717: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;

14713: ,p_no_asg_action IN OUT NOCOPY Number
14714: ,p_error_message OUT NOCOPY Varchar2)IS
14715:
14716: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
14717: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
14718: l_valid_action Varchar2(2);
14719: i per_all_assignments_f.business_group_id%TYPE;
14720: l_ext_dfn_type pqp_extract_attributes.ext_dfn_type%TYPE;
14721: l_proc_name Varchar2(150) := g_proc_name ||'Create_Addl_Assignments';

Line 14853: l_ele_type_id pay_element_types_f.element_type_id%TYPE;

14849: ) RETURN Number IS
14850:
14851: l_return_value Number;
14852: i per_all_assignments_f.business_group_id%TYPE;
14853: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
14854: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
14855: l_valid_action Varchar2(2);
14856: l_no_asg_action Number(5) := 0;
14857: l_proc_name Varchar2(150) := g_proc_name ||'Process_Addl_Assigs';

Line 14854: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;

14850:
14851: l_return_value Number;
14852: i per_all_assignments_f.business_group_id%TYPE;
14853: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
14854: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
14855: l_valid_action Varchar2(2);
14856: l_no_asg_action Number(5) := 0;
14857: l_proc_name Varchar2(150) := g_proc_name ||'Process_Addl_Assigs';
14858: l_sec_assg_rec csr_sec_assg%ROWTYPE;