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_INPUT_VALUES_F

Line 1774: FROM pay_input_values_f piv

1770: l_flag pay_run_result_values.result_value%type;
1771: -- Bug 7228788: Added a new argument for the Input Value Name to the cursor
1772: CURSOR csr(l_assignment_action_id pay_assignment_actions.assignment_action_id%type, l_input_value_name varchar2) is
1773: SELECT upper(nvl(prrv.result_value, 'N'))
1774: FROM pay_input_values_f piv
1775: ,pay_run_result_values prrv
1776: ,pay_run_results prr
1777: ,pay_payroll_actions ppa
1778: ,pay_assignment_actions paa

Line 1958: FROM pay_input_values_f piv

1954: l_flag pay_run_result_values.result_value%type;
1955: -- Bug 7228788: Added a new argument for the Input Value Name to the cursor
1956: CURSOR csr(l_assignment_action_id pay_assignment_actions.assignment_action_id%type, l_input_value_name varchar2, l_element_name varchar2) is
1957: SELECT upper(nvl(prrv.result_value, 'N'))
1958: FROM pay_input_values_f piv
1959: ,pay_run_result_values prrv
1960: ,pay_run_results prr
1961: ,pay_payroll_actions ppa
1962: ,pay_assignment_actions paa

Line 2008: FROM pay_input_values_f piv

2004: --
2005: l_dummy pay_run_result_values.result_value%type;
2006: CURSOR csr(l_assignment_action_id pay_assignment_actions.assignment_action_id%type, l_input_value_name varchar2, l_element_name varchar2) is
2007: SELECT nvl(prrv.result_value, 0)
2008: FROM pay_input_values_f piv
2009: ,pay_run_result_values prrv
2010: ,pay_run_results prr
2011: ,pay_payroll_actions ppa
2012: ,pay_assignment_actions paa

Line 2060: FROM pay_input_values_f piv

2056: l_flag pay_run_result_values.result_value%type;
2057: -- Bug 7228788: Added a new argument for the Input Value Name to the cursor
2058: CURSOR csr(l_assignment_action_id pay_assignment_actions.assignment_action_id%type, l_input_value_name varchar2, l_element_name varchar2) is
2059: SELECT upper(nvl(prrv.result_value, 'Y'))
2060: FROM pay_input_values_f piv
2061: ,pay_run_result_values prrv
2062: ,pay_run_results prr
2063: ,pay_payroll_actions ppa
2064: ,pay_assignment_actions paa

Line 2110: FROM pay_input_values_f piv

2106: --
2107: l_dummy pay_run_result_values.result_value%type;
2108: CURSOR csr(l_assignment_action_id pay_assignment_actions.assignment_action_id%type, l_input_value_name varchar2, l_element_name varchar2) is
2109: SELECT nvl(fnd_date.canonical_to_date(prrv.result_value), to_date('01-01-1900','dd-mm-yyyy'))
2110: FROM pay_input_values_f piv
2111: ,pay_run_result_values prrv
2112: ,pay_run_results prr
2113: ,pay_payroll_actions ppa
2114: ,pay_assignment_actions paa

Line 2193: pay_input_values_f pivf

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
2197: and petf.element_name LIKE 'PREV_ER_INFO'

Line 2215: pay_input_values_f pivf

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
2219: and petf.element_name LIKE 'PREV_ER_INFO'

Line 2236: pay_input_values_f pivf

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'
2240: and petf.legislation_code = 'KR'

Line 2258: pay_input_values_f pivf

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
2262: and petf.element_name LIKE 'PREV_ER_INFO'

Line 2281: pay_input_values_f pivf

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'
2285: and petf.legislation_code = 'KR'

Line 2298: pay_input_values_f pivf

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
2302: and petf.element_name LIKE 'PREV_ER_INFO'

Line 2322: pay_input_values_f pivf

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
2326: and petf.element_name LIKE 'PREV_SEP_PENS_DTLS'

Line 3909: pay_input_values_f pivf

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'
3913: and petf.legislation_code = 'KR'

Line 3928: pay_input_values_f pivf

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
3932: and petf.element_name LIKE 'PREV_ER_INFO'

Line 3948: pay_input_values_f pivf

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'
3952: and petf.legislation_code = 'KR'

Line 3965: pay_input_values_f pivf

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
3969: and petf.element_name LIKE 'PREV_ER_INFO'

Line 3986: pay_input_values_f pivf

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
3990: and petf.element_name LIKE 'PREV_SEP_PENS_DTLS'