APPS.OTA_EL_ENROLL_SS dependencies on PER_ALL_PEOPLE_F

Line 45: ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type

41: ,p_business_group_id_from IN PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE
42: ,p_business_group_name IN PER_BUSINESS_GROUPS.name%TYPE
43: ,p_organization_id IN PER_ALL_ASSIGNMENTS_F.organization_id%TYPE
44: ,p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE
45: ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type
46: ,p_booking_id out nocopy OTA_DELEGATE_BOOKINGS.Booking_id%type
47: ,p_message_name out nocopy varchar2
48: ,p_item_key IN WF_ITEMS.ITEM_TYPE%TYPE
49: ,p_tdb_information_category in varchar2

Line 1103: FROM per_all_people_f ppf,

1099: assg.organization_id,
1100: pcak.cost_allocation_keyflex_id,
1101: pcak.concatenated_segments,
1102: pcaf.proportion
1103: FROM per_all_people_f ppf,
1104: per_all_assignments_f assg,
1105: pay_cost_allocations_f pcaf,
1106: pay_cost_allocation_keyflex pcak
1107: WHERE ppf.person_id = p_person_id

Line 1121: CURSOR get_assignment(p_delegate_id per_all_people_f.person_id%TYPE) IS

1117: AND sysdate between nvl(ppf.effective_start_date,sysdate)
1118: and nvl(ppf.effective_end_date,sysdate+1);
1119:
1120:
1121: CURSOR get_assignment(p_delegate_id per_all_people_f.person_id%TYPE) IS
1122: SELECT assg.assignment_id,
1123: assg.business_group_id,
1124: assg.organization_id
1125: FROM per_all_people_f ppf,

Line 1125: FROM per_all_people_f ppf,

1121: CURSOR get_assignment(p_delegate_id per_all_people_f.person_id%TYPE) IS
1122: SELECT assg.assignment_id,
1123: assg.business_group_id,
1124: assg.organization_id
1125: FROM per_all_people_f ppf,
1126: per_all_assignments_f assg
1127: WHERE ppf.person_id = p_delegate_id
1128: AND ppf.person_id = assg.person_id
1129: AND sysdate between nvl(assg.effective_start_date,sysdate)

Line 1213: l_creator_person_id per_all_people_f.person_id%type;

1209:
1210: l_user_name varchar2(80);
1211: l_current_username varchar2(80):= fnd_profile.value('USERNAME');
1212: l_current_user_Id number := fnd_profile.value('USER_ID');
1213: l_creator_person_id per_all_people_f.person_id%type;
1214:
1215: CURSOR C_USER IS
1216: SELECT
1217: EMPLOYEE_ID

Line 1288: FUNCTION Get_Person_To_Enroll_Details (p_person_id per_all_people_f.PERSON_ID%TYPE)

1284: --
1285: -- {End Of Comments}
1286: -- ----------------------------------------------------------------------------
1287:
1288: FUNCTION Get_Person_To_Enroll_Details (p_person_id per_all_people_f.PERSON_ID%TYPE)
1289: RETURN csr_person_to_enroll_details%ROWTYPE
1290:
1291: IS
1292: --

Line 1359: PROCEDURE Validate_enrollment(p_person_id per_all_people_f.PERSON_ID%TYPE,

1355: --
1356: -- {End Of Comments}
1357: -- ----------------------------------------------------------------------------
1358:
1359: PROCEDURE Validate_enrollment(p_person_id per_all_people_f.PERSON_ID%TYPE,
1360: p_event_id IN VARCHAR2,
1361: p_double_book out nocopy VARCHAR2 )
1362:
1363: IS