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_ENTRY_VALUES_F

Line 2190: FROM pay_element_entry_values_f peevf,

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

Line 2212: FROM pay_element_entry_values_f peevf,

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

Line 2233: FROM pay_element_entry_values_f peevf,

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

Line 2255: FROM pay_element_entry_values_f peevf,

2251: /* Cursor to fetch the Hiring, Leaving and Final Interim Separation Pay date for the previous
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

Line 2278: FROM pay_element_entry_values_f peevf,

2274: /* Start of Bug 8525925 */
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

Line 2295: FROM pay_element_entry_values_f peevf,

2291: and l_effective_date BETWEEN peef.effective_start_date AND peef.effective_end_date
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

Line 2319: FROM pay_element_entry_values_f peevf,

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

Line 3906: FROM pay_element_entry_values_f peevf,

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

Line 3925: FROM pay_element_entry_values_f peevf,

3921: and l_effective_date BETWEEN pivf.effective_start_date AND pivf.effective_end_date;
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

Line 3945: FROM pay_element_entry_values_f peevf,

3941: and l_effective_date BETWEEN pivf.effective_start_date AND pivf.effective_end_date;
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

Line 3962: FROM pay_element_entry_values_f peevf,

3958: and l_effective_date BETWEEN peef.effective_start_date AND peef.effective_end_date
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

Line 3983: FROM pay_element_entry_values_f peevf,

3979: group by peevf.screen_entry_value);
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