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_ENTRIES_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 2041: pay_element_entries_f pee,

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
2044: pet.element_name = 'PGGM Pensions Part Time Percentage'
2045: and piv.name ='Part Time Percentage'

Line 2064: pay_element_entries_f pee,

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
2067: pet.element_name = 'Retro PGGM Pensions Part Time Percentage'
2068: and piv.name ='Part Time Percentage'

Line 2096: pay_element_entries_f pee,

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
2099: ( pet.element_name = 'Retro PGGM Pensions General Information'
2100: OR pet.element_name = 'Retro PGGM Pensions General Information Previous Year')

Line 2115: from pay_element_entries_f pee,

2111: --Cursor to check whether Pension Salary Current Year Retro Changes exists or not
2112: -- and fetch the difference in pension salary
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

Line 2138: from pay_element_entries_f pee,

2134: --Cursor to check whether Pension Salary Previous Year Retro Changes exists or not
2135: -- and fetch the difference in pension salary
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

Line 2160: from pay_element_entries_f pee,

2156: --Cursor to check whether Pension Salary Retro Changes exists or not
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

Line 2173: from pay_element_entries_f pee,

2169: --Cursor to check whether Pension Salary Retro Changes exists or not
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

Line 2188: pay_element_entries_f pee,

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
2191: pet.element_name = 'PGGM Pensions Part Time Percentage'
2192: and piv.name ='Part Time Percentage'

Line 2216: from pay_element_entries_f pee,

2212: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id;
2213:
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

Line 2242: pay_element_entries_f pee,

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
2245: pet.element_name = 'Retro PGGM Pensions Part Time Percentage'
2246: AND ( piv.name = 'Extra Hours'

Line 3304: pay_element_entries_f pee,

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
3307: pet.element_name = 'PGGM Pensions General Information'
3308: and piv.name ='Kind Of Participation'

Line 3548: pay_element_entries_f pee,

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
3551: pet.element_name = 'PGGM Pensions General Information'
3552: and piv.name ='PGGM Employee Number'

Line 3826: pay_element_entries_f pee,

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
3829: pet.element_name = 'PGGM Pensions General Information'
3830: and piv.name ='Reason Of Participation'

Line 3910: pay_element_entries_f pee,

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
3913: pet.element_name = 'PGGM Pensions Part Time Percentage'
3914: and piv.name ='Part Time Percentage'

Line 4160: from pay_element_entries_f pee,

4156: Return Number IS
4157: --Cursor to check for PGGM General Info Elements for the current period
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

Line 4180: from pay_element_entries_f pee,

4176:
4177: --Cursor to check for PGGM General Info Elements for the previous period
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

Line 4200: from pay_element_entries_f pee,

4196:
4197: --get the total value for Retro Previous year element
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

Line 4221: FROM pay_element_entries_f pee,

4217: -- Cursor to get the current year override for pension salary
4218: --
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'

Line 4512: from pay_element_entries_f pee,

4508: ,c_start_date DATE
4509: ,c_end_date DATE
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

Line 4533: from pay_element_entries_f pee,

4529: ,c_start_date DATE
4530: ,c_end_date DATE
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

Line 4554: from pay_element_entries_f pee,

4550: ,c_start_date DATE
4551: ,c_end_date DATE
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

Line 4608: FROM pay_element_entries_f pee,

4604: ,c_date_earned DATE
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

Line 4907: pay_element_entries_f pee,

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
4910: pet.element_name = 'PGGM Pensions Part Time Percentage'
4911: and piv.name ='Part Time Percentage'

Line 5410: pay_element_entries_f pee,

5406: /*
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'

Line 5423: pay_element_entries_f pee,

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
5426: pet.element_name = 'PGGM Pensions Part Time Percentage'
5427: and piv.name ='Part Time Percentage'

Line 5693: pay_element_entries_f pee,

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
5696: pet.element_name = 'PGGM Pensions Part Time Percentage'
5697: and piv.name ='Part Time Percentage'

Line 7092: from pay_element_entries_f pee,

7088: )
7089: RETURN Number IS
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

Line 7337: from pay_element_entries_f pee,

7333: ,p_data_element_value OUT NOCOPY Varchar2
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

Line 7409: from pay_element_entries_f pee,

7405: and g_extract_params(bg_id).extract_end_date );
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