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_RUN_RESULTS

Line 1776: ,pay_run_results prr

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
1779: ,pay_element_types_f pet
1780: WHERE paa.assignment_action_id = l_assignment_action_id

Line 1960: ,pay_run_results prr

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
1963: ,pay_element_types_f pet
1964: WHERE paa.assignment_action_id = l_assignment_action_id

Line 2010: ,pay_run_results prr

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
2013: ,pay_element_types_f pet
2014: WHERE paa.assignment_action_id = l_assignment_action_id

Line 2062: ,pay_run_results prr

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
2065: ,pay_element_types_f pet
2066: WHERE paa.assignment_action_id = l_assignment_action_id

Line 2112: ,pay_run_results prr

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
2115: ,pay_element_types_f pet
2116: WHERE paa.assignment_action_id = l_assignment_action_id

Line 2342: pay_run_results prr,

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'
2346: and petf.element_type_id = prr.element_type_id