APPS.PAY_FI_ARCHIVE_PSTA dependencies on HR_ORGANIZATION_INFORMATION

Line 22: g_legal_empl_y_num hr_organization_information.org_information1%type;

18: g_year varchar2 (4);
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;

Line 24: g_local_unit_sd_no hr_organization_information.org_information1%type;

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;
28: g_lock_table lock_table;

Line 150: csr_v_legal_employer_id hr_organization_information.organization_id%type

146: p_payroll_action_id in number,
147: p_sql out nocopy varchar2
148: ) is
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

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 165: csr_v_local_unit_id hr_organization_information.organization_id%type

161:
162: l_legal_employer_details csr_legal_employer_details%rowtype;
163:
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

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 178: csr_v_legal_employer_id hr_organization_information.organization_id%type

174: and o1.organization_id = hoi2.organization_id
175: and hoi2.org_information_context = 'FI_LOCAL_UNIT_DETAILS';
176:
177: cursor csr_all_local_unit_details (
178: csr_v_legal_employer_id hr_organization_information.organization_id%type
179: ) is
180: select hoi_le.org_information1 local_unit_id, hou_lu.name local_unit_name, hoi_lu.org_information1 local_unit_sd_no,
181: hoi_lu.org_information7
182: from hr_all_organization_units hou_le,

Line 183: hr_organization_information hoi_le,

179: ) is
180: select hoi_le.org_information1 local_unit_id, hou_lu.name local_unit_name, hoi_lu.org_information1 local_unit_sd_no,
181: hoi_lu.org_information7
182: from hr_all_organization_units hou_le,
183: hr_organization_information hoi_le,
184: hr_all_organization_units hou_lu,
185: hr_organization_information hoi_lu
186: where hoi_le.organization_id = hou_le.organization_id
187: and hou_le.organization_id = csr_v_legal_employer_id

Line 185: hr_organization_information hoi_lu

181: hoi_lu.org_information7
182: from hr_all_organization_units hou_le,
183: hr_organization_information hoi_le,
184: hr_all_organization_units hou_lu,
185: hr_organization_information hoi_lu
186: where hoi_le.organization_id = hou_le.organization_id
187: and hou_le.organization_id = csr_v_legal_employer_id
188: and hoi_le.org_information_context = 'FI_LOCAL_UNITS'
189: and hou_lu.organization_id = hoi_le.org_information1

Line 379: hr_organization_information hoi,

375: pay_assignment_actions act1,
376: pay_action_interlocks pai,
377: per_all_assignments_f paaf,
378: hr_soft_coding_keyflex hsck,
379: hr_organization_information hoi,
380: pay_payrolls_f ppa
381: where appa.action_type in ('R', 'Q')
382: and act.payroll_action_id = appa.payroll_action_id
383: and act.source_action_id is null -- Master Action