APPS.HR_CONTRACT_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 1049: FROM per_all_assignments_f paf

1045: -- (used when the start-date is moved forward)
1046: --
1047: cursor csr_asg_ctr IS
1048: SELECT assignment_id, contract_id
1049: FROM per_all_assignments_f paf
1050: WHERE paf.person_id = p_person_id
1051: AND p_old_start_date BETWEEN paf.effective_start_date AND
1052: paf.effective_end_date
1053: AND paf.contract_id IS NOT NULL;

Line 1080: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

1076: and not exists(select 1 from per_all_people_f
1077: where person_id = p_person_id);
1078: --
1079: l_contract_id per_contracts_f.contract_id%TYPE;
1080: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1081: l_start_date per_contracts_f.effective_start_date%TYPE;
1082: l_end_date per_contracts_f.effective_end_date%TYPE;
1083: l_effective_start_date per_contracts_f.effective_start_date%TYPE;
1084: l_object_version_number per_contracts_f.object_version_number%TYPE;