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_PGGM_PENSION_EXTRACTS dependencies on PAY_ELEMENT_TYPES_F

Line 1192: FROM pay_element_types_f pet, pay_element_entries_f pee

1188: )
1189: RETURN NUMBER IS
1190: CURSOR csr_get_st_dt_of_ptp(c_asg_id IN Number,c_date_earned IN Date) IS
1191: SELECT to_char(pee.effective_start_date,'YYYYMMDD')
1192: FROM pay_element_types_f pet, pay_element_entries_f pee
1193: WHERE pet.element_name like 'PGGM Pensions General Information'
1194: AND pee.element_type_id =pet.element_type_id
1195: AND pee.assignment_id=c_asg_id
1196: AND pee.effective_start_date <= g_extract_params(p_business_group_id).extract_end_date;

Line 1461: l_ele_type_id pay_element_types_f.element_type_id %TYPE;

1457: ,p_person_id IN Number
1458: ,p_no_asg_action IN OUT NOCOPY Number
1459: ,p_error_message OUT NOCOPY Varchar2)IS
1460:
1461: l_ele_type_id pay_element_types_f.element_type_id %TYPE;
1462: l_prev_ele_type_id pay_element_types_f.element_type_id %TYPE;
1463: l_valid_action Varchar2(2);
1464: bg_id per_all_assignments_f.business_group_id%TYPE;
1465: l_ext_dfn_type pqp_extract_attributes.ext_dfn_type %TYPE;

Line 1462: l_prev_ele_type_id pay_element_types_f.element_type_id %TYPE;

1458: ,p_no_asg_action IN OUT NOCOPY Number
1459: ,p_error_message OUT NOCOPY Varchar2)IS
1460:
1461: l_ele_type_id pay_element_types_f.element_type_id %TYPE;
1462: l_prev_ele_type_id pay_element_types_f.element_type_id %TYPE;
1463: l_valid_action Varchar2(2);
1464: bg_id per_all_assignments_f.business_group_id%TYPE;
1465: l_ext_dfn_type pqp_extract_attributes.ext_dfn_type %TYPE;
1466: l_proc_name Varchar2(150) := g_proc_name ||'Create_Addl_Assignments';

Line 1610: l_ele_type_id pay_element_types_f.element_type_id %TYPE;

1606: ) RETURN Number IS
1607:
1608: l_return_value Number;
1609: bg_id per_all_assignments_f.business_group_id%TYPE;
1610: l_ele_type_id pay_element_types_f.element_type_id %TYPE;
1611: l_prev_ele_type_id pay_element_types_f.element_type_id %TYPE;
1612: l_valid_action Varchar2(2);
1613: l_no_asg_action Number(5) := 0;
1614: l_proc_name Varchar2(150) := g_proc_name ||'Process_Addl_Assigs';

Line 1611: l_prev_ele_type_id pay_element_types_f.element_type_id %TYPE;

1607:
1608: l_return_value Number;
1609: bg_id per_all_assignments_f.business_group_id%TYPE;
1610: l_ele_type_id pay_element_types_f.element_type_id %TYPE;
1611: l_prev_ele_type_id pay_element_types_f.element_type_id %TYPE;
1612: l_valid_action Varchar2(2);
1613: l_no_asg_action Number(5) := 0;
1614: l_proc_name Varchar2(150) := g_proc_name ||'Process_Addl_Assigs';
1615: l_sec_assg_rec csr_sec_assg%ROWTYPE;

Line 2039: pay_element_types_f pet,

2035: CURSOR csr_chk_curr_ptp_ele(c_asg_id NUMBER,bg_id NUMBER) IS
2036: SELECT peev.element_entry_value_id,
2037: peev.screen_entry_value,peev.effective_start_date,peev.effective_end_date
2038: FROM
2039: pay_element_types_f pet,
2040: pay_input_values_f piv,
2041: pay_element_entries_f pee,
2042: pay_element_entry_values_f peev
2043: WHERE

