APPS.HR_CONTRACT_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 1048: FROM per_all_assignments_f paf

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

Line 1079: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

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