APPS.PAY_NO_EERR_STATUS_CONTROL dependencies on HR_ORGANIZATION_INFORMATION

Line 48: g_legal_employer_org_no hr_organization_information.org_information1%type;

44: g_absence_termination_limit number := 0;
45: g_report_mode varchar2 (80);
46: g_effective_start_date date;
47: g_legal_employer_name hr_all_organization_units.name%type;
48: g_legal_employer_org_no hr_organization_information.org_information1%type;
49: g_no_hours_change_weeks number := 0;
50: /* GET PARAMETER */
51: function get_parameter (
52: p_parameter_string in varchar2,

Line 180: hr_organization_information hoi1

176: legal_employer_name, org.location_id,
177: hoi1.org_information1
178: legal_employer_org_no
179: from hr_all_organization_units org,
180: hr_organization_information hoi1
181: where org.organization_id = p_legal_employer_id
182: and hoi1.organization_id(+) = org.organization_id
183: and hoi1.org_information_context(+) = 'NO_LEGAL_EMPLOYER_DETAILS';
184:

Line 188: csr_v_legal_employer_id hr_organization_information.organization_id%type

184:
185: l_legal_employer_rec csr_legal_employers%rowtype;
186:
187: cursor csr_all_local_unit_details (
188: csr_v_legal_employer_id hr_organization_information.organization_id%type
189: ) is
190: select hoi_le.org_information1 local_unit_id,
191: hou_lu.name
192: local_unit_name,

Line 196: hr_organization_information hoi_le,

192: local_unit_name,
193: hoi_lu.org_information1
194: local_unit_org_no, hou_lu.location_id
195: from hr_all_organization_units hou_le,
196: hr_organization_information hoi_le,
197: hr_all_organization_units hou_lu,
198: hr_organization_information hoi_lu
199: where hoi_le.organization_id = hou_le.organization_id
200: and hou_le.organization_id = csr_v_legal_employer_id

Line 198: hr_organization_information hoi_lu

194: local_unit_org_no, hou_lu.location_id
195: from hr_all_organization_units hou_le,
196: hr_organization_information hoi_le,
197: hr_all_organization_units hou_lu,
198: hr_organization_information hoi_lu
199: where hoi_le.organization_id = hou_le.organization_id
200: and hou_le.organization_id = csr_v_legal_employer_id
201: and hoi_le.org_information_context = 'NO_LOCAL_UNITS'
202: and hou_lu.organization_id = hoi_le.org_information1

Line 306: csr_v_legal_employer_id hr_organization_information.organization_id%type

302: and p_effective_date between effective_start_date and effective_end_date ;
303:
304: /* Cursor to get Local Unit Details based on the Legal Employers */
305: cursor csr_all_local_unit_details (
306: csr_v_legal_employer_id hr_organization_information.organization_id%type
307: ) is
308: select hoi_le.org_information1 local_unit_id,
309: hou_lu.name
310: local_unit_name,

Line 314: hr_organization_information hoi_le,

310: local_unit_name,
311: hoi_lu.org_information1
312: local_unit_org_no, hou_lu.location_id
313: from hr_all_organization_units hou_le,
314: hr_organization_information hoi_le,
315: hr_all_organization_units hou_lu,
316: hr_organization_information hoi_lu
317: where hoi_le.organization_id = hou_le.organization_id
318: and hou_le.organization_id = csr_v_legal_employer_id

Line 316: hr_organization_information hoi_lu

312: local_unit_org_no, hou_lu.location_id
313: from hr_all_organization_units hou_le,
314: hr_organization_information hoi_le,
315: hr_all_organization_units hou_lu,
316: hr_organization_information hoi_lu
317: where hoi_le.organization_id = hou_le.organization_id
318: and hou_le.organization_id = csr_v_legal_employer_id
319: and hoi_le.org_information_context = 'NO_LOCAL_UNITS'
320: and hou_lu.organization_id = hoi_le.org_information1

Line 498: from hr_organization_information hoi, hr_soft_coding_keyflex hsc

494: cursor csr_get_org_no (
495: p_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type
496: ) is
497: select org_information1
498: from hr_organization_information hoi, hr_soft_coding_keyflex hsc
499: where org_information_context = 'NO_LOCAL_UNIT_DETAILS'
500: and hsc.segment2 = organization_id
501: and soft_coding_keyflex_id = p_soft_coding_keyflex_id;
502:

Line 763: l_lu_org_no hr_organization_information.org_information1%type;

759: l_user_status per_assignment_status_types.per_system_status%type;
760: l_old_user_status per_assignment_status_types.per_system_status%type;
761: l_last_update_date date;
762: l_alter_change char (1);
763: l_lu_org_no hr_organization_information.org_information1%type;
764: l_hour_element_entry_id number;
765: l_new_job_value varchar2 (100);
766: l_old_job_value varchar2 (100);
767: l_normal_hours number;