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 183: hr_organization_information hoi1

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

Line 191: csr_v_legal_employer_id hr_organization_information.organization_id%type

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

Line 199: hr_organization_information hoi_le,

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

Line 201: hr_organization_information hoi_lu

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

Line 310: csr_v_legal_employer_id hr_organization_information.organization_id%type

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

Line 318: hr_organization_information hoi_le,

314: local_unit_name,
315: hoi_lu.org_information1
316: local_unit_org_no, hou_lu.location_id
317: from hr_all_organization_units hou_le,
318: hr_organization_information hoi_le,
319: hr_all_organization_units hou_lu,
320: hr_organization_information hoi_lu
321: where hoi_le.organization_id = hou_le.organization_id
322: and hou_le.organization_id = csr_v_legal_employer_id

Line 320: hr_organization_information hoi_lu

316: local_unit_org_no, hou_lu.location_id
317: from hr_all_organization_units hou_le,
318: hr_organization_information hoi_le,
319: hr_all_organization_units hou_lu,
320: hr_organization_information hoi_lu
321: where hoi_le.organization_id = hou_le.organization_id
322: and hou_le.organization_id = csr_v_legal_employer_id
323: and hoi_le.org_information_context = 'NO_LOCAL_UNITS'
324: and hou_lu.organization_id = hoi_le.org_information1

Line 674: from hr_organization_information hoi, hr_soft_coding_keyflex hsc

670: cursor csr_get_org_no (
671: p_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type
672: ) is
673: select org_information1
674: from hr_organization_information hoi, hr_soft_coding_keyflex hsc
675: where org_information_context = 'NO_LOCAL_UNIT_DETAILS'
676: and hsc.segment2 = organization_id
677: and soft_coding_keyflex_id = p_soft_coding_keyflex_id;
678:

Line 939: l_lu_org_no hr_organization_information.org_information1%type;

935: l_user_status per_assignment_status_types.per_system_status%type;
936: l_old_user_status per_assignment_status_types.per_system_status%type;
937: l_last_update_date date;
938: l_alter_change char (1);
939: l_lu_org_no hr_organization_information.org_information1%type;
940: l_hour_element_entry_id number;
941: l_new_job_value varchar2 (100);
942: l_old_job_value varchar2 (100);
943: l_normal_hours number;