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.PAY_KR_FF_FUNCTIONS_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 1779: ,pay_element_types_f pet

1775: ,pay_run_result_values prrv
1776: ,pay_run_results prr
1777: ,pay_payroll_actions ppa
1778: ,pay_assignment_actions paa
1779: ,pay_element_types_f pet
1780: WHERE paa.assignment_action_id = l_assignment_action_id
1781: and ppa.payroll_action_id = paa.payroll_action_id
1782: and prr.assignment_action_id = paa.assignment_action_id
1783: and prr.status in ('P', 'PA')

Line 1963: ,pay_element_types_f pet

1959: ,pay_run_result_values prrv
1960: ,pay_run_results prr
1961: ,pay_payroll_actions ppa
1962: ,pay_assignment_actions paa
1963: ,pay_element_types_f pet
1964: WHERE paa.assignment_action_id = l_assignment_action_id
1965: and ppa.payroll_action_id = paa.payroll_action_id
1966: and prr.assignment_action_id = paa.assignment_action_id
1967: and prr.status in ('P', 'PA')

Line 2013: ,pay_element_types_f pet

2009: ,pay_run_result_values prrv
2010: ,pay_run_results prr
2011: ,pay_payroll_actions ppa
2012: ,pay_assignment_actions paa
2013: ,pay_element_types_f pet
2014: WHERE paa.assignment_action_id = l_assignment_action_id
2015: and ppa.payroll_action_id = paa.payroll_action_id
2016: and prr.assignment_action_id = paa.assignment_action_id
2017: and prr.status in ('P', 'PA')

Line 2065: ,pay_element_types_f pet

2061: ,pay_run_result_values prrv
2062: ,pay_run_results prr
2063: ,pay_payroll_actions ppa
2064: ,pay_assignment_actions paa
2065: ,pay_element_types_f pet
2066: WHERE paa.assignment_action_id = l_assignment_action_id
2067: and ppa.payroll_action_id = paa.payroll_action_id
2068: and prr.assignment_action_id = paa.assignment_action_id
2069: and prr.status in ('P', 'PA')

Line 2115: ,pay_element_types_f pet

2111: ,pay_run_result_values prrv
2112: ,pay_run_results prr
2113: ,pay_payroll_actions ppa
2114: ,pay_assignment_actions paa
2115: ,pay_element_types_f pet
2116: WHERE paa.assignment_action_id = l_assignment_action_id
2117: and ppa.payroll_action_id = paa.payroll_action_id
2118: and prr.assignment_action_id = paa.assignment_action_id
2119: and prr.status in ('P', 'PA')

Line 2192: pay_element_types_f petf,

2188: SELECT peevf.element_entry_id element_entry_id,
2189: sum(peevf.screen_entry_value) prev_earnings
2190: FROM pay_element_entry_values_f peevf,
2191: pay_element_entries_f peef,
2192: pay_element_types_f petf,
2193: pay_input_values_f pivf
2194: WHERE peevf.element_entry_id = peef.element_entry_id
2195: and peevf.element_entry_id = nvl(l_element_entry_id,peevf.element_entry_id)
2196: and peef.element_type_id = petf.element_type_id

Line 2214: pay_element_types_f petf,

2210: cursor get_prev_non_stat_sp_earn(l_effective_date in date, l_assignment_id in number, l_element_entry_id in number) is
2211: SELECT peevf.screen_entry_value prev_earnings
2212: FROM pay_element_entry_values_f peevf,
2213: pay_element_entries_f peef,
2214: pay_element_types_f petf,
2215: pay_input_values_f pivf
2216: WHERE peevf.element_entry_id = peef.element_entry_id
2217: and peevf.element_entry_id = nvl(l_element_entry_id,peevf.element_entry_id)
2218: and peef.element_type_id = petf.element_type_id

Line 2235: pay_element_types_f petf,

2231: cursor get_eligible_earnings(l_effective_date in date, l_assignment_id in number) is
2232: SELECT peevf.element_entry_id element_entry_id
2233: FROM pay_element_entry_values_f peevf,
2234: pay_element_entries_f peef,
2235: pay_element_types_f petf,
2236: pay_input_values_f pivf
2237: WHERE peevf.element_entry_id = peef.element_entry_id
2238: and peef.element_type_id = petf.element_type_id
2239: and petf.element_name LIKE 'PREV_ER_INFO'

Line 2257: pay_element_types_f petf,

2253: cursor get_prev_hire_leave_dt(l_effective_date in date, l_assignment_id in number, l_element_entry_id in number) is
2254: SELECT fnd_date.canonical_to_date(peevf.screen_entry_value) dt_value
2255: FROM pay_element_entry_values_f peevf,
2256: pay_element_entries_f peef,
2257: pay_element_types_f petf,
2258: pay_input_values_f pivf
2259: WHERE peevf.element_entry_id = peef.element_entry_id
2260: and peevf.element_entry_id = nvl(l_element_entry_id,peevf.element_entry_id)
2261: and peef.element_type_id = petf.element_type_id

Line 2280: pay_element_types_f petf,

