APPS.OTA_TRNG_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 1097: FROM per_all_people_f per,

1093: assg.organization_id,
1094: pcak.cost_allocation_keyflex_id,
1095: pcak.concatenated_segments,
1096: pcaf.proportion
1097: FROM per_all_people_f per,
1098: per_all_assignments_f assg,
1099: pay_cost_allocations_f pcaf,
1100: pay_cost_allocation_keyflex pcak
1101: WHERE per.person_id = p_person_id

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

1111: AND sysdate between nvl(per.effective_start_date,sysdate)
1112: and nvl(per.effective_end_date,sysdate+1);
1113:
1114:
1115: CURSOR get_assignment(p_delegate_id per_all_people_f.person_id%TYPE) IS
1116: SELECT assg.assignment_id,
1117: assg.business_group_id,
1118: assg.organization_id
1119: FROM per_all_people_f per,

Line 1119: FROM per_all_people_f per,

1115: CURSOR get_assignment(p_delegate_id per_all_people_f.person_id%TYPE) IS
1116: SELECT assg.assignment_id,
1117: assg.business_group_id,
1118: assg.organization_id
1119: FROM per_all_people_f per,
1120: per_all_assignments_f assg
1121: WHERE per.person_id = p_delegate_id
1122: AND per.person_id = assg.person_id
1123: AND sysdate between nvl(assg.effective_start_date,sysdate)

Line 1207: l_creator_person_id per_all_people_f.person_id%type;

1203:
1204: l_user_name varchar2(80);
1205: l_current_username varchar2(80):= fnd_profile.value('USERNAME');
1206: l_current_user_Id number := fnd_profile.value('USER_ID');
1207: l_creator_person_id per_all_people_f.person_id%type;
1208:
1209: CURSOR C_USER IS
1210: SELECT
1211: EMPLOYEE_ID

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

1278: --
1279: -- {End Of Comments}
1280: -- ----------------------------------------------------------------------------
1281:
1282: FUNCTION Get_Person_To_Enroll_Details (p_person_id per_all_people_f.PERSON_ID%TYPE)
1283: RETURN csr_person_to_enroll_details%ROWTYPE
1284:
1285: IS
1286: --

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

1344: --
1345: -- {End Of Comments}
1346: -- ----------------------------------------------------------------------------
1347:
1348: PROCEDURE Validate_enrollment(p_person_id per_all_people_f.PERSON_ID%TYPE,
1349: p_event_id IN VARCHAR2,
1350: p_double_book out nocopy VARCHAR2 )
1351:
1352: IS