eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_FI_ARCHIVE_PSTA dependencies on HR_ORGANIZATION_UNITS

Line 23: g_legal_emp_name hr_organization_units.name%type;

19: g_local_unit_id number;
20: g_archive varchar2 (50);
21: g_payroll_type_code varchar2 (50);
22: g_legal_empl_y_num hr_organization_information.org_information1%type;
23: g_legal_emp_name hr_organization_units.name%type;
24: g_local_unit_sd_no hr_organization_information.org_information1%type;
25: g_local_unit_name hr_organization_units.name%type;
26: g_year_last_date date;
27: g_year_start_date date;

Line 25: g_local_unit_name hr_organization_units.name%type;

21: g_payroll_type_code varchar2 (50);
22: g_legal_empl_y_num hr_organization_information.org_information1%type;
23: g_legal_emp_name hr_organization_units.name%type;
24: g_local_unit_sd_no hr_organization_information.org_information1%type;
25: g_local_unit_name hr_organization_units.name%type;
26: g_year_last_date date;
27: g_year_start_date date;
28: g_lock_table lock_table;
29: g_index number := -1;

Line 153: from hr_organization_units o1, hr_organization_information hoi1, hr_organization_information hoi2

149: cursor csr_legal_employer_details (
150: csr_v_legal_employer_id hr_organization_information.organization_id%type
151: ) is
152: select o1.name legal_employer_name, hoi2.org_information1 legal_emp_y_num, hoi2.org_information11
153: from hr_organization_units o1, hr_organization_information hoi1, hr_organization_information hoi2
154: where o1.business_group_id = g_business_group_id
155: and hoi1.organization_id = o1.organization_id
156: and hoi1.organization_id = csr_v_legal_employer_id
157: and hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 168: from hr_organization_units o1, hr_organization_information hoi1, hr_organization_information hoi2

164: cursor csr_local_unit_details (
165: csr_v_local_unit_id hr_organization_information.organization_id%type
166: ) is
167: select o1.name local_unit_name, hoi2.org_information1 local_unit_sd_no, hoi2.org_information7
168: from hr_organization_units o1, hr_organization_information hoi1, hr_organization_information hoi2
169: where o1.business_group_id = g_business_group_id
170: and hoi1.organization_id = o1.organization_id
171: and hoi1.organization_id = csr_v_local_unit_id
172: and hoi1.org_information1 = 'FI_LOCAL_UNIT'

Line 197: from hr_organization_units hou, hr_locations hl

193: cursor csr_get_org_address (
194: p_organization_id number
195: ) is
196: select style, address_line_1, address_line_2, address_line_3, country, postal_code
197: from hr_organization_units hou, hr_locations hl
198: where hou.organization_id = p_organization_id and hou.location_id = hl.location_id;
199:
200: rl_get_org_address csr_get_org_address%rowtype;
201: rg_local_unit_details csr_local_unit_details%rowtype;