Line 2062: pay_element_types_f pet,

2058: CURSOR csr_chk_retro_ptp_ele(c_asg_id NUMBER,bg_id NUMBER) IS
2059: SELECT peev.element_entry_value_id,
2060: peev.screen_entry_value,pee.source_start_date
2061: FROM
2062: pay_element_types_f pet,
2063: pay_input_values_f piv,
2064: pay_element_entries_f pee,
2065: pay_element_entry_values_f peev
2066: WHERE

Line 2094: pay_element_types_f pet,

2090: ------in a sorted order
2091: CURSOR csr_chk_retro_inci_code_ele(c_asg_id NUMBER,bg_id NUMBER) IS
2092: SELECT peev.screen_entry_value,pee.source_start_date
2093: FROM
2094: pay_element_types_f pet,
2095: pay_input_values_f piv,
2096: pay_element_entries_f pee,
2097: pay_element_entry_values_f peev
2098: WHERE

Line 2117: pay_element_types_f pet,

2113: CURSOR csr_get_060_curr_retro_val(c_asg_id Number,c_eff_date Date) IS
2114: Select peev.screen_entry_value,pee.element_entry_id
2115: from pay_element_entries_f pee,
2116: pay_input_values_f piv,
2117: pay_element_types_f pet,
2118: pay_element_entry_values_f peev
2119: where
2120: pet.element_name ='Retro PGGM Pensions General Information'
2121: AND piv.name = 'Annual Pension Salary'

Line 2140: pay_element_types_f pet,

2136: CURSOR csr_get_060_prev_retro_val(c_asg_id Number,c_eff_date Date) IS
2137: Select peev.screen_entry_value,pee.element_entry_id
2138: from pay_element_entries_f pee,
2139: pay_input_values_f piv,
2140: pay_element_types_f pet,
2141: pay_element_entry_values_f peev
2142: where
2143: pet.element_name ='Retro PGGM Pensions General Information Previous Year'
2144: AND piv.name = 'Annual Pension Salary'

Line 2161: pay_element_types_f pet

2157: --and fetch the orginal date earned
2158: CURSOR csr_get_060_curr_retro_date(c_asg_id Number,c_eff_date Date) IS
2159: Select to_char(pee.source_start_date,'YYYYMMDD') source_start_date ,pee.element_entry_id
2160: from pay_element_entries_f pee,
2161: pay_element_types_f pet
2162: where
2163: pet.element_name ='Retro PGGM Pensions General Information'
2164: AND pee.assignment_id=c_asg_id
2165: AND pee.element_type_id =pet.element_type_id

Line 2174: pay_element_types_f pet

2170: --and fetch the orginal date earned
2171: CURSOR csr_get_060_prev_retro_date(c_asg_id Number,c_eff_date Date) IS
2172: Select to_char(pee.source_start_date,'YYYYMMDD') source_start_date ,pee.element_entry_id
2173: from pay_element_entries_f pee,
2174: pay_element_types_f pet
2175: where
2176: pet.element_name ='Retro PGGM Pensions General Information Previous Year'
2177: AND pee.assignment_id=c_asg_id
2178: AND pee.element_type_id =pet.element_type_id

Line 2186: pay_element_types_f pet,

2182: ------Cursor to check whether there is any change in part time percentage
2183: CURSOR csr_chk_prev_ptp_ele(c_asg_id NUMBER,bg_id NUMBER,c_date DATE) IS
2184: SELECT peev.screen_entry_value
2185: FROM
2186: pay_element_types_f pet,
2187: pay_input_values_f piv,
2188: pay_element_entries_f pee,
2189: pay_element_entry_values_f peev
2190: WHERE

Line 2218: pay_element_types_f pet,

