APPS.PAY_IE_EHECS_REPORT_PKG dependencies on HR_LOCATIONS_ALL

Line 476: ,hr_locations_all hla

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
479: and hoi.organization_id=hou.organization_id
480: and hou.business_group_id= c_bg_id

Line 533: l_addr1 hr_locations_all.address_line_1%type;

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

Line 534: l_addr2 hr_locations_all.address_line_2%type;

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;
536: l_addr4 hr_locations_all.address_line_3%type;
537: l_addr5 hr_locations_all.address_line_3%type;
538: l_cbr_no hr_organization_information.org_information3%type;

Line 535: l_addr3 hr_locations_all.address_line_3%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;
536: l_addr4 hr_locations_all.address_line_3%type;
537: l_addr5 hr_locations_all.address_line_3%type;
538: l_cbr_no hr_organization_information.org_information3%type;
539: l_person_id hr_organization_information.org_information13%type;

Line 536: l_addr4 hr_locations_all.address_line_3%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;
536: l_addr4 hr_locations_all.address_line_3%type;
537: l_addr5 hr_locations_all.address_line_3%type;
538: l_cbr_no hr_organization_information.org_information3%type;
539: l_person_id hr_organization_information.org_information13%type;
540: l_declarant_name per_all_people_f.full_name%type;

Line 537: l_addr5 hr_locations_all.address_line_3%type;

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;
536: l_addr4 hr_locations_all.address_line_3%type;
537: l_addr5 hr_locations_all.address_line_3%type;
538: l_cbr_no hr_organization_information.org_information3%type;
539: l_person_id hr_organization_information.org_information13%type;
540: l_declarant_name per_all_people_f.full_name%type;
541: l_declarant_phone per_all_people_f.office_number%type ;