APPS.PAY_IE_P45PART3_P46_PKG dependencies on HR_LOCATIONS_ALL

Line 243: ,hr_locations_all hla

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

Line 256: l_addr1 hr_locations_all.address_line_1%type;

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

Line 257: l_addr2 hr_locations_all.address_line_2%type;

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

Line 258: l_addr3 hr_locations_all.address_line_3%type;

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

Line 260: l_telphone_no hr_locations_all.telephone_number_1%type;

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

Line 261: l_fax_no hr_locations_all.telephone_number_2%type;

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

Line 707: ,hr_locations_all hla

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

Line 720: l_addr1 hr_locations_all.address_line_1%type;

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

Line 721: l_addr2 hr_locations_all.address_line_2%type;

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

Line 722: l_addr3 hr_locations_all.address_line_3%type;

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

Line 724: l_telphone_no hr_locations_all.telephone_number_1%type;

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

Line 725: l_fax_no hr_locations_all.telephone_number_2%type;

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