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_RESULT_VALUES

Line 1770: l_flag pay_run_result_values.result_value%type;

1766: ,p_input_value_name in varchar2
1767: ) RETURN VARCHAR2
1768: IS
1769: --
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

Line 1775: ,pay_run_result_values prrv

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
1779: ,pay_element_types_f pet

Line 1954: l_flag pay_run_result_values.result_value%type;

1950: ,p_element_name in varchar2
1951: ) RETURN VARCHAR2
1952: IS
1953: --
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

Line 1959: ,pay_run_result_values prrv

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
1963: ,pay_element_types_f pet

Line 2005: l_dummy pay_run_result_values.result_value%type;

2001: ,p_element_name in varchar2
2002: ) RETURN number
2003: IS
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

Line 2009: ,pay_run_result_values prrv

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
2013: ,pay_element_types_f pet

Line 2056: l_flag pay_run_result_values.result_value%type;

2052: ,p_element_name in varchar2
2053: ) RETURN VARCHAR2
2054: IS
2055: --
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

Line 2061: ,pay_run_result_values prrv

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
2065: ,pay_element_types_f pet

Line 2107: l_dummy pay_run_result_values.result_value%type;

2103: ,p_element_name in varchar2
2104: ) RETURN date
2105: IS
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

Line 2111: ,pay_run_result_values prrv

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
2115: ,pay_element_types_f pet

Line 2343: pay_run_result_values prrv,

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
2347: and prr.assignment_action_id = l_assignment_action_id