APPS.PAY_NO_UNION_DUES dependencies on HR_ALL_ORGANIZATION_UNITS

Line 110: l_payee_org_name hr_all_organization_units.NAME%type;

106: l_ovn NUMBER;
107: l_bimonth_year NUMBER;
108: l_le_org_num VARCHAR2(240);
109: l_le_name VARCHAR2(240);
110: l_payee_org_name hr_all_organization_units.NAME%type;
111:
112:
113: -- Cursors
114:

Line 126: select distinct haou.name name from hr_all_organization_units haou

122: and hoi.organization_id = l_leg_emp_id
123: and hoi.org_information_context = to_char('NO_LEGAL_EMPLOYER_DETAILS');
124:
125: cursor csr_third_party_name(l_payee_org number) is
126: select distinct haou.name name from hr_all_organization_units haou
127: where haou.ORGANIZATION_ID=l_payee_org;
128:
129: --cursor to check current archive exists
130: cursor csr_count is

Line 570: ,hr_all_organization_units hou

566: ,loc.address_line_2 line_2
567: ,loc.address_line_3 line_3
568: ,hr_general.decode_fnd_comm_lookup('NO_POSTAL_CODE',loc.postal_code) post_code
569: from hr_locations_all loc
570: ,hr_all_organization_units hou
571: where hou.organization_id = p_organization_id
572: and loc.location_id = hou.location_id
573: and loc.style = 'NO';
574:

Line 720: l_employer hr_all_organization_units.name%type;

716: procedure populate_details(p_payroll_action_id in varchar2,
717: p_template_name in varchar2,
718: p_xml out nocopy clob) is
719:
720: l_employer hr_all_organization_units.name%type;
721: l_orgnumber hr_organization_information.org_information1%type;
722: l_from_date DATE;
723: l_to_date DATE;
724: l_thirdparty_id pay_action_information.ACTION_INFORMATION5%type:='-999';