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_ENTRY_VALUES_F

Line 2042: pay_element_entry_values_f peev

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'
2046: and piv.element_type_id=pet.element_type_id

Line 2065: pay_element_entry_values_f peev

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'
2069: and piv.element_type_id=pet.element_type_id

Line 2097: pay_element_entry_values_f peev

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')
2101: and piv.name ='Incidental Worker'

Line 2118: pay_element_entry_values_f peev

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'
2122: AND piv.element_type_id=pet.element_type_id

Line 2141: pay_element_entry_values_f peev

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'
2145: AND piv.element_type_id=pet.element_type_id

Line 2189: pay_element_entry_values_f peev

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'
2193: and piv.element_type_id=pet.element_type_id

Line 2219: pay_element_entry_values_f peev

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

Line 2243: pay_element_entry_values_f peev

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'
2247: OR piv.name = 'Hours Worked'

Line 3305: pay_element_entry_values_f peev

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'
3309: and piv.element_type_id=pet.element_type_id

Line 3549: pay_element_entry_values_f peev

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'
3553: and piv.element_type_id=pet.element_type_id

Line 3827: pay_element_entry_values_f peev

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'
3831: and piv.element_type_id=pet.element_type_id

Line 3911: pay_element_entry_values_f peev

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'
3915: and piv.element_type_id=pet.element_type_id

Line 4163: pay_element_entry_values_f peev

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'
4167: AND piv.element_type_id=pet.element_type_id

Line 4183: pay_element_entry_values_f peev

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'
4187: AND piv.element_type_id=pet.element_type_id

Line 4203: pay_element_entry_values_f peev

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'
4207: AND piv.element_type_id=pet.element_type_id

Line 4224: pay_element_entry_values_f peev

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
4228: AND pee.assignment_id = c_asg_id

Line 4515: pay_element_entry_values_f peev

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'
4519: and pee.assignment_id=c_assignment_id

Line 4536: pay_element_entry_values_f peev

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'
4540: and pee.assignment_id=c_assignment_id

Line 4557: pay_element_entry_values_f peev

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'
4561: and pee.assignment_id=c_assignment_id

Line 4908: pay_element_entry_values_f peev

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'
4912: and piv.element_type_id=pet.element_type_id

Line 5424: pay_element_entry_values_f peev

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'
5428: and piv.element_type_id=pet.element_type_id

Line 5694: pay_element_entry_values_f peev

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'
5698: and piv.element_type_id=pet.element_type_id

Line 7095: pay_element_entry_values_f peev

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