APPS.PAY_IE_EHECS_REPORT_PKG dependencies on HR_LOCATIONS_ALL

Line 521: ,hr_locations_all hla

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

Line 543: ,hr_locations_all hla

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

Line 605: l_addr1 hr_locations_all.address_line_1%type;

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;
608: l_addr4 hr_locations_all.address_line_3%type;
609: l_addr5 hr_locations_all.address_line_3%type;

Line 606: l_addr2 hr_locations_all.address_line_2%type;

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;
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;

Line 607: l_addr3 hr_locations_all.address_line_3%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;
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;

Line 608: l_addr4 hr_locations_all.address_line_3%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;
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;

Line 609: l_addr5 hr_locations_all.address_line_3%type;

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;
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 ;