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_BULK_ENROLL_UTIL dependencies on PER_ALL_ASSIGNMENTS_F

Line 383: ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE

379:
380: PROCEDURE Create_Enrollment_And_Finance( p_event_id IN VARCHAR2
381: ,p_extra_information IN VARCHAR2
382: ,p_cost_centers IN VARCHAR2
383: ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE
384: ,p_business_group_id_from IN PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE
385: ,p_organization_id IN PER_ALL_ASSIGNMENTS_F.organization_id%TYPE
386: ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type
387: ,p_delegate_contact_id IN NUMBER

Line 384: ,p_business_group_id_from IN PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE

380: PROCEDURE Create_Enrollment_And_Finance( p_event_id IN VARCHAR2
381: ,p_extra_information IN VARCHAR2
382: ,p_cost_centers IN VARCHAR2
383: ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE
384: ,p_business_group_id_from IN PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE
385: ,p_organization_id IN PER_ALL_ASSIGNMENTS_F.organization_id%TYPE
386: ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type
387: ,p_delegate_contact_id IN NUMBER
388: ,p_booking_id OUT NOCOPY OTA_DELEGATE_BOOKINGS.Booking_id%type

Line 385: ,p_organization_id IN PER_ALL_ASSIGNMENTS_F.organization_id%TYPE

381: ,p_extra_information IN VARCHAR2
382: ,p_cost_centers IN VARCHAR2
383: ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE
384: ,p_business_group_id_from IN PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE
385: ,p_organization_id IN PER_ALL_ASSIGNMENTS_F.organization_id%TYPE
386: ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type
387: ,p_delegate_contact_id IN NUMBER
388: ,p_booking_id OUT NOCOPY OTA_DELEGATE_BOOKINGS.Booking_id%type
389: ,p_message_name OUT NOCOPY varchar2

Line 491: per_all_assignments_f paf

487: paf.organization_id,
488: ppf.email_address
489: FROM
490: per_all_people_f ppf,
491: per_all_assignments_f paf
492: WHERE
493: ppf.person_id = paf.person_id
494: AND trunc(sysdate) BETWEEN ppf.effective_start_date AND ppf.effective_end_date
495: AND trunc(sysdate) BETWEEN paf.effective_start_date AND paf.effective_end_date

Line 507: per_all_assignments_f paf ,

503: paf.organization_id,
504: ppf.email_address
505: FROM
506: per_all_people_f ppf,
507: per_all_assignments_f paf ,
508: per_phones pph
509: WHERE
510: ppf.person_id = paf.person_id
511: AND trunc(sysdate) BETWEEN ppf.effective_start_date AND ppf.effective_end_date

Line 528: per_all_assignments_f paf ,

524: ppf.email_address,
525: pfax.PHONE_NUMBER fax_number
526: FROM
527: per_all_people_f ppf,
528: per_all_assignments_f paf ,
529: per_phones pph,
530: per_phones pfax
531: WHERE
532: ppf.person_id = paf.person_id

Line 1534: FROM per_all_assignments_f paf

1530: and btt.language = USERENV('LANG');
1531:
1532: CURSOR csr_get_assignment_info(l_assignment_id NUMBER) IS
1533: SELECT paf.organization_id
1534: FROM per_all_assignments_f paf
1535: WHERE paf.assignment_id = l_assignment_id;
1536:
1537: CURSOR csr_get_cost_center_info(l_assignment_id NUMBER) IS
1538: SELECT pcak.cost_allocation_keyflex_id

Line 1539: FROM per_all_assignments_f assg,

1535: WHERE paf.assignment_id = l_assignment_id;
1536:
1537: CURSOR csr_get_cost_center_info(l_assignment_id NUMBER) IS
1538: SELECT pcak.cost_allocation_keyflex_id
1539: FROM per_all_assignments_f assg,
1540: pay_cost_allocations_f pcaf,
1541: pay_cost_allocation_keyflex pcak
1542: WHERE assg.assignment_id = pcaf.assignment_id
1543: AND assg.assignment_id = l_assignment_id