APPS.PER_EVT_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 845: l_business_group_id per_all_assignments_f.business_group_id%type;

841: ,p_business_group_id in per_events.business_group_id%TYPE
842: ) is
843: --
844: l_proc varchar2(72) := g_package||'chk_assignment_id';
845: l_business_group_id per_all_assignments_f.business_group_id%type;
846: l_assignment_id per_events.assignment_id%type;
847: --
848: cursor c_valid_asg(v_assignment_id number) is
849: select business_group_id

Line 850: from per_all_assignments_f asg

846: l_assignment_id per_events.assignment_id%type;
847: --
848: cursor c_valid_asg(v_assignment_id number) is
849: select business_group_id
850: from per_all_assignments_f asg
851: where asg.assignment_id = v_assignment_id
852: and p_date_start between effective_start_date and effective_end_date;
853: --
854: Begin

Line 1019: (select asg.person_id from per_all_assignments_f asg

1015: cursor csr_get_party_id is
1016: select max(per.party_id)
1017: from per_all_people_f per
1018: where per.person_id =
1019: (select asg.person_id from per_all_assignments_f asg
1020: where asg.assignment_id = p_rec.assignment_id
1021: and p_rec.date_start
1022: between asg.effective_start_date
1023: and asg.effective_end_date);