APPS.PAY_IN_EOY_REPORTS dependencies on HR_ORGANIZATION_UNITS

Line 179: FUNCTION get_max_context_id ( p_gre_id IN hr_organization_units.organization_id%TYPE

175: -- Parameters : --
176: -- IN : p_gre_id NUMBER --
177: -- : p_assessment_year VARCHAR2 --
178: --------------------------------------------------------------------------
179: FUNCTION get_max_context_id ( p_gre_id IN hr_organization_units.organization_id%TYPE
180: , p_assessment_year IN pay_action_information.action_information3%TYPE
181: )
182: RETURN NUMBER
183: IS

Line 497: PROCEDURE build_gre_xml ( p_gre_id IN hr_organization_units.organization_id%TYPE)

493: -- --
494: -- Parameters : --
495: -- IN : p_gre_id NUMBER --
496: --------------------------------------------------------------------------
497: PROCEDURE build_gre_xml ( p_gre_id IN hr_organization_units.organization_id%TYPE)
498: IS
499: CURSOR csr_get_gre_details (p_action_context_id NUMBER)
500: IS
501: SELECT 'ER_LEGAL' er_legal

Line 1991: l_gre_id hr_organization_units.organization_id%TYPE;

1987: )
1988: IS
1989: l_procedure VARCHAR2(100);
1990: l_open_tag VARCHAR2(100);
1991: l_gre_id hr_organization_units.organization_id%TYPE;
1992: l_action_context_id pay_assignment_actions.assignment_action_id%TYPE;
1993: l_emp_number per_people_f.employee_number%TYPE;
1994: l_emp_count NUMBER;
1995: l_start_date DATE;

Line 2002: CURSOR csr_fetch_gre( p_gre_id IN hr_organization_units.organization_id%TYPE)

1998: l_flag_for_16aa NUMBER;
1999:
2000:
2001:
2002: CURSOR csr_fetch_gre( p_gre_id IN hr_organization_units.organization_id%TYPE)
2003: IS
2004: SELECT hou.organization_id orgid
2005: FROM hr_all_organization_units hou
2006: , hr_organization_information hoi

Line 2027: CURSOR csr_fetch_employees( p_gre_id hr_organization_units.organization_id%TYPE)

2023: AND ppa.report_category ='ARCHIVE'
2024: AND ROWNUM < 2)
2025: ORDER BY hou.name;
2026:
2027: CURSOR csr_fetch_employees( p_gre_id hr_organization_units.organization_id%TYPE)
2028: IS
2029: SELECT MAX(pai.action_context_id) action_context_id
2030: , pai.action_information17 start_date
2031: , pai.action_information1 employee_number

Line 2048: ,p_gre_id hr_organization_units.organization_id%TYPE

2044: */
2045:
2046: CURSOR csr_emp_source_id(p_start_date DATE
2047: ,p_employee_number VARCHAR2
2048: ,p_gre_id hr_organization_units.organization_id%TYPE
2049: ,p_action_context_id NUMBER)
2050: IS
2051: SELECT pai.source_id Payroll_run_action_id
2052: ,pai.action_information18 end_date