2276: cursor get_prev_bus_reg_num_sep (l_effective_date in date, l_assignment_id in number, l_element_entry_id in number) is
2277: SELECT peevf.element_entry_id element_entry_id
2278: FROM pay_element_entry_values_f peevf,
2279: pay_element_entries_f peef,
2280: pay_element_types_f petf,
2281: pay_input_values_f pivf
2282: WHERE peevf.element_entry_id = peef.element_entry_id
2283: and peef.element_type_id = petf.element_type_id
2284: and petf.element_name LIKE 'PREV_SEP_PENS_DTLS'

Line 2297: pay_element_types_f petf,

2293: and l_effective_date BETWEEN pivf.effective_start_date AND pivf.effective_end_date
2294: and peevf.screen_entry_value in (SELECT peevf.screen_entry_value bus_reg_num
2295: FROM pay_element_entry_values_f peevf,
2296: pay_element_entries_f peef,
2297: pay_element_types_f petf,
2298: pay_input_values_f pivf
2299: WHERE peevf.element_entry_id = peef.element_entry_id
2300: and peevf.element_entry_id = nvl(l_element_entry_id,peevf.element_entry_id)
2301: and peef.element_type_id = petf.element_type_id

Line 2321: pay_element_types_f petf,

2317: cursor get_prev_emp_amt (l_effective_date in date, l_assignment_id in number, l_element_entry_id in number) is
2318: SELECT nvl(peevf.screen_entry_value,0) entry_value
2319: FROM pay_element_entry_values_f peevf,
2320: pay_element_entries_f peef,
2321: pay_element_types_f petf,
2322: pay_input_values_f pivf
2323: WHERE peevf.element_entry_id = peef.element_entry_id
2324: and peevf.element_entry_id = nvl(l_element_entry_id,peevf.element_entry_id)
2325: and peef.element_type_id = petf.element_type_id

Line 2341: from pay_element_types_f petf,

2337:
2338: /* Bug 8601387: 2009 Non Statutory Separation Pay Tax Receipt Layout Updates */
2339: cursor csr_prev_lsa(l_element_entry_id in number,l_assignment_action_id in number) is
2340: select nvl(result_value,0) result_value
2341: from pay_element_types_f petf,
2342: pay_run_results prr,
2343: pay_run_result_values prrv,
2344: pay_element_entries_f peef
2345: where petf.element_name = 'PREV_EMP_SEP_LUMP_SUM_AMOUNT'

Line 3908: pay_element_types_f petf,

3904: SELECT peevf.element_entry_id element_entry_id,
3905: peevf.screen_entry_value interim_date
3906: FROM pay_element_entry_values_f peevf,
3907: pay_element_entries_f peef,
3908: pay_element_types_f petf,
3909: pay_input_values_f pivf
3910: WHERE peevf.element_entry_id = peef.element_entry_id
3911: and peef.element_type_id = petf.element_type_id
3912: and petf.element_name LIKE 'PREV_ER_INFO'

Line 3927: pay_element_types_f petf,

3923: cursor prev_spl_sep_alw(l_effective_date in date, l_assignment_id in number, l_element_entry_id number) is
3924: SELECT sum(nvl(peevf.screen_entry_value,0)) non_stat_earnings
3925: FROM pay_element_entry_values_f peevf,
3926: pay_element_entries_f peef,
3927: pay_element_types_f petf,
3928: pay_input_values_f pivf
3929: WHERE peevf.element_entry_id = peef.element_entry_id
3930: and peevf.element_entry_id = l_element_entry_id
3931: and peef.element_type_id = petf.element_type_id

Line 3947: pay_element_types_f petf,

3943: cursor get_prev_sep_bus_reg_num (l_effective_date in date, l_assignment_id in number, l_element_entry_id in number) is
3944: SELECT peevf.element_entry_id element_entry_id
3945: FROM pay_element_entry_values_f peevf,
3946: pay_element_entries_f peef,
3947: pay_element_types_f petf,
3948: pay_input_values_f pivf
3949: WHERE peevf.element_entry_id = peef.element_entry_id
3950: and peef.element_type_id = petf.element_type_id
3951: and petf.element_name LIKE 'PREV_SEP_PENS_DTLS'

Line 3964: pay_element_types_f petf,

3960: and l_effective_date BETWEEN pivf.effective_start_date AND pivf.effective_end_date
3961: and peevf.screen_entry_value in (SELECT peevf.screen_entry_value bus_reg_num
3962: FROM pay_element_entry_values_f peevf,
3963: pay_element_entries_f peef,
3964: pay_element_types_f petf,
3965: pay_input_values_f pivf
3966: WHERE peevf.element_entry_id = peef.element_entry_id
3967: and peevf.element_entry_id = nvl(l_element_entry_id,peevf.element_entry_id)
3968: and peef.element_type_id = petf.element_type_id

Line 3985: pay_element_types_f petf,

3981: cursor get_prev_emp_amt (l_effective_date in date, l_assignment_id in number, l_element_entry_id in number) is
3982: SELECT nvl(peevf.screen_entry_value,0) entry_value
3983: FROM pay_element_entry_values_f peevf,
3984: pay_element_entries_f peef,
3985: pay_element_types_f petf,
3986: pay_input_values_f pivf
3987: WHERE peevf.element_entry_id = peef.element_entry_id
3988: and peevf.element_entry_id = nvl(l_element_entry_id,peevf.element_entry_id)
3989: and peef.element_type_id = petf.element_type_id