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_ASSIGNMENTS_F

Line 40: ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE

36: PROCEDURE ProcessSaveEnrollment( p_event_id IN VARCHAR2
37: ,p_extra_information IN VARCHAR2
38: ,p_mode IN VARCHAR2
39: ,p_cost_centers IN VARCHAR2
40: ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_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

Line 41: ,p_business_group_id_from IN PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE

37: ,p_extra_information IN VARCHAR2
38: ,p_mode IN VARCHAR2
39: ,p_cost_centers IN VARCHAR2
40: ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_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

Line 43: ,p_organization_id IN PER_ALL_ASSIGNMENTS_F.organization_id%TYPE

39: ,p_cost_centers IN VARCHAR2
40: ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_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

Line 1097: per_all_assignments_f assg,

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
1101: AND per.person_id = assg.person_id

Line 1119: per_all_assignments_f assg

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)
1123: and nvl(assg.effective_end_date,sysdate+1)

Line 1559: from per_all_assignments_f

1555: where event_id = p_event_id;
1556:
1557: CURSOR C_GET_ORG_ID is
1558: SELECT organization_id
1559: from per_all_assignments_f
1560: where person_id = p_delegate_id and
1561: trunc(sysdate) between effective_start_date and
1562: effective_end_date;
1563:

Line 1567: l_per_organization_id PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID%TYPE;

1563:
1564:
1565: l_secure_flag varchar2(1);
1566: l_evt_organization_id OTA_EVENTS.ORGANIZATION_ID%TYPE;
1567: l_per_organization_id PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID%TYPE;
1568: l_return_value varchar2(2000);
1569:
1570: BEGIN
1571:

Line 1646: FROM per_all_assignments_f a

1642: ,p_position_id OTA_EVENT_ASSOCIATIONS.position_id%TYPE
1643: ,p_course_start_date
1644: otv_scheduled_events.course_start_date%type) IS
1645: SELECT a.assignment_id
1646: FROM per_all_assignments_f a
1647: WHERE a.person_id = p_delegate_id
1648: AND NVL(p_course_start_date,trunc(sysdate)) BETWEEN
1649: a.effective_start_date AND a.effective_end_date
1650: AND NVL(p_organization_id, -1) = DECODE(p_organization_id, null, -1,