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_ENTRIES_F

Line 2191: pay_element_entries_f peef,

2187: cursor get_prev_stat_sp_earn(l_effective_date in date, l_assignment_id in number, l_element_entry_id in number) is
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)

Line 2213: pay_element_entries_f peef,

2209: /* Cursor to fetch the sum of the Non-Statutory Sep pay Earnings */
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)

Line 2234: pay_element_entries_f peef,

2230: /* Cursor to find the eligible working place entries for the Sep Pay Post Tax Deduction */
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

Line 2256: pay_element_entries_f peef,

2252: employer to calculate the Service Period and Overlap Periods */
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)

Line 2279: pay_element_entries_f peef,

2275: /* Cursor to get the business Registration number of Separation Pension */
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

Line 2296: pay_element_entries_f peef,

2292: and l_effective_date BETWEEN petf.effective_start_date AND petf.effective_end_date
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)

Line 2320: pay_element_entries_f peef,

2316: /* Cursor to get the Total Amount Received */
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)

Line 2344: pay_element_entries_f peef

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'
2346: and petf.element_type_id = prr.element_type_id
2347: and prr.assignment_action_id = l_assignment_action_id
2348: and prrv.run_result_id = prr.run_result_id

Line 3907: pay_element_entries_f peef,

3903: cursor get_element_entry_id (l_effective_date in date, l_assignment_id in number) is
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

Line 3926: pay_element_entries_f peef,

3922:
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

Line 3946: pay_element_entries_f peef,

3942:
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

Line 3963: pay_element_entries_f peef,

3959: and l_effective_date BETWEEN petf.effective_start_date AND petf.effective_end_date
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)

Line 3984: pay_element_entries_f peef,

3980:
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)