2214: Cursor csr_retro_pggm_gen_info_iwc IS
2215: Select 'x'
2216: from pay_element_entries_f pee,
2217: pay_input_values_f piv,
2218: pay_element_types_f pet,
2219: pay_element_entry_values_f peev
2220: where
2221: ( pet.element_name ='Retro PGGM Pensions General Information'
2222: OR pet.element_name ='Retro PGGM Pensions General Information Previous Year')

Line 2240: pay_element_types_f pet,

2236: --Record 081 triggering condition
2237: CURSOR csr_get_081_retro_values(c_asg_id NUMBER,bg_id NUMBER,c_date DATE) IS
2238: SELECT distinct to_char(pee.source_start_date,'YYYY') year_of_change
2239: FROM
2240: pay_element_types_f pet,
2241: pay_input_values_f piv,
2242: pay_element_entries_f pee,
2243: pay_element_entry_values_f peev
2244: WHERE

Line 2270: l_ele_type_id pay_element_types_f.element_type_id%TYPE;

2266: l_ext_rslt_id ben_ext_rslt.ext_rslt_id%TYPE;
2267: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;
2268: l_return_value Varchar2(2) :='N';
2269: l_valid_action Varchar2(2);
2270: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
2271: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
2272: l_proc_name Varchar2(150) := g_proc_name ||'Pension_Criteria_Full_Profile';
2273: l_assig_rec csr_assig%ROWTYPE;
2274: l_Chg_Evt_Exists Varchar2(2);

Line 2271: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;

2267: l_ext_dfn_id ben_ext_dfn.ext_dfn_id%TYPE;
2268: l_return_value Varchar2(2) :='N';
2269: l_valid_action Varchar2(2);
2270: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
2271: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
2272: l_proc_name Varchar2(150) := g_proc_name ||'Pension_Criteria_Full_Profile';
2273: l_assig_rec csr_assig%ROWTYPE;
2274: l_Chg_Evt_Exists Varchar2(2);
2275: l_effective_date Date;

Line 3302: pay_element_types_f pet,

3298: Return Number IS
3299: CURSOR csr_get_kind_of_ptp(c_asg_id IN Number,c_date_earned IN DATE) IS
3300: SELECT peev.screen_entry_value
3301: FROM
3302: pay_element_types_f pet,
3303: pay_input_values_f piv,
3304: pay_element_entries_f pee,
3305: pay_element_entry_values_f peev
3306: WHERE

Line 3546: pay_element_types_f pet,

3542: CURSOR csr_get_pggm_ee_num(c_asg_id IN Number,c_date_earned IN DATE)
3543: IS
3544: SELECT substr(NVL(peev.screen_entry_value,'0'),1,3)
3545: FROM
3546: pay_element_types_f pet,
3547: pay_input_values_f piv,
3548: pay_element_entries_f pee,
3549: pay_element_entry_values_f peev
3550: WHERE

Line 3824: pay_element_types_f pet,

3820:
3821: CURSOR csr_get_reason_of_ptp(c_asg_id IN Number,c_date_earned IN DATE) IS
3822: SELECT peev.screen_entry_value
3823: FROM
3824: pay_element_types_f pet,
3825: pay_input_values_f piv,
3826: pay_element_entries_f pee,
3827: pay_element_entry_values_f peev
3828: WHERE

Line 3908: pay_element_types_f pet,

3904: --Pick PTP from element entry level
3905: CURSOR csr_get_overide_ptp_val(c_asg_id IN Number,c_date_earned IN DATE) IS
3906: SELECT peev.screen_entry_value
3907: FROM
3908: pay_element_types_f pet,
3909: pay_input_values_f piv,
3910: pay_element_entries_f pee,
3911: pay_element_entry_values_f peev
3912: WHERE

Line 4162: pay_element_types_f pet,

4158: CURSOR csr_chk_curr_year_pen_sal_chg(c_asg_id Number,c_start_date DATE) IS
4159: Select 'x'
4160: from pay_element_entries_f pee,
4161: pay_input_values_f piv,
4162: pay_element_types_f pet,
4163: pay_element_entry_values_f peev
4164: where
4165: pet.element_name ='Retro PGGM Pensions General Information'
4166: AND piv.name = 'Annual Pension Salary'

