APPS.PAY_IE_P45PART3_P46_PKG dependencies on HR_LOCATIONS_ALL

Line 240: ,hr_locations_all hla

236: ,hla.telephone_number_1 telphone_no
237: ,hla.telephone_number_2 fax
238: from hr_organization_units hou
239: ,hr_organization_information hoi
240: ,hr_locations_all hla
241: where hoi.org_information_context='IE_EMPLOYER_INFO'
242: and hoi.organization_id=c_org_id
243: and hoi.organization_id=hou.organization_id
244: and hou.business_group_id= c_bg_id

Line 253: l_addr1 hr_locations_all.address_line_1%type;

249: l_ovn NUMBER;
250: l_regst_no hr_organization_information.org_information2%type;
251: l_trade_name hr_organization_information.org_information3%type;
252: l_employer_name hr_organization_units.name%type;
253: l_addr1 hr_locations_all.address_line_1%type;
254: l_addr2 hr_locations_all.address_line_2%type;
255: l_addr3 hr_locations_all.address_line_3%type;
256: l_contact_name hr_organization_information.org_information4%type;
257: l_telphone_no hr_locations_all.telephone_number_1%type;

Line 254: l_addr2 hr_locations_all.address_line_2%type;

250: l_regst_no hr_organization_information.org_information2%type;
251: l_trade_name hr_organization_information.org_information3%type;
252: l_employer_name hr_organization_units.name%type;
253: l_addr1 hr_locations_all.address_line_1%type;
254: l_addr2 hr_locations_all.address_line_2%type;
255: l_addr3 hr_locations_all.address_line_3%type;
256: l_contact_name hr_organization_information.org_information4%type;
257: l_telphone_no hr_locations_all.telephone_number_1%type;
258: l_fax_no hr_locations_all.telephone_number_2%type;

Line 255: l_addr3 hr_locations_all.address_line_3%type;

251: l_trade_name hr_organization_information.org_information3%type;
252: l_employer_name hr_organization_units.name%type;
253: l_addr1 hr_locations_all.address_line_1%type;
254: l_addr2 hr_locations_all.address_line_2%type;
255: l_addr3 hr_locations_all.address_line_3%type;
256: l_contact_name hr_organization_information.org_information4%type;
257: l_telphone_no hr_locations_all.telephone_number_1%type;
258: l_fax_no hr_locations_all.telephone_number_2%type;
259:

Line 257: l_telphone_no hr_locations_all.telephone_number_1%type;

253: l_addr1 hr_locations_all.address_line_1%type;
254: l_addr2 hr_locations_all.address_line_2%type;
255: l_addr3 hr_locations_all.address_line_3%type;
256: l_contact_name hr_organization_information.org_information4%type;
257: l_telphone_no hr_locations_all.telephone_number_1%type;
258: l_fax_no hr_locations_all.telephone_number_2%type;
259:
260: BEGIN
261:

Line 258: l_fax_no hr_locations_all.telephone_number_2%type;

254: l_addr2 hr_locations_all.address_line_2%type;
255: l_addr3 hr_locations_all.address_line_3%type;
256: l_contact_name hr_organization_information.org_information4%type;
257: l_telphone_no hr_locations_all.telephone_number_1%type;
258: l_fax_no hr_locations_all.telephone_number_2%type;
259:
260: BEGIN
261:
262: l_procedure_name := g_package||'range_code';

Line 704: ,hr_locations_all hla

700: ,hla.telephone_number_1 telphone_no
701: ,hla.telephone_number_2 fax
702: from hr_organization_units hou
703: ,hr_organization_information hoi
704: ,hr_locations_all hla
705: where hoi.org_information_context='IE_EMPLOYER_INFO'
706: and hoi.organization_id=c_org_id
707: and hoi.organization_id=hou.organization_id
708: and hou.business_group_id= c_bg_id

Line 717: l_addr1 hr_locations_all.address_line_1%type;

713: l_ovn NUMBER;
714: l_regst_no hr_organization_information.org_information2%type;
715: l_trade_name hr_organization_information.org_information3%type;
716: l_employer_name hr_organization_units.name%type;
717: l_addr1 hr_locations_all.address_line_1%type;
718: l_addr2 hr_locations_all.address_line_2%type;
719: l_addr3 hr_locations_all.address_line_3%type;
720: l_contact_name hr_organization_information.org_information4%type;
721: l_telphone_no hr_locations_all.telephone_number_1%type;

Line 718: l_addr2 hr_locations_all.address_line_2%type;

714: l_regst_no hr_organization_information.org_information2%type;
715: l_trade_name hr_organization_information.org_information3%type;
716: l_employer_name hr_organization_units.name%type;
717: l_addr1 hr_locations_all.address_line_1%type;
718: l_addr2 hr_locations_all.address_line_2%type;
719: l_addr3 hr_locations_all.address_line_3%type;
720: l_contact_name hr_organization_information.org_information4%type;
721: l_telphone_no hr_locations_all.telephone_number_1%type;
722: l_fax_no hr_locations_all.telephone_number_2%type;

Line 719: l_addr3 hr_locations_all.address_line_3%type;

715: l_trade_name hr_organization_information.org_information3%type;
716: l_employer_name hr_organization_units.name%type;
717: l_addr1 hr_locations_all.address_line_1%type;
718: l_addr2 hr_locations_all.address_line_2%type;
719: l_addr3 hr_locations_all.address_line_3%type;
720: l_contact_name hr_organization_information.org_information4%type;
721: l_telphone_no hr_locations_all.telephone_number_1%type;
722: l_fax_no hr_locations_all.telephone_number_2%type;
723: */

Line 721: l_telphone_no hr_locations_all.telephone_number_1%type;

717: l_addr1 hr_locations_all.address_line_1%type;
718: l_addr2 hr_locations_all.address_line_2%type;
719: l_addr3 hr_locations_all.address_line_3%type;
720: l_contact_name hr_organization_information.org_information4%type;
721: l_telphone_no hr_locations_all.telephone_number_1%type;
722: l_fax_no hr_locations_all.telephone_number_2%type;
723: */
724: BEGIN
725: hr_utility.set_location('Entering: pay_ie_p45p3_p46_pkg.archive_init: ',940);

Line 722: l_fax_no hr_locations_all.telephone_number_2%type;

718: l_addr2 hr_locations_all.address_line_2%type;
719: l_addr3 hr_locations_all.address_line_3%type;
720: l_contact_name hr_organization_information.org_information4%type;
721: l_telphone_no hr_locations_all.telephone_number_1%type;
722: l_fax_no hr_locations_all.telephone_number_2%type;
723: */
724: BEGIN
725: hr_utility.set_location('Entering: pay_ie_p45p3_p46_pkg.archive_init: ',940);
726: