DBA Data[Home] [Help]

APPS.PER_CA_EMP_EQUITY_PKG dependencies on PER_PERSON_TYPES

Line 142: from per_person_types

138:
139: /*Cursor for checking the validity of person type for an employee */
140: cursor cur_person_types is
141: select person_type_id
142: from per_person_types
143: where upper(ltrim(rtrim(system_person_type)))='EMP'
144: and business_group_id = p_business_group_id;
145:
146:

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

530: delete
531: from per_ca_ee_report_lines
532: where request_id in (10,20,30);
533:
534: /* Caching data from per_jobs and per_person_types tables */
535:
536: open cur_jobs;
537: fetch cur_jobs bulk collect into
538: v_job_id_temp,