Line 4182: pay_element_types_f pet,

4178: CURSOR csr_chk_prev_year_pen_sal_chg(c_asg_id Number,c_start_date DATE) IS
4179: Select 'x'
4180: from pay_element_entries_f pee,
4181: pay_input_values_f piv,
4182: pay_element_types_f pet,
4183: pay_element_entry_values_f peev
4184: where
4185: pet.element_name ='Retro PGGM Pensions General Information Previous Year'
4186: AND piv.name = 'Annual Pension Salary'

Line 4202: pay_element_types_f pet,

4198: Cursor csr_total_chg_val(c_asg_id NUMBER,c_start_date DATE,c_end_date DATE) IS
4199: Select count(to_number(peev.screen_entry_value))
4200: from pay_element_entries_f pee,
4201: pay_input_values_f piv,
4202: pay_element_types_f pet,
4203: pay_element_entry_values_f peev
4204: where
4205: pet.element_name ='Retro PGGM Pensions General Information Previous Year'
4206: AND piv.name = 'Annual Pension Salary'

Line 4223: pay_element_types_f pet,

4219: CURSOR csr_curr_year_pen_sal_or(c_asg_id Number,c_start_date DATE) IS
4220: SELECT CEIL(fnd_number.canonical_to_number(peev.screen_entry_value))
4221: FROM pay_element_entries_f pee,
4222: pay_input_values_f piv,
4223: pay_element_types_f pet,
4224: pay_element_entry_values_f peev
4225: WHERE pet.element_name ='PGGM Pensions General Information'
4226: AND piv.name = 'Annual Pension Salary'
4227: AND piv.element_type_id = pet.element_type_id

Line 4514: pay_element_types_f pet,

4510: ) IS
4511: Select sum(to_number(NVL(peev.screen_entry_value,0)))
4512: from pay_element_entries_f pee,
4513: pay_input_values_f piv,
4514: pay_element_types_f pet,
4515: pay_element_entry_values_f peev
4516: where
4517: pet.element_name='Retro PGGM Pensions Part Time Percentage'
4518: and piv.name='Hours Worked'

Line 4535: pay_element_types_f pet,

4531: ) IS
4532: Select sum(to_number(NVL(peev.screen_entry_value,0)))
4533: from pay_element_entries_f pee,
4534: pay_input_values_f piv,
4535: pay_element_types_f pet,
4536: pay_element_entry_values_f peev
4537: where
4538: pet.element_name='Retro PGGM Pensions Part Time Percentage'
4539: and piv.name='Total Hours'

Line 4556: pay_element_types_f pet,

4552: ) IS
4553: Select sum(to_number(NVL(peev.screen_entry_value,0)))
4554: from pay_element_entries_f pee,
4555: pay_input_values_f piv,
4556: pay_element_types_f pet,
4557: pay_element_entry_values_f peev
4558: where
4559: pet.element_name='Retro PGGM Pensions Part Time Percentage'
4560: and piv.name='Extra Hours'

Line 4609: pay_element_types_f pet

4605: )
4606: IS
4607: SELECT pee.element_entry_id
4608: FROM pay_element_entries_f pee,
4609: pay_element_types_f pet
4610: WHERE
4611: pet.element_name='PGGM Pensions Part Time Percentage'
4612: AND pee.assignment_id=c_assignment_id
4613: AND pet.element_type_id =pee.element_type_id

Line 4621: pay_element_types_f pet

4617: CURSOR csr_get_input_val_id
4618: IS
4619: SELECT piv.input_value_id FROM
4620: pay_input_values_f piv,
4621: pay_element_types_f pet
4622: WHERE
4623: pet.element_name = 'PGGM Pensions Part Time Percentage'
4624: AND piv.name ='Extra Hours'
4625: AND piv.element_type_id =pet.element_type_id;

Line 4905: pay_element_types_f pet,

4901: --Pick PTP from element entry level
4902: CURSOR csr_get_ptp_val(c_asg_id IN Number,c_date_earned IN DATE) IS
4903: SELECT peev.screen_entry_value
4904: FROM
4905: pay_element_types_f pet,
4906: pay_input_values_f piv,
4907: pay_element_entries_f pee,
4908: pay_element_entry_values_f peev
4909: WHERE

Line 5067: pay_element_types_f pet,

5063:
5064: /*
5065: SELECT prrv.result_value
5066: FROM
5067: pay_element_types_f pet,
5068: pay_input_values_f piv,
5069: pay_run_results prr,
5070: pay_run_result_values prrv
5071: WHERE

Line 5411: pay_element_types_f pet

5407: CURSOR csr_chk_retro_ptp_ele(c_asg_id NUMBER,bg_id NUMBER) IS
5408: Select pee.screen_entry_value,pee.effective_start_date
5409: FROM
5410: pay_element_entries_f pee,
5411: pay_element_types_f pet
5412: where pee.assignment_id = c_asg_id
5413: AND pee.element_type_id =pet.element_type_id
5414: AND pet.element_name='Retro PGGM Pensions Part Time Percentage'
5415: AND g_extract_params(bg_id).extract_start_date

Line 5421: pay_element_types_f pet,

5417:
5418: CURSOR csr_chk_curr_ptp_ele(c_asg_id NUMBER,bg_id NUMBER) IS
5419: SELECT pee.screen_entry_value,pee.effective_start_date
5420: FROM
5421: pay_element_types_f pet,
5422: pay_input_values_f piv,
5423: pay_element_entries_f pee,
5424: pay_element_entry_values_f peev
5425: WHERE

Line 5691: pay_element_types_f pet,

5687: ------Cursor to check whether there is any change in part time percentage
5688: CURSOR csr_chk_prev_ptp_ele(c_asg_id NUMBER,bg_id NUMBER,c_date DATE) IS
5689: SELECT peev.screen_entry_value
5690: FROM
5691: pay_element_types_f pet,
5692: pay_input_values_f piv,
5693: pay_element_entries_f pee,
5694: pay_element_entry_values_f peev
5695: WHERE

Line 7094: pay_element_types_f pet,

7090: Cursor csr_retro_pggm_gen_info_entry IS
7091: Select 'x'
7092: from pay_element_entries_f pee,
7093: pay_input_values_f piv,
7094: pay_element_types_f pet,
7095: pay_element_entry_values_f peev
7096: where
7097: ( pet.element_name ='Retro PGGM Pensions General Information'
7098: OR pet.element_name ='Retro PGGM Pensions General Information Previous Year')

Line 7338: pay_element_types_f pet

7334: ) RETURN Number IS
7335: Cursor csr_retro_pggm_ptp_entry IS
7336: Select 'x'
7337: from pay_element_entries_f pee,
7338: pay_element_types_f pet
7339: where pet.element_name='Retro PGGM Pensions Part Time Percentage Information Element'
7340: and pee.assignment_id=p_assignment_id
7341: and pet.element_type_id =pee.element_type_id
7342: and p_effective_date between pee.effective_start_date

Line 7410: pay_element_types_f pet

7406: /*
7407: Cursor csr_retro_pggm_ptp_entry(c_assignment_id NUMBER) IS
7408: Select 'x'
7409: from pay_element_entries_f pee,
7410: pay_element_types_f pet
7411: where pet.element_name='Retro PGGM Pensions Part Time Percentage'
7412: and pee.assignment_id=c_assignment_id
7413: and pet.element_type_id =pee.element_type_id
7414: and ( pee.effective_start_date between g_extract_params(p_business_group_id).extract_start_date