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_SE_EMPLOYMENT_STATISTICS dependencies on PAY_ACTION_INFORMATION

Line 605: pay_action_information_api.create_action_information

601: OPEN csr_local_unit_details(g_local_unit_id);
602: fetch csr_local_unit_details into L_LOCAL_UNIT_NAME;
603: CLOSE csr_local_unit_details;
604: -- Insert the report Parameters
605: pay_action_information_api.create_action_information
606: (p_action_information_id => l_action_info_id
607: , p_action_context_id => p_payroll_action_id
608: , p_action_context_type => 'PA'
609: , p_object_version_number => l_ovn

Line 883: pay_action_information_api.create_action_information

879: /*cursor to get the start date, assignment id for getting the new hires */
880:
881:
882:
883: pay_action_information_api.create_action_information
884: (p_action_information_id => l_action_info_id
885: , p_action_context_id => p_payroll_action_id
886: , p_action_context_type => 'PA'
887: , p_object_version_number => l_ovn

Line 1142: pay_action_information_api.create_action_information

1138: END IF;
1139:
1140: END LOOP;
1141:
1142: pay_action_information_api.create_action_information
1143: (p_action_information_id => l_action_info_id
1144: , p_action_context_id => p_payroll_action_id
1145: , p_action_context_type => 'PA'
1146: , p_object_version_number => l_ovn

Line 1431: pay_action_information_api.create_action_information

1427: END IF;
1428:
1429: END LOOP;
1430:
1431: pay_action_information_api.create_action_information
1432: (p_action_information_id => l_action_info_id
1433: , p_action_context_id => p_payroll_action_id
1434: , p_action_context_type => 'PA'
1435: , p_object_version_number => l_ovn

Line 1509: pay_action_information_api.create_action_information

1505: || g_legal_employer_id
1506: );
1507: -- *****************************************************************************
1508: -- Insert the report Parameters
1509: pay_action_information_api.create_action_information
1510: (p_action_information_id => l_action_info_id
1511: , p_action_context_id => p_payroll_action_id
1512: , p_action_context_type => 'PA'
1513: , p_object_version_number => l_ovn

Line 1562: pay_action_information_api.create_action_information

1558: INTO l_legal_employer_details;
1559:
1560: CLOSE csr_legal_employer_details;
1561:
1562: pay_action_information_api.create_action_information
1563: (p_action_information_id => l_action_info_id
1564: , p_action_context_id => p_payroll_action_id
1565: , p_action_context_type => 'PA'
1566: , p_object_version_number => l_ovn

Line 1599: pay_action_information_api.create_action_information

1595: CLOSE csr_check_empty_le;
1596:
1597: IF l_le_has_employee = '1'
1598: THEN
1599: pay_action_information_api.create_action_information
1600: (p_action_information_id => l_action_info_id
1601: , p_action_context_id => p_payroll_action_id
1602: , p_action_context_type => 'PA'
1603: , p_object_version_number => l_ovn

Line 1997: l_payroll_action_id pay_action_information.action_information1%TYPE;

1993: )
1994: IS
1995: --Variables needed for the report
1996: l_counter NUMBER := 0;
1997: l_payroll_action_id pay_action_information.action_information1%TYPE;
1998:
1999: --Cursors needed for report
2000: CURSOR csr_all_legal_employer (
2001: csr_v_pa_id pay_action_information.action_context_id%TYPE

Line 2001: csr_v_pa_id pay_action_information.action_context_id%TYPE

1997: l_payroll_action_id pay_action_information.action_information1%TYPE;
1998:
1999: --Cursors needed for report
2000: CURSOR csr_all_legal_employer (
2001: csr_v_pa_id pay_action_information.action_context_id%TYPE
2002: )
2003: IS
2004: SELECT action_information3, action_information4
2005: , action_information5

Line 2006: FROM pay_action_information

2002: )
2003: IS
2004: SELECT action_information3, action_information4
2005: , action_information5
2006: FROM pay_action_information
2007: WHERE action_context_type = 'PA'
2008: AND action_context_id = csr_v_pa_id
2009: AND action_information_category = 'EMEA REPORT INFORMATION'
2010: AND action_information1 = 'PYSEHPDA'

Line 2014: csr_v_pa_id pay_action_information.action_context_id%TYPE

2010: AND action_information1 = 'PYSEHPDA'
2011: AND action_information2 = 'LE';
2012:
2013: CURSOR csr_report_details (
2014: csr_v_pa_id pay_action_information.action_context_id%TYPE
2015: )
2016: IS
2017: SELECT TO_CHAR
2018: (fnd_date.canonical_to_date (action_information5)

Line 2025: FROM pay_action_information

2021: , TO_CHAR
2022: (fnd_date.canonical_to_date (action_information6)
2023: , 'YYYYMMDD'
2024: ) period_to
2025: FROM pay_action_information
2026: WHERE action_context_type = 'PA'
2027: AND action_context_id = csr_v_pa_id
2028: AND action_information_category = 'EMEA REPORT DETAILS'
2029: AND action_information1 = 'PYSEHPDA';

Line 2034: csr_v_pa_id pay_action_information.action_information3%TYPE

2030:
2031: lr_report_details csr_report_details%ROWTYPE;
2032:
2033: CURSOR csr_all_employees_under_le (
2034: csr_v_pa_id pay_action_information.action_information3%TYPE
2035: , csr_v_le_id pay_action_information.action_information15%TYPE
2036: )
2037: IS
2038: SELECT *

Line 2035: , csr_v_le_id pay_action_information.action_information15%TYPE

2031: lr_report_details csr_report_details%ROWTYPE;
2032:
2033: CURSOR csr_all_employees_under_le (
2034: csr_v_pa_id pay_action_information.action_information3%TYPE
2035: , csr_v_le_id pay_action_information.action_information15%TYPE
2036: )
2037: IS
2038: SELECT *
2039: FROM pay_action_information

Line 2039: FROM pay_action_information

2035: , csr_v_le_id pay_action_information.action_information15%TYPE
2036: )
2037: IS
2038: SELECT *
2039: FROM pay_action_information
2040: WHERE action_context_type = 'AAP'
2041: AND action_information_category = 'EMEA REPORT INFORMATION'
2042: AND action_information1 = 'PYSEHPDA'
2043: AND action_information3 = csr_v_pa_id

Line 2224: pay_action_information pai,

2220: pai1.action_information24 Terminate_Regular_Women,
2221: pai1.action_information25 Terminate_Temporary_Men,
2222: pai1.action_information26 Terminate_Temporary_Women
2223: FROM
2224: pay_action_information pai,
2225: pay_payroll_actions ppa,
2226: pay_action_information pai1
2227: WHERE
2228: pai.action_context_id = ppa.payroll_action_id

Line 2226: pay_action_information pai1

2222: pai1.action_information26 Terminate_Temporary_Women
2223: FROM
2224: pay_action_information pai,
2225: pay_payroll_actions ppa,
2226: pay_action_information pai1
2227: WHERE
2228: pai.action_context_id = ppa.payroll_action_id
2229: AND ppa.payroll_action_id =p_payroll_action_id --20162 --20264 --20165
2230: AND pai.action_context_id = pai1.action_context_id

Line 2249: pay_action_information pai1

2245: sum(pai1.action_information11) Temporary_Men,
2246: sum(pai1.action_information12) Temporary_Women
2247: FROM
2248: pay_payroll_actions ppa,
2249: pay_action_information pai1
2250: WHERE
2251: pai1.action_context_id = ppa.payroll_action_id
2252: AND ppa.payroll_action_id =p_payroll_action_id
2253: AND pai1.action_context_type='PA'