eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_ENROLL_IN_TRAINING_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 1096: FROM per_all_people_f per,

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

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

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

Line 1118: FROM per_all_people_f per,

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

Line 1206: l_creator_person_id per_all_people_f.person_id%type;

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

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

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

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

Line 1662: per_all_people_f per, ota_events evt,

1658:
1659: Cursor c_delegate_active is
1660: select '1'
1661: from per_person_types ppt ,
1662: per_all_people_f per, ota_events evt,
1663: per_person_type_usages_f ptu
1664: where per.business_group_id = ppt.business_group_id
1665: and ppt.system_person_type in ('EMP','CWK','OTHER')
1666: and per.person_id=nvl(p_delegate_id,per.person_id)