APPS.PER_ASN_BUS dependencies on PER_ALL_PEOPLE_F

Line 316: from per_all_people_f per

312: -- Define cursors and their necessary variables
313: --
314: cursor csr_chk_person_sta_date is
315: select distinct(min(effective_start_date)), business_group_id
316: from per_all_people_f per
317: where per.person_id = p_person_id
318: group by business_group_id;
319: --
320: l_ASN_PERS_STA_DATE per_people_f.start_date%TYPE;

Line 416: from per_all_people_f per

412: lv_cross_business_group varchar2(10); -- bug 1980440 fix
413: --
414: cursor csr_chk_assessper_sta_date is
415: select distinct(min(effective_start_date)), business_group_id
416: from per_all_people_f per
417: where per.person_id = p_assessor_person_id
418: group by business_group_id;
419: -- Fix 3122878. Using per_all_people_f instead of per_people_f.
420: --

Line 419: -- Fix 3122878. Using per_all_people_f instead of per_people_f.

415: select distinct(min(effective_start_date)), business_group_id
416: from per_all_people_f per
417: where per.person_id = p_assessor_person_id
418: group by business_group_id;
419: -- Fix 3122878. Using per_all_people_f instead of per_people_f.
420: --
421: l_ASN_ASSPERS_STA_DATE per_people_f.start_date%TYPE;
422: l_ASN_ASSPERS_BG per_people_f.business_group_id%TYPE;
423: --

Line 602: from per_all_people_f per

598: l_proc varchar2(72):=g_package||'chk_group_initiator_id';
599: --
600: cursor csr_chk_grp_per_sta_date is
601: select distinct(min(effective_start_date)), business_group_id
602: from per_all_people_f per
603: where per.person_id = p_group_initiator_id
604: group by business_group_id;
605: --
606: l_asn_grp_pers_sta_date per_people_f.start_date%TYPE;