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_EL_ENROLL_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 1104: per_all_assignments_f assg,

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
1108: AND ppf.person_id = assg.person_id

Line 1126: per_all_assignments_f assg

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

Line 1570: from per_all_assignments_f

1566: where event_id = p_event_id;
1567:
1568: CURSOR C_GET_ORG_ID is
1569: SELECT organization_id
1570: from per_all_assignments_f
1571: where person_id = p_delegate_id and
1572: trunc(sysdate) between effective_start_date and
1573: effective_end_date;
1574:

Line 1578: l_per_organization_id PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID%TYPE;

1574:
1575:
1576: l_secure_flag varchar2(1);
1577: l_evt_organization_id OTA_EVENTS.ORGANIZATION_ID%TYPE;
1578: l_per_organization_id PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID%TYPE;
1579: l_return_value varchar2(2000);
1580:
1581: BEGIN
1582:

Line 1657: FROM per_all_assignments_f paf

1653: ,p_position_id OTA_EVENT_ASSOCIATIONS.position_id%TYPE
1654: ,p_course_start_date
1655: otv_scheduled_events.course_start_date%type) IS
1656: SELECT paf.assignment_id
1657: FROM per_all_assignments_f paf
1658: WHERE paf.person_id = p_delegate_id
1659: AND NVL(p_course_start_date,trunc(sysdate)) BETWEEN
1660: paf.effective_start_date AND paf.effective_end_date
1661: AND NVL(p_organization_id, -1) = DECODE(p_organization_id, null, -1,