APPS.PER_APR_BUS dependencies on PER_ALL_PEOPLE_F

Line 369: , per_all_people_f per

365: cursor csr_fetch_type is
366: select ppt.system_person_type
367: from per_person_types ppt
368: , per_person_type_usages_f ptu
369: , per_all_people_f per
370: where per.person_id = p_rec.appraisee_person_id
371: and TRUNC(SYSDATE) BETWEEN per.effective_start_date AND per.effective_end_date
372: AND ptu.person_id = per.person_id
373: and TRUNC(SYSDATE) BETWEEN ptu.effective_start_date AND ptu.effective_end_date

Line 897: from per_all_people_f

893:
894: Cursor csr_person_bg
895: is
896: select business_group_id
897: from per_all_people_f
898: where person_id = p_person_id;
899:
900: -- bug 1980440 fix
901: -- WE NEED to use different cursors as Appraiser can be changed to

Line 908: from per_all_people_f

904:
905: Cursor csr_cbg_person_bg
906: is
907: select business_group_id
908: from per_all_people_f
909: where person_id = p_person_id;
910:
911: -- Cursor to check if person is valid
912: -- as of effective date

Line 917: from per_all_people_f

913:
914: Cursor csr_person_valid_date
915: is
916: select 'Y'
917: from per_all_people_f
918: where person_id = p_person_id
919: and p_effective_date between
920: effective_start_date and nvl(effective_end_date,hr_api.g_eot);
921:

Line 931: from per_all_people_f

927:
928: Cursor csr_cbg_person_valid_date
929: is
930: select 'Y'
931: from per_all_people_f
932: where person_id = p_person_id
933: and p_effective_date between
934: effective_start_date and nvl(effective_end_date,hr_api.g_eot);
935:

Line 1072: from per_all_people_f ppf, wf_roles usr

1068:
1069: Cursor csr_person_valid_date
1070: is
1071: select 'Y'
1072: from per_all_people_f ppf, wf_roles usr
1073: where person_id = p_main_appraiser_id
1074: and business_group_id = p_business_group_id
1075: and p_effective_date between
1076: effective_start_date and nvl(effective_end_date,hr_api.g_eot)

Line 1087: from per_all_people_f ppf, wf_roles usr

1083:
1084: Cursor csr_cbg_person_valid_date
1085: is
1086: select 'Y'
1087: from per_all_people_f ppf, wf_roles usr
1088: where person_id = p_main_appraiser_id
1089: and p_effective_date between
1090: effective_start_date and nvl(effective_end_date,hr_api.g_eot)
1091: AND ppf.person_id = usr.orig_system_id

Line 1451: from per_all_people_f per

1447: l_proc varchar2(72):=g_package||'chk_group_initiator_id';
1448:
1449: cursor csr_chk_grp_per_sta_date is
1450: select distinct(min(effective_start_date)), business_group_id
1451: from per_all_people_f per
1452: where per.person_id = p_group_initiator_id
1453: group by business_group_id;
1454:
1455: l_asn_grp_pers_sta_date per_people_f.start_date%TYPE;

Line 1676: ,p_person_id in per_all_people_f.person_id%TYPE

1672: -- Function to return whether or not the date is valid
1673:
1674: function validate_date
1675: (p_date in date
1676: ,p_person_id in per_all_people_f.person_id%TYPE
1677: ,p_term_emp IN VARCHAR2
1678: ,p_term_cwk IN VARCHAR2
1679: ,p_future_term IN VARCHAR2
1680: ) RETURN boolean IS

Line 1694: per_all_people_f per

1690: -- changed the cursor for bug 7113142
1691: cursor csr_no_term is
1692: select pt.system_person_type
1693: from
1694: per_all_people_f per
1695: ,per_person_type_usages_f ptu
1696: ,per_person_types pt
1697: where per.person_id = p_person_id
1698: and p_date BETWEEN per.effective_start_date and per.effective_end_date