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

Line 468: ,c_bg_id hr_organization_units.business_group_id%type) IS

464: FROM pay_payroll_actions
465: WHERE payroll_action_id = pactid;
466:
467: CURSOR csr_employer_details(c_org_id hr_organization_information.organization_id%type
468: ,c_bg_id hr_organization_units.business_group_id%type) IS
469: select hou.organization_id org_id
470: ,hou.name employer_name
471: ,hla.address_line_1 addr1
472: ,hla.address_line_2 addr2

Line 474: from hr_organization_units hou

470: ,hou.name employer_name
471: ,hla.address_line_1 addr1
472: ,hla.address_line_2 addr2
473: ,hla.address_line_3 addr3
474: from hr_organization_units hou
475: ,hr_organization_information hoi
476: ,hr_locations_all hla
477: where hoi.org_information_context='IE_EMPLOYER_INFO'
478: and hoi.organization_id=c_org_id

Line 485: ,c_bg_id hr_organization_units.business_group_id%type

481: and hou.location_id=hla.location_id(+);
482:
483:
484: CURSOR csr_declarant(c_org_id hr_organization_information.organization_id%type
485: ,c_bg_id hr_organization_units.business_group_id%type
486: ,p_year varchar2
487: ,p_qtr varchar2) IS
488: select hoi.org_information3 cbr_no
489: ,hoi.org_information13 person_id

Line 493: from hr_organization_units hou

489: ,hoi.org_information13 person_id
490: ,hoi.org_information17 position -- bug 6850742
491: ,hoi.org_information19 email -- bug 6850742
492: ,hoi.org_information20 phone -- bug 6850742
493: from hr_organization_units hou
494: ,hr_organization_information hoi
495: where hoi.org_information_context='IE_EHECS'
496: and hoi.organization_id=c_org_id
497: and hoi.organization_id=hou.organization_id

Line 530: l_org_id hr_organization_units.organization_id%type;

526: l_declarant csr_declarant%rowtype;
527: l_declarant_details csr_declarant_details%rowtype;
528: l_action_info_id NUMBER;
529: l_ovn NUMBER;
530: l_org_id hr_organization_units.organization_id%type;
531: l_employer_name hr_organization_units.name%type;
532:
533: l_addr1 hr_locations_all.address_line_1%type;
534: l_addr2 hr_locations_all.address_line_2%type;

Line 531: l_employer_name hr_organization_units.name%type;

527: l_declarant_details csr_declarant_details%rowtype;
528: l_action_info_id NUMBER;
529: l_ovn NUMBER;
530: l_org_id hr_organization_units.organization_id%type;
531: l_employer_name hr_organization_units.name%type;
532:
533: l_addr1 hr_locations_all.address_line_1%type;
534: l_addr2 hr_locations_all.address_line_2%type;
535: l_addr3 hr_locations_all.address_line_3%type;

Line 998: ,c_bg_id hr_organization_units.business_group_id%type

994: l_valid_asg_act_rec cur_valid_asg_act%ROWTYPE;
995:
996: /*6856473 added the cursor and the variables */
997: CURSOR csr_hours_per_day(c_org_id hr_organization_information.organization_id%type
998: ,c_bg_id hr_organization_units.business_group_id%type
999: ) IS
1000: select hoi.org_information18 hrs_per_day
1001: from hr_organization_units hou
1002: ,hr_organization_information hoi

Line 1001: from hr_organization_units hou

997: CURSOR csr_hours_per_day(c_org_id hr_organization_information.organization_id%type
998: ,c_bg_id hr_organization_units.business_group_id%type
999: ) IS
1000: select hoi.org_information18 hrs_per_day
1001: from hr_organization_units hou
1002: ,hr_organization_information hoi
1003: where hoi.org_information_context='IE_EHECS'
1004: and hoi.organization_id=c_org_id
1005: and hoi.organization_id=hou.organization_id

Line 1009: l_org_id hr_organization_units.organization_id%type;

1005: and hoi.organization_id=hou.organization_id
1006: and hou.business_group_id= c_bg_id;
1007: --l_hours_per_day csr_hours_per_day%rowtype;
1008: l_hours_per_day varchar2(10);
1009: l_org_id hr_organization_units.organization_id%type;
1010: l_normal_hours per_all_assignments_f.normal_hours%type;
1011: l_frequency per_all_assignments_f.frequency%type;
1012:
1013: --------------------------- Variables which will hold the Balance Values.

Line 2111: from hr_organization_units hou

2107: ,SUM(fnd_number.canonical_to_number(hoi.org_information17)) l_stks
2108: ,SUM(fnd_number.canonical_to_number(hoi.org_information18)) l_vhi
2109: ,SUM(fnd_number.canonical_to_number(hoi.org_information19)) l_hse
2110: ,SUM(fnd_number.canonical_to_number(hoi.org_information20)) l_otben
2111: from hr_organization_units hou
2112: ,hr_organization_information hoi
2113: where hoi.org_information_context='IE_EHECS_OVERRIDE'
2114: and hoi.organization_id=c_org_id
2115: and hoi.organization_id=hou.organization_id

Line 2339: ,c_bg_id hr_organization_units.business_group_id%type

2335: l_action_info_id NUMBER;
2336: l_ovn NUMBER;
2337:
2338: CURSOR csr_ehecs_eit(c_org_id hr_organization_information.organization_id%type
2339: ,c_bg_id hr_organization_units.business_group_id%type
2340: ,p_year VARCHAR2
2341: ,p_qtr VARCHAR2) IS
2342: select hoi.org_information1 Year,
2343: hoi.org_information2 Qtr,

Line 2358: from hr_organization_units hou

2354: hoi.org_information13 Declarant,
2355: hoi.org_information14 Trng_subsidy,
2356: hoi.org_information15 otr_subsidy,
2357: hoi.org_information16 refunds
2358: from hr_organization_units hou
2359: ,hr_organization_information hoi
2360: where hoi.org_information_context='IE_EHECS'
2361: and hoi.organization_id=c_org_id
2362: and hoi.organization_id=hou.organization_id