APPS.PER_CA_EMP_EQUITY_PKG dependencies on PER_PERSON_TYPES

Line 125: from per_person_types

121:
122: /*Cursor for checking the validity of person type for an employee */
123: cursor cur_person_types is
124: select person_type_id
125: from per_person_types
126: where upper(ltrim(rtrim(system_person_type)))='EMP'
127: and business_group_id = p_business_group_id;
128:
129: /*Cursor for checking the NAIC code validation */

Line 473: /* Caching data from per_jobs and per_person_types tables */

469: delete
470: from per_ca_ee_report_lines
471: where request_id in (10,20,30);
472:
473: /* Caching data from per_jobs and per_person_types tables */
474:
475: open cur_jobs;
476: fetch cur_jobs bulk collect into
477: v_job_id_temp,