APPS.PER_CA_EMP_EQUITY_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 164: from hr_organization_information hoi

160: (
161: hsck.segment6 is null and
162: exists
163: ( select 1
164: from hr_organization_information hoi
165: where hoi.org_information8 is not null and
166: hl.lookup_code=hoi.org_information8 and
167: hsck.segment1 = to_char(hoi.organization_id) and
168: hoi.org_information_context = 'Canada Employer Identification'

Line 261: from hr_organization_information hoi

257: (
258: hsck.segment6 is null and
259: exists
260: ( select 1
261: from hr_organization_information hoi
262: where hoi.org_information8 is not null and
263: hl.lookup_code=hoi.org_information8 and
264: hsck.segment1 = to_char(hoi.organization_id) and
265: hoi.org_information8 = p_naic_code and

Line 480: l_org_info hr_organization_information.org_information1%type;

476: /*Declaration of local variables */
477: table_date per_fastformula_events_utility.date_tab;
478:
479: l_output_txt varchar2(1000);
480: l_org_info hr_organization_information.org_information1%type;
481: l_personid per_all_people_f.person_id%type;
482: l_emp_no per_all_people_f.employee_number%type;
483: l_first_name per_all_people_f.first_name%type;
484: l_last_name per_all_people_f.last_name%type;

Line 493: l_naics_no hr_organization_information.org_information8%type;

489: l_province varchar2(5);
490: l_desg_abor per_all_people_f.per_information5%type;
491: l_desg_vminor per_all_people_f.per_information6%type;
492: l_desg_disab per_all_people_f.per_information7%type;
493: l_naics_no hr_organization_information.org_information8%type;
494: l_naics_no_gre hr_organization_information.org_information8%type;
495: l_hire_date date;
496: l_term_date date;
497: l_promo_date date;

Line 494: l_naics_no_gre hr_organization_information.org_information8%type;

490: l_desg_abor per_all_people_f.per_information5%type;
491: l_desg_vminor per_all_people_f.per_information6%type;
492: l_desg_disab per_all_people_f.per_information7%type;
493: l_naics_no hr_organization_information.org_information8%type;
494: l_naics_no_gre hr_organization_information.org_information8%type;
495: l_hire_date date;
496: l_term_date date;
497: l_promo_date date;
498: l_st_date date;