APPS.PAY_NO_TAX_LEVY dependencies on HR_ALL_ORGANIZATION_UNITS

Line 101: l_payee_org_name hr_all_organization_units.NAME%type;

97: l_ovn NUMBER;
98: l_bimonth_year NUMBER;
99: l_le_org_num VARCHAR2(240);
100: l_le_name VARCHAR2(240);
101: l_payee_org_name hr_all_organization_units.NAME%type;
102:
103:
104: -- cursor to get Legal Employer Name and Org Num
105:

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

117:
118:
119: --cursor to get the third_party_name
120: cursor csr_third_party_name(l_payee_org number) is
121: select distinct haou.name name from hr_all_organization_units haou
122: where haou.ORGANIZATION_ID=l_payee_org;
123:
124: --cursor to check current archive exists
125: cursor csr_count is

Line 578: ,hr_all_organization_units hou

574: ,loc.address_line_2 line_2
575: ,loc.address_line_3 line_3
576: ,hr_general.decode_fnd_comm_lookup('NO_POSTAL_CODE',loc.postal_code) post_code
577: from hr_locations_all loc
578: ,hr_all_organization_units hou
579: where hou.organization_id = p_organization_id
580: and loc.location_id = hou.location_id
581: and loc.style = 'NO';
582:

Line 723: l_employer hr_all_organization_units.name%type;

719: procedure populate_details(p_payroll_action_id in varchar2,
720: p_template_name in varchar2,
721: p_xml out nocopy clob) is
722:
723: l_employer hr_all_organization_units.name%type;
724: l_orgnumber hr_organization_information.org_information1%type;
725: l_term varchar2(30);
726: l_year varchar2(8);
727: l_thirdparty_id pay_action_information.ACTION_INFORMATION5%type:='-999';