APPS.PAY_IE_P45PART3_P46_PKG dependencies on HR_ORGANIZATION_UNITS

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

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

Line 241: from hr_organization_units hou

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

Line 255: l_employer_name hr_organization_units.name%type;

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

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

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

Line 705: from hr_organization_units hou

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

Line 719: l_employer_name hr_organization_units.name%type;

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