APPS.HR_EX_EMPLOYEE_API dependencies on PER_PERSON_TYPE_USAGES_F

Line 674: l_ptu_object_version_number per_person_type_usages_f.object_version_number%TYPE;

670: l_actual_termination_date date;
671: l_status varchar2(11);
672: l_current_dod date;
673: l_date_of_death date;
674: l_ptu_object_version_number per_person_type_usages_f.object_version_number%TYPE;
675: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
676: l_action_chk VARCHAR2(1) := 'N';
677:
678: l_saved_atd per_periods_of_service.actual_termination_date%TYPE;

Line 675: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;

671: l_status varchar2(11);
672: l_current_dod date;
673: l_date_of_death date;
674: l_ptu_object_version_number per_person_type_usages_f.object_version_number%TYPE;
675: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
676: l_action_chk VARCHAR2(1) := 'N';
677:
678: l_saved_atd per_periods_of_service.actual_termination_date%TYPE;
679: l_saved_lspd per_periods_of_service.last_standard_process_date%TYPE;

Line 697: from per_person_type_usages_f ptu, per_person_types ppt

693: l_start_date date;
694:
695: cursor fpt_future_ptu_changes is
696: select null
697: from per_person_type_usages_f ptu, per_person_types ppt
698: where ptu.person_id = l_person_id
699: and ptu.effective_start_date > l_actual_termination_date
700: and ppt.person_type_id = ptu.person_type_id
701: and ppt.system_person_type in ('EMP','CWK');

Line 2215: , per_person_type_usages_f ptu

2211: --
2212: cursor csr_valid_ex_emp is
2213: select null
2214: from per_all_people_f per
2215: , per_person_type_usages_f ptu
2216: , per_person_types pet
2217: where per.person_id = l_person_id
2218: and l_exemppet_eff_date between per.effective_start_date
2219: and per.effective_end_date