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_IN_EOY_REPORTS dependencies on HR_ORGANIZATION_UNITS

Line 14: g_org_id hr_organization_units.organization_id%TYPE;

10: g_tax_year VARCHAR2(20);
11: g_tax_end_date DATE;
12: g_tax_start_date DATE;
13: g_er_type_flag NUMBER;
14: g_org_id hr_organization_units.organization_id%TYPE;
15: l_date_earned DATE;
16:
17: qtr_index NUMBER;
18: g_index NUMBER;

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

170: -- Parameters : --
171: -- IN : p_gre_id NUMBER --
172: -- : p_assessment_year VARCHAR2 --
173: --------------------------------------------------------------------------
174: FUNCTION get_max_context_id ( p_gre_id IN hr_organization_units.organization_id%TYPE
175: , p_assessment_year IN pay_action_information.action_information3%TYPE
176: )
177: RETURN NUMBER
178: IS

Line 492: -- : p_tax_unit_id hr_organization_units.organization_id%TYPE --

488: -- start of finanacial yeat to latest run in a quarter --
489: -- --
490: -- Parameters : --
491: -- IN : p_assignment_id NUMBER --
492: -- : p_tax_unit_id hr_organization_units.organization_id%TYPE --
493: -- p_qtr_start DATE --
494: -- p_qtr_end DATE --
495: --------------------------------------------------------------------------
496: FUNCTION get_qtr_tax_deducted(p_assignment_id IN NUMBER,

Line 497: p_tax_unit_id IN hr_organization_units.organization_id%TYPE,

493: -- p_qtr_start DATE --
494: -- p_qtr_end DATE --
495: --------------------------------------------------------------------------
496: FUNCTION get_qtr_tax_deducted(p_assignment_id IN NUMBER,
497: p_tax_unit_id IN hr_organization_units.organization_id%TYPE,
498: p_qtr_start date,
499: p_qtr_end date)
500: RETURN NUMBER IS
501: cursor csr_action_id is

Line 614: PROCEDURE build_gre_xml ( p_gre_id IN hr_organization_units.organization_id%TYPE,

610: -- --
611: -- Parameters : --
612: -- IN : p_gre_id NUMBER --
613: --------------------------------------------------------------------------
614: PROCEDURE build_gre_xml ( p_gre_id IN hr_organization_units.organization_id%TYPE,
615: p_designation VARCHAR2)
616: IS
617: CURSOR csr_get_gre_details (p_action_context_id NUMBER)
618: IS

Line 2214: PROCEDURE get_image_details ( p_gre_id IN hr_organization_units.organization_id%TYPE)

2210: -- Parameters : --
2211: -- IN : p_gre_id NUMBER
2212: --------------------------------------------------------------------------
2213:
2214: PROCEDURE get_image_details ( p_gre_id IN hr_organization_units.organization_id%TYPE)
2215: IS
2216: CURSOR csr_get_image_details (p_action_context_id NUMBER)
2217: IS
2218: SELECT

Line 2294: l_gre_id hr_organization_units.organization_id%TYPE;

2290: )
2291: IS
2292: l_procedure VARCHAR2(100);
2293: l_open_tag VARCHAR2(100);
2294: l_gre_id hr_organization_units.organization_id%TYPE;
2295: l_action_context_id pay_assignment_actions.assignment_action_id%TYPE;
2296: l_emp_number per_people_f.employee_number%TYPE;
2297: l_emp_count NUMBER;
2298: l_start_date DATE;

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

2301: l_flag_for_16aa NUMBER;
2302:
2303:
2304:
2305: CURSOR csr_fetch_gre( p_gre_id IN hr_organization_units.organization_id%TYPE)
2306: IS
2307: SELECT hou.organization_id orgid
2308: FROM hr_all_organization_units hou
2309: , hr_organization_information hoi

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

2326: AND ppa.report_category ='ARCHIVE'
2327: AND ROWNUM < 2)
2328: ORDER BY hou.name;
2329:
2330: CURSOR csr_fetch_employees( p_gre_id hr_organization_units.organization_id%TYPE)
2331: IS
2332: SELECT MAX(pai.action_context_id) action_context_id
2333: , pai.action_information17 start_date
2334: , pai.action_information1 employee_number

Line 2351: ,p_gre_id hr_organization_units.organization_id%TYPE

2347: */
2348:
2349: CURSOR csr_emp_source_id(p_start_date DATE
2350: ,p_employee_number VARCHAR2
2351: ,p_gre_id hr_organization_units.organization_id%TYPE
2352: ,p_action_context_id NUMBER)
2353: IS
2354: SELECT pai.source_id Payroll_run_action_id
2355: ,pai.action_information18 end_date

Line 2551: l_gre_id hr_organization_units.organization_id%TYPE;

2547: )
2548: IS
2549: l_procedure VARCHAR2(100);
2550: l_open_tag VARCHAR2(100);
2551: l_gre_id hr_organization_units.organization_id%TYPE;
2552: l_action_context_id pay_assignment_actions.assignment_action_id%TYPE;
2553: l_emp_number per_people_f.employee_number%TYPE;
2554: l_emp_count NUMBER;
2555: l_start_date DATE;

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

2558: l_flag_for_16aa NUMBER;
2559: --l_emp_id per_people_f.employee_number%TYPE;
2560:
2561:
2562: CURSOR csr_fetch_gre( p_gre_id IN hr_organization_units.organization_id%TYPE)
2563: IS
2564: SELECT hou.organization_id orgid
2565: FROM hr_all_organization_units hou
2566: , hr_organization_information hoi

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

2583: AND ppa.report_category ='ARCHIVE'
2584: AND ROWNUM < 2)
2585: ORDER BY hou.name;
2586:
2587: CURSOR csr_fetch_employees( p_gre_id hr_organization_units.organization_id%TYPE)
2588: IS
2589: SELECT MAX(pai.action_context_id) action_context_id
2590: , pai.action_information17 start_date
2591: , pai.action_information1 employee_number

Line 2609: ,p_gre_id hr_organization_units.organization_id%TYPE

2605: */
2606:
2607: CURSOR csr_emp_source_id(p_start_date DATE
2608: ,p_employee_number VARCHAR2
2609: ,p_gre_id hr_organization_units.organization_id%TYPE
2610: ,p_action_context_id NUMBER)
2611: IS
2612: SELECT pai.source_id Payroll_run_action_id
2613: ,pai.action_information18 end_date