DBA Data[Home] [Help]

APPS.JTF_RS_RESOURCE_PVT dependencies on PER_ALL_PEOPLE_F

Line 1090: FROM per_all_people_f ppf

1086: AND trunc(sysdate) between effective_start_date and effective_end_date;
1087:
1088: CURSOR c_party_id(p_person_id IN NUMBER) IS
1089: SELECT ppf.party_id
1090: FROM per_all_people_f ppf
1091: WHERE ppf.person_id = p_person_id
1092: AND trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date;
1093:
1094: l_value VARCHAR2(100);