APPS.PER_APR_BUS dependencies on PER_ALL_PEOPLE_F

Line 285: , per_all_people_f per

281: cursor csr_fetch_type is
282: select ppt.system_person_type
283: from per_person_types ppt
284: , per_person_type_usages_f ptu
285: , per_all_people_f per
286: where per.person_id = p_rec.appraisee_person_id
287: and p_rec.appraisal_date BETWEEN per.effective_start_date AND per.effective_end_date
288: AND ptu.person_id = per.person_id
289: and p_rec.appraisal_date BETWEEN ptu.effective_start_date AND ptu.effective_end_date

Line 781: from per_all_people_f

777:
778: Cursor csr_person_bg
779: is
780: select business_group_id
781: from per_all_people_f
782: where person_id = p_person_id;
783:
784: -- bug 1980440 fix
785: -- WE NEED to use different cursors as Appraiser can be changed to

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: -- Cursor to check if person is valid
796: -- as of effective date

Line 801: from per_all_people_f

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

Line 815: from per_all_people_f

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

Line 955: from per_all_people_f

951:
952: Cursor csr_person_valid_date
953: is
954: select 'Y'
955: from per_all_people_f
956: where person_id = p_main_appraiser_id
957: and business_group_id = p_business_group_id
958: and p_effective_date between
959: effective_start_date and nvl(effective_end_date,hr_api.g_eot);

Line 967: from per_all_people_f

963:
964: Cursor csr_cbg_person_valid_date
965: is
966: select 'Y'
967: from per_all_people_f
968: where person_id = p_main_appraiser_id
969: and p_effective_date between
970: effective_start_date and nvl(effective_end_date,hr_api.g_eot);
971:

Line 1329: from per_all_people_f per

1325: l_proc varchar2(72):=g_package||'chk_group_initiator_id';
1326:
1327: cursor csr_chk_grp_per_sta_date is
1328: select distinct(min(effective_start_date)), business_group_id
1329: from per_all_people_f per
1330: where per.person_id = p_group_initiator_id
1331: group by business_group_id;
1332:
1333: l_asn_grp_pers_sta_date per_people_f.start_date%TYPE;

Line 1545: ,p_person_id in per_all_people_f.person_id%TYPE

1541: -- Function to return whether or not the date is valid
1542:
1543: function validate_date
1544: (p_date in date
1545: ,p_person_id in per_all_people_f.person_id%TYPE
1546: ) RETURN boolean IS
1547:
1548: l_exists varchar2(1);
1549: l_person_type per_person_types.system_person_type%TYPE;

Line 1560: per_all_people_f per

1556: -- changed the cursor for bug 7113142
1557: cursor csr_fetch_type is
1558: select pt.system_person_type
1559: from
1560: per_all_people_f per
1561: ,per_person_type_usages_f ptu
1562: ,per_person_types pt
1563: where per.person_id = p_person_id
1564: and p_date BETWEEN per.effective_start_date and per.effective_end_date