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_INPUT_VALUES_F

Line 2040: pay_input_values_f piv,

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

Line 2063: pay_input_values_f piv,

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

Line 2095: pay_input_values_f piv,

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

Line 2116: pay_input_values_f piv,

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
2120: pet.element_name ='Retro PGGM Pensions General Information'

Line 2139: pay_input_values_f piv,

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
2143: pet.element_name ='Retro PGGM Pensions General Information Previous Year'

Line 2187: pay_input_values_f piv,

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

Line 2217: pay_input_values_f piv,

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
2221: ( pet.element_name ='Retro PGGM Pensions General Information'

Line 2241: pay_input_values_f piv,

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
2245: pet.element_name = 'Retro PGGM Pensions Part Time Percentage'

Line 3303: pay_input_values_f piv,

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
3307: pet.element_name = 'PGGM Pensions General Information'

Line 3547: pay_input_values_f piv,

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
3551: pet.element_name = 'PGGM Pensions General Information'

Line 3825: pay_input_values_f piv,

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
3829: pet.element_name = 'PGGM Pensions General Information'

Line 3909: pay_input_values_f piv,

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

Line 4161: pay_input_values_f piv,

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
4165: pet.element_name ='Retro PGGM Pensions General Information'

Line 4181: pay_input_values_f piv,

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
4185: pet.element_name ='Retro PGGM Pensions General Information Previous Year'

Line 4201: pay_input_values_f piv,

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
4205: pet.element_name ='Retro PGGM Pensions General Information Previous Year'

Line 4222: pay_input_values_f piv,

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'
4226: AND piv.name = 'Annual Pension Salary'

Line 4513: pay_input_values_f piv,

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
4517: pet.element_name='Retro PGGM Pensions Part Time Percentage'

Line 4534: pay_input_values_f piv,

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
4538: pet.element_name='Retro PGGM Pensions Part Time Percentage'

Line 4555: pay_input_values_f piv,

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
4559: pet.element_name='Retro PGGM Pensions Part Time Percentage'

Line 4620: pay_input_values_f piv,

4616:
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'

Line 4906: pay_input_values_f piv,

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

Line 5068: pay_input_values_f piv,

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
5072: pet.element_name = 'PGGM Pensions General Information'

Line 5422: pay_input_values_f piv,

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

Line 5692: pay_input_values_f piv,

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

Line 7093: pay_input_values_f piv,

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
7097: ( pet.element_name ='Retro PGGM Pensions General Information'