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_NES_REPORT_PKG dependencies on HR_LOCATIONS_ALL

Line 593: ,hr_locations_all hla

589: ,hla.COUNTRY Country_Name
590: ,hla.REGION_1
591: from hr_organization_units hou
592: ,hr_organization_information hoi
593: ,hr_locations_all hla
594: ,fnd_lookup_values flv
595: where hoi.org_information_context='IE_EMPLOYER_INFO'
596: and hoi.organization_id=c_org_id
597: and hoi.organization_id=hou.organization_id

Line 637: l_addr1 hr_locations_all.address_line_1%type;

633: l_ovn NUMBER;
634: l_org_id hr_organization_units.organization_id%type;
635: l_employer_name hr_organization_units.name%type;
636:
637: l_addr1 hr_locations_all.address_line_1%type;
638: l_addr2 hr_locations_all.address_line_2%type;
639: l_addr3 hr_locations_all.address_line_3%type;
640: l_addr4 hr_locations_all.address_line_3%type;
641: l_addr5 hr_locations_all.address_line_3%type;

Line 638: l_addr2 hr_locations_all.address_line_2%type;

634: l_org_id hr_organization_units.organization_id%type;
635: l_employer_name hr_organization_units.name%type;
636:
637: l_addr1 hr_locations_all.address_line_1%type;
638: l_addr2 hr_locations_all.address_line_2%type;
639: l_addr3 hr_locations_all.address_line_3%type;
640: l_addr4 hr_locations_all.address_line_3%type;
641: l_addr5 hr_locations_all.address_line_3%type;
642: l_cbr_no hr_organization_information.org_information3%type;

Line 639: l_addr3 hr_locations_all.address_line_3%type;

635: l_employer_name hr_organization_units.name%type;
636:
637: l_addr1 hr_locations_all.address_line_1%type;
638: l_addr2 hr_locations_all.address_line_2%type;
639: l_addr3 hr_locations_all.address_line_3%type;
640: l_addr4 hr_locations_all.address_line_3%type;
641: l_addr5 hr_locations_all.address_line_3%type;
642: l_cbr_no hr_organization_information.org_information3%type;
643: l_person_id hr_organization_information.org_information13%type;

Line 640: l_addr4 hr_locations_all.address_line_3%type;

636:
637: l_addr1 hr_locations_all.address_line_1%type;
638: l_addr2 hr_locations_all.address_line_2%type;
639: l_addr3 hr_locations_all.address_line_3%type;
640: l_addr4 hr_locations_all.address_line_3%type;
641: l_addr5 hr_locations_all.address_line_3%type;
642: l_cbr_no hr_organization_information.org_information3%type;
643: l_person_id hr_organization_information.org_information13%type;
644: l_declarant_name per_all_people_f.full_name%type;

Line 641: l_addr5 hr_locations_all.address_line_3%type;

637: l_addr1 hr_locations_all.address_line_1%type;
638: l_addr2 hr_locations_all.address_line_2%type;
639: l_addr3 hr_locations_all.address_line_3%type;
640: l_addr4 hr_locations_all.address_line_3%type;
641: l_addr5 hr_locations_all.address_line_3%type;
642: l_cbr_no hr_organization_information.org_information3%type;
643: l_person_id hr_organization_information.org_information13%type;
644: l_declarant_name per_all_people_f.full_name%type;
645: l_declarant_phone per_all_people_f.office_number%type ;

Line 1430: l_address_line1 hr_locations_all.address_line_1%type;

1426: l_input_value_id NUMBER;
1427: l_input_value_id1 NUMBER;
1428: l_employee_details csr_employee_details%ROWTYPE;
1429:
1430: l_address_line1 hr_locations_all.address_line_1%type;
1431: l_address_line2 hr_locations_all.address_line_2%type;
1432: l_address_line3 hr_locations_all.address_line_3%type;
1433: l_address_line4 hr_locations_all.address_line_3%type;
1434: l_address_line5 hr_locations_all.address_line_3%type;

Line 1431: l_address_line2 hr_locations_all.address_line_2%type;

1427: l_input_value_id1 NUMBER;
1428: l_employee_details csr_employee_details%ROWTYPE;
1429:
1430: l_address_line1 hr_locations_all.address_line_1%type;
1431: l_address_line2 hr_locations_all.address_line_2%type;
1432: l_address_line3 hr_locations_all.address_line_3%type;
1433: l_address_line4 hr_locations_all.address_line_3%type;
1434: l_address_line5 hr_locations_all.address_line_3%type;
1435:

Line 1432: l_address_line3 hr_locations_all.address_line_3%type;

1428: l_employee_details csr_employee_details%ROWTYPE;
1429:
1430: l_address_line1 hr_locations_all.address_line_1%type;
1431: l_address_line2 hr_locations_all.address_line_2%type;
1432: l_address_line3 hr_locations_all.address_line_3%type;
1433: l_address_line4 hr_locations_all.address_line_3%type;
1434: l_address_line5 hr_locations_all.address_line_3%type;
1435:
1436: l_id_reference per_all_assignments_f.assignment_number%TYPE:=NULL;

Line 1433: l_address_line4 hr_locations_all.address_line_3%type;

1429:
1430: l_address_line1 hr_locations_all.address_line_1%type;
1431: l_address_line2 hr_locations_all.address_line_2%type;
1432: l_address_line3 hr_locations_all.address_line_3%type;
1433: l_address_line4 hr_locations_all.address_line_3%type;
1434: l_address_line5 hr_locations_all.address_line_3%type;
1435:
1436: l_id_reference per_all_assignments_f.assignment_number%TYPE:=NULL;
1437:

Line 1434: l_address_line5 hr_locations_all.address_line_3%type;

1430: l_address_line1 hr_locations_all.address_line_1%type;
1431: l_address_line2 hr_locations_all.address_line_2%type;
1432: l_address_line3 hr_locations_all.address_line_3%type;
1433: l_address_line4 hr_locations_all.address_line_3%type;
1434: l_address_line5 hr_locations_all.address_line_3%type;
1435:
1436: l_id_reference per_all_assignments_f.assignment_number%TYPE:=NULL;
1437:
1438: l_valid_asg_rec cur_valid_asg%ROWTYPE;