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 513: ,c_bg_id hr_organization_units.business_group_id%type) IS

509:
510: /* 9719281 */
511: --
512: /* CURSOR csr_employer_details(c_org_id hr_organization_information.organization_id%type
513: ,c_bg_id hr_organization_units.business_group_id%type) IS
514: select hou.organization_id org_id
515: ,hou.name employer_name
516: ,hla.address_line_1 addr1
517: ,hla.address_line_2 addr2

Line 519: from hr_organization_units hou

515: ,hou.name employer_name
516: ,hla.address_line_1 addr1
517: ,hla.address_line_2 addr2
518: ,hla.address_line_3 addr3
519: from hr_organization_units hou
520: ,hr_organization_information hoi
521: ,hr_locations_all hla
522: where hoi.org_information_context='IE_EMPLOYER_INFO'
523: and hoi.organization_id=c_org_id

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

525: and hou.business_group_id= c_bg_id
526: and hou.location_id=hla.location_id(+); */
527:
528: CURSOR csr_employer_details(c_org_id hr_organization_information.organization_id%type
529: ,c_bg_id hr_organization_units.business_group_id%type) IS
530: select hou.organization_id org_id
531: ,hou.name employer_name
532: ,hla.address_line_1 addr1
533: ,hla.address_line_2 addr2

Line 541: from hr_organization_units hou

537: ,hla.TOWN_OR_CITY City
538: ,flv.meaning County
539: ,hla.COUNTRY Country_Name
540: ,hla.REGION_1
541: from hr_organization_units hou
542: ,hr_organization_information hoi
543: ,hr_locations_all hla
544: ,fnd_lookup_values flv
545: where hoi.org_information_context='IE_EMPLOYER_INFO'

Line 557: ,c_bg_id hr_organization_units.business_group_id%type

553: --
554:
555:
556: CURSOR csr_declarant(c_org_id hr_organization_information.organization_id%type
557: ,c_bg_id hr_organization_units.business_group_id%type
558: ,p_year varchar2
559: ,p_qtr varchar2) IS
560: select hoi.org_information3 cbr_no
561: ,hoi.org_information13 person_id

Line 565: from hr_organization_units hou

561: ,hoi.org_information13 person_id
562: ,hoi.org_information17 position -- bug 6850742
563: ,hoi.org_information19 email -- bug 6850742
564: ,hoi.org_information20 phone -- bug 6850742
565: from hr_organization_units hou
566: ,hr_organization_information hoi
567: where hoi.org_information_context='IE_EHECS'
568: and hoi.organization_id=c_org_id
569: and hoi.organization_id=hou.organization_id

Line 602: l_org_id hr_organization_units.organization_id%type;

598: l_declarant csr_declarant%rowtype;
599: l_declarant_details csr_declarant_details%rowtype;
600: l_action_info_id NUMBER;
601: l_ovn NUMBER;
602: l_org_id hr_organization_units.organization_id%type;
603: l_employer_name hr_organization_units.name%type;
604:
605: l_addr1 hr_locations_all.address_line_1%type;
606: l_addr2 hr_locations_all.address_line_2%type;

Line 603: l_employer_name hr_organization_units.name%type;

599: l_declarant_details csr_declarant_details%rowtype;
600: l_action_info_id NUMBER;
601: l_ovn NUMBER;
602: l_org_id hr_organization_units.organization_id%type;
603: l_employer_name hr_organization_units.name%type;
604:
605: l_addr1 hr_locations_all.address_line_1%type;
606: l_addr2 hr_locations_all.address_line_2%type;
607: l_addr3 hr_locations_all.address_line_3%type;

Line 1177: ,c_bg_id hr_organization_units.business_group_id%type

1173: l_valid_asg_act_rec cur_valid_asg_act%ROWTYPE;
1174:
1175: /*6856473 added the cursor and the variables */
1176: CURSOR csr_hours_per_day(c_org_id hr_organization_information.organization_id%type
1177: ,c_bg_id hr_organization_units.business_group_id%type
1178: ) IS
1179: select hoi.org_information18 hrs_per_day
1180: from hr_organization_units hou
1181: ,hr_organization_information hoi

Line 1180: from hr_organization_units hou

1176: CURSOR csr_hours_per_day(c_org_id hr_organization_information.organization_id%type
1177: ,c_bg_id hr_organization_units.business_group_id%type
1178: ) IS
1179: select hoi.org_information18 hrs_per_day
1180: from hr_organization_units hou
1181: ,hr_organization_information hoi
1182: where hoi.org_information_context='IE_EHECS'
1183: and hoi.organization_id=c_org_id
1184: and hoi.organization_id=hou.organization_id

Line 1188: l_org_id hr_organization_units.organization_id%type;

1184: and hoi.organization_id=hou.organization_id
1185: and hou.business_group_id= c_bg_id;
1186: --l_hours_per_day csr_hours_per_day%rowtype;
1187: l_hours_per_day varchar2(10);
1188: l_org_id hr_organization_units.organization_id%type;
1189: l_normal_hours per_all_assignments_f.normal_hours%type;
1190: l_frequency per_all_assignments_f.frequency%type;
1191:
1192: /* 9776525 start */

Line 2394: from hr_organization_units hou

2390: ,SUM(fnd_number.canonical_to_number(hoi.org_information17)) l_stks
2391: ,SUM(fnd_number.canonical_to_number(hoi.org_information18)) l_vhi
2392: ,SUM(fnd_number.canonical_to_number(hoi.org_information19)) l_hse
2393: ,SUM(fnd_number.canonical_to_number(hoi.org_information20)) l_otben
2394: from hr_organization_units hou
2395: ,hr_organization_information hoi
2396: where hoi.org_information_context='IE_EHECS_OVERRIDE'
2397: and hoi.organization_id=c_org_id
2398: and hoi.organization_id=hou.organization_id

Line 2622: ,c_bg_id hr_organization_units.business_group_id%type

2618: l_action_info_id NUMBER;
2619: l_ovn NUMBER;
2620:
2621: CURSOR csr_ehecs_eit(c_org_id hr_organization_information.organization_id%type
2622: ,c_bg_id hr_organization_units.business_group_id%type
2623: ,p_year VARCHAR2
2624: ,p_qtr VARCHAR2) IS
2625: select hoi.org_information1 Year,
2626: hoi.org_information2 Qtr,

Line 2641: from hr_organization_units hou

2637: hoi.org_information13 Declarant,
2638: hoi.org_information14 Trng_subsidy,
2639: hoi.org_information15 otr_subsidy,
2640: hoi.org_information16 refunds
2641: from hr_organization_units hou
2642: ,hr_organization_information hoi
2643: where hoi.org_information_context='IE_EHECS'
2644: and hoi.organization_id=c_org_id
2645: and hoi.organization_id=hou.organization_id