APPS.PER_PAR_BUS dependencies on PER_ALL_PEOPLE_F

Line 783: from per_all_people_f

779: --
780: Cursor csr_person_bg
781: is
782: select business_group_id
783: from per_all_people_f
784: where person_id = p_person_id;
785: -- Bug 1980440 fix
786: -- Cursor to check if person is valid as of effective date
787: -- this cursor uses per_all_people_f to support Cross Business Group

Line 787: -- this cursor uses per_all_people_f to support Cross Business Group

783: from per_all_people_f
784: where person_id = p_person_id;
785: -- Bug 1980440 fix
786: -- Cursor to check if person is valid as of effective date
787: -- this cursor uses per_all_people_f to support Cross Business Group
788: --
789: Cursor csr_cbg_person_bg
790: is
791: select business_group_id

Line 792: from per_all_people_f

788: --
789: Cursor csr_cbg_person_bg
790: is
791: select business_group_id
792: from per_all_people_f
793: where person_id = p_person_id;
794: --
795: --
796: -- Cursor to check if person is valid

Line 802: from per_all_people_f

798: --
799: Cursor csr_person_valid_date
800: is
801: select 'Y'
802: from per_all_people_f
803: where person_id = p_person_id
804: and p_effective_date between
805: effective_start_date and nvl(effective_end_date,hr_api.g_eot);
806:

Line 809: -- this cursor uses per_all_people_f to support Cross Business Group

805: effective_start_date and nvl(effective_end_date,hr_api.g_eot);
806:
807: -- Bug 1980440 fix
808: -- Cursor to check if person is valid as of effective date
809: -- this cursor uses per_all_people_f to support Cross Business Group
810: --
811: Cursor csr_cbg_person_valid_date
812: is
813: select 'Y'

Line 814: from per_all_people_f

810: --
811: Cursor csr_cbg_person_valid_date
812: is
813: select 'Y'
814: from per_all_people_f
815: where person_id = p_person_id
816: and p_effective_date between
817: effective_start_date and nvl(effective_end_date,hr_api.g_eot);
818: