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_INFORMATION

Line 512: /* CURSOR csr_employer_details(c_org_id hr_organization_information.organization_id%type

508: WHERE payroll_action_id = pactid;
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

Line 520: ,hr_organization_information hoi

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
524: and hoi.organization_id=hou.organization_id

Line 528: CURSOR csr_employer_details(c_org_id hr_organization_information.organization_id%type

524: and hoi.organization_id=hou.organization_id
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

Line 542: ,hr_organization_information hoi

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'
546: and hoi.organization_id=c_org_id

Line 556: CURSOR csr_declarant(c_org_id hr_organization_information.organization_id%type

552: and flv.lookup_code(+) = hla.REGION_1;
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

Line 566: ,hr_organization_information hoi

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
570: and hou.business_group_id= c_bg_id

Line 610: l_cbr_no hr_organization_information.org_information3%type;

606: l_addr2 hr_locations_all.address_line_2%type;
607: l_addr3 hr_locations_all.address_line_3%type;
608: l_addr4 hr_locations_all.address_line_3%type;
609: l_addr5 hr_locations_all.address_line_3%type;
610: l_cbr_no hr_organization_information.org_information3%type;
611: l_person_id hr_organization_information.org_information13%type;
612: l_declarant_name per_all_people_f.full_name%type;
613: l_declarant_phone per_all_people_f.office_number%type ;
614: l_declarant_email_add per_all_people_f.email_address%type;

Line 611: l_person_id hr_organization_information.org_information13%type;

607: l_addr3 hr_locations_all.address_line_3%type;
608: l_addr4 hr_locations_all.address_line_3%type;
609: l_addr5 hr_locations_all.address_line_3%type;
610: l_cbr_no hr_organization_information.org_information3%type;
611: l_person_id hr_organization_information.org_information13%type;
612: l_declarant_name per_all_people_f.full_name%type;
613: l_declarant_phone per_all_people_f.office_number%type ;
614: l_declarant_email_add per_all_people_f.email_address%type;
615: l_declarant_position per_all_positions.name%type;

Line 1176: CURSOR csr_hours_per_day(c_org_id hr_organization_information.organization_id%type

1172:
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

Line 1181: ,hr_organization_information hoi

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
1185: and hou.business_group_id= c_bg_id;

Line 2395: ,hr_organization_information hoi

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
2399: and hou.business_group_id= c_bg_id

Line 2621: CURSOR csr_ehecs_eit(c_org_id hr_organization_information.organization_id%type

2617: --l_asg_action_id NUMBER;
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,

Line 2642: ,hr_organization_information hoi

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
2646: and hou.business_group_id= c_bg_id