DBA Data[Home] [Help]

APPS.GHR_BEN_VALIDATION dependencies on PER_ASSIGNMENTS_F

Line 772: CURSOR c_assignment(c_person_id per_assignments_f.person_id%type,

768: p_person_extra_info_id number,
769: p_information_type in varchar2,
770: p_person_id in number
771: ) IS
772: CURSOR c_assignment(c_person_id per_assignments_f.person_id%type,
773: c_effective_date per_assignments_f.effective_start_date%type) IS
774: SELECT assignment_type, assignment_id
775: FROM per_all_assignments_f asg
776: WHERE asg.person_id = c_person_id

Line 773: c_effective_date per_assignments_f.effective_start_date%type) IS

769: p_information_type in varchar2,
770: p_person_id in number
771: ) IS
772: CURSOR c_assignment(c_person_id per_assignments_f.person_id%type,
773: c_effective_date per_assignments_f.effective_start_date%type) IS
774: SELECT assignment_type, assignment_id
775: FROM per_all_assignments_f asg
776: WHERE asg.person_id = c_person_id
777: AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;