DBA Data[Home] [Help]

APPS.BEN_PER_ASG_EIT_LER dependencies on PER_ALL_ASSIGNMENTS_F

Line 516: select business_group_id from per_all_assignments_f where assignment_id = p_assignment_id;

512: order by person_id;
513: --
514: cursor get_business_group_id(p_assignment_id number)
515: is
516: select business_group_id from per_all_assignments_f where assignment_id = p_assignment_id;
517:
518: cursor get_person_id_primary_flag(p_assignment_id number)
519: is
520: SELECT primary_flag

Line 522: FROM per_all_assignments_f paf

518: cursor get_person_id_primary_flag(p_assignment_id number)
519: is
520: SELECT primary_flag
521: ,person_id
522: FROM per_all_assignments_f paf
523: WHERE assignment_id = p_assignment_id
524: AND l_effective_start_date BETWEEN paf.effective_start_date
525: AND paf.effective_end_date;
526: