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_ASSIGNMENT_ACTIONS

Line 1689: pay_assignment_actions paa

1685: p_effective_year varchar2)
1686: is
1687: SELECT paa.assignment_action_id ass_act_id
1688: from pay_payroll_actions ppa,
1689: pay_assignment_actions paa
1690: where paa.assignment_id = p_assignment_id
1691: and paa.action_status = 'C'
1692: and ppa.payroll_action_id = paa.payroll_action_id
1693: and to_char(ppa.effective_date, 'YYYY') = p_effective_year

Line 1765: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type

1761: -- Bug 7164589: Long Term Care Insurance Premium
1762: -- Bug 7228788: Added a new input parameter to the function for the Input Value Name
1763: -----------------------------------------------------------------------------------
1764: FUNCTION get_long_term_ins_skip_flag(
1765: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
1766: ,p_input_value_name in varchar2
1767: ) RETURN VARCHAR2
1768: IS
1769: --

Line 1772: CURSOR csr(l_assignment_action_id pay_assignment_actions.assignment_action_id%type, l_input_value_name varchar2) is

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
1775: ,pay_run_result_values prrv
1776: ,pay_run_results prr

Line 1778: ,pay_assignment_actions paa

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
1781: and ppa.payroll_action_id = paa.payroll_action_id
1782: and prr.assignment_action_id = paa.assignment_action_id

Line 1948: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type

1944: -----------------------------------------------------------------------------------
1945: -- Bug 8341054: Gets the Flag for Input Value of an Element
1946: -----------------------------------------------------------------------------------
1947: FUNCTION get_element_input_value(
1948: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
1949: ,p_input_value_name in varchar2
1950: ,p_element_name in varchar2
1951: ) RETURN VARCHAR2
1952: IS

Line 1956: CURSOR csr(l_assignment_action_id pay_assignment_actions.assignment_action_id%type, l_input_value_name varchar2, l_element_name varchar2) is

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
1959: ,pay_run_result_values prrv
1960: ,pay_run_results prr

Line 1962: ,pay_assignment_actions paa

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
1965: and ppa.payroll_action_id = paa.payroll_action_id
1966: and prr.assignment_action_id = paa.assignment_action_id

Line 1999: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type

1995: -----------------------------------------------------------------------------------
1996: -- Bug 8466662: Gets the Run Result Value for an Input Value of Type Money
1997: -----------------------------------------------------------------------------------
1998: FUNCTION get_element_rr_value(
1999: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
2000: ,p_input_value_name in varchar2
2001: ,p_element_name in varchar2
2002: ) RETURN number
2003: IS

Line 2006: CURSOR csr(l_assignment_action_id pay_assignment_actions.assignment_action_id%type, l_input_value_name varchar2, l_element_name varchar2) is

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
2010: ,pay_run_results prr

Line 2012: ,pay_assignment_actions paa

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
2015: and ppa.payroll_action_id = paa.payroll_action_id
2016: and prr.assignment_action_id = paa.assignment_action_id

Line 2050: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type

2046: --------------------------------------------------------------------------------------------------
2047: -- Bug 8466662: Gets the Flag for Input Value of an Element and returns 'yes' if value not found
2048: --------------------------------------------------------------------------------------------------
2049: FUNCTION get_element_input_value_y(
2050: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
2051: ,p_input_value_name in varchar2
2052: ,p_element_name in varchar2
2053: ) RETURN VARCHAR2
2054: IS

Line 2058: CURSOR csr(l_assignment_action_id pay_assignment_actions.assignment_action_id%type, l_input_value_name varchar2, l_element_name varchar2) is

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
2061: ,pay_run_result_values prrv
2062: ,pay_run_results prr

Line 2064: ,pay_assignment_actions paa

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
2067: and ppa.payroll_action_id = paa.payroll_action_id
2068: and prr.assignment_action_id = paa.assignment_action_id

Line 2101: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type

2097: -----------------------------------------------------------------------------------
2098: -- Bug 8466662: Gets the Run Result Value for an Input Value of Date
2099: -----------------------------------------------------------------------------------
2100: FUNCTION get_element_rr_date_value(
2101: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
2102: ,p_input_value_name in varchar2
2103: ,p_element_name in varchar2
2104: ) RETURN date
2105: IS

Line 2108: CURSOR csr(l_assignment_action_id pay_assignment_actions.assignment_action_id%type, l_input_value_name varchar2, l_element_name varchar2) is

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
2112: ,pay_run_results prr

Line 2114: ,pay_assignment_actions paa

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
2117: and ppa.payroll_action_id = paa.payroll_action_id
2118: and prr.assignment_action_id = paa.assignment_action_id

Line 4161: pay_assignment_actions paa

4157: --
4158: cursor csr is
4159: SELECT 'Y'
4160: from pay_payroll_actions ppa,
4161: pay_assignment_actions paa
4162: where paa.assignment_id = p_assignment_id
4163: and paa.action_status = 'C'
4164: and ppa.payroll_action_id = paa.payroll_action_id
4165: and ppa.report_type = 'YEA'