APPS.PAY_IE_P45PART3_P46_PKG dependencies on HR_ORGANIZATION_UNITS

Line 228: ,c_bg_id hr_organization_units.business_group_id%type) IS

224: FROM pay_payroll_actions
225: WHERE payroll_action_id = pactid;
226:
227: CURSOR csr_employer_details(c_org_id hr_organization_information.organization_id%type
228: ,c_bg_id hr_organization_units.business_group_id%type) IS
229: select hoi.org_information2 regst_no
230: ,hou.name employer_name
231: ,hoi.org_information3 trade_name
232: ,hla.address_line_1 addr1

Line 238: from hr_organization_units hou

234: ,hla.address_line_3 addr3
235: ,hoi.org_information4 contact_name
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

Line 252: l_employer_name hr_organization_units.name%type;

248: l_action_info_id NUMBER;
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;

Line 692: ,c_bg_id hr_organization_units.business_group_id%type) IS

688: WHERE payroll_action_id = pactid;
689:
690: /*
691: CURSOR csr_employer_details(c_org_id hr_organization_information.organization_id%type
692: ,c_bg_id hr_organization_units.business_group_id%type) IS
693: select hoi.org_information2 regst_no
694: ,hou.name employer_name
695: ,hoi.org_information3 trade_name
696: ,hla.address_line_1 addr1

Line 702: from hr_organization_units hou

698: ,hla.address_line_3 addr3
699: ,hoi.org_information4 contact_name
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

Line 716: l_employer_name hr_organization_units.name%type;

712: l_action_info_id NUMBER;
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;