APPS.PER_PAR_BUS dependencies on PER_ALL_PEOPLE_F

Line 791: from per_all_people_f

787: --
788: Cursor csr_person_bg
789: is
790: select business_group_id
791: from per_all_people_f
792: where person_id = p_person_id;
793: -- Bug 1980440 fix
794: -- Cursor to check if person is valid as of effective date
795: -- this cursor uses per_all_people_f to support Cross Business Group

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

791: from per_all_people_f
792: where person_id = p_person_id;
793: -- Bug 1980440 fix
794: -- Cursor to check if person is valid as of effective date
795: -- this cursor uses per_all_people_f to support Cross Business Group
796: --
797: Cursor csr_cbg_person_bg
798: is
799: select business_group_id

Line 800: from per_all_people_f

796: --
797: Cursor csr_cbg_person_bg
798: is
799: select business_group_id
800: from per_all_people_f
801: where person_id = p_person_id;
802: --
803: --
804: -- Cursor to check if person is valid

Line 810: from per_all_people_f

806: --
807: Cursor csr_person_valid_date
808: is
809: select 'Y'
810: from per_all_people_f
811: where person_id = p_person_id
812: and p_effective_date between
813: effective_start_date and nvl(effective_end_date,hr_api.g_eot);
814:

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

813: effective_start_date and nvl(effective_end_date,hr_api.g_eot);
814:
815: -- Bug 1980440 fix
816: -- Cursor to check if person is valid as of effective date
817: -- this cursor uses per_all_people_f to support Cross Business Group
818: --
819: Cursor csr_cbg_person_valid_date
820: is
821: select 'Y'

Line 822: from per_all_people_f

818: --
819: Cursor csr_cbg_person_valid_date
820: is
821: select 'Y'
822: from per_all_people_f
823: where person_id = p_person_id
824: and p_effective_date between
825: effective_start_date and nvl(effective_end_date,hr_api.g_eot);
826: