APPS.PER_CA_EMP_EQUITY_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 146: from hr_organization_information hoi

142: (
143: hsck.segment6 is null and
144: exists
145: ( select 1
146: from hr_organization_information hoi
147: where hoi.org_information8 is not null and
148: hl.lookup_code=hoi.org_information8 and
149: hsck.segment1 = to_char(hoi.organization_id) and
150: hoi.org_information_context = 'Canada Employer Identification'

Line 238: from hr_organization_information hoi

234: (
235: hsck.segment6 is null and
236: exists
237: ( select 1
238: from hr_organization_information hoi
239: where hoi.org_information8 is not null and
240: hl.lookup_code=hoi.org_information8 and
241: hsck.segment1 = to_char(hoi.organization_id) and
242: hoi.org_information8 = p_naic_code and

Line 423: l_org_info hr_organization_information.org_information1%type;

419: /*Declaration of local variables */
420: table_date per_fastformula_events_utility.date_tab;
421:
422: l_output_txt varchar2(1000);
423: l_org_info hr_organization_information.org_information1%type;
424: l_personid per_all_people_f.person_id%type;
425: l_emp_no per_all_people_f.employee_number%type;
426: l_first_name per_all_people_f.first_name%type;
427: l_last_name per_all_people_f.last_name%type;

Line 436: l_naics_no hr_organization_information.org_information8%type;

432: l_province varchar2(5);
433: l_desg_abor per_all_people_f.per_information5%type;
434: l_desg_vminor per_all_people_f.per_information6%type;
435: l_desg_disab per_all_people_f.per_information7%type;
436: l_naics_no hr_organization_information.org_information8%type;
437: l_naics_no_gre hr_organization_information.org_information8%type;
438: l_hire_date date;
439: l_term_date date;
440: l_promo_date date;

Line 437: l_naics_no_gre hr_organization_information.org_information8%type;

433: l_desg_abor per_all_people_f.per_information5%type;
434: l_desg_vminor per_all_people_f.per_information6%type;
435: l_desg_disab per_all_people_f.per_information7%type;
436: l_naics_no hr_organization_information.org_information8%type;
437: l_naics_no_gre hr_organization_information.org_information8%type;
438: l_hire_date date;
439: l_term_date date;
440: l_promo_date date;
441: l_st_date date;