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 1540: FROM per_all_assignments_f paf

1536: and btt.language = USERENV('LANG');
1537:
1538: CURSOR csr_get_assignment_info(l_assignment_id NUMBER) IS
1539: SELECT paf.organization_id
1540: FROM per_all_assignments_f paf
1541: WHERE paf.assignment_id = l_assignment_id
1542: and trunc(sysdate) between paf.effective_start_date and paf.effective_end_date -- Bug#8357553
1543: and paf.assignment_type in ('E', 'A', 'C');
1544:

Line 1547: FROM per_all_assignments_f assg,

1543: and paf.assignment_type in ('E', 'A', 'C');
1544:
1545: CURSOR csr_get_cost_center_info(l_assignment_id NUMBER) IS
1546: SELECT pcak.cost_allocation_keyflex_id
1547: FROM per_all_assignments_f assg,
1548: pay_cost_allocations_f pcaf,
1549: pay_cost_allocation_keyflex pcak
1550: WHERE assg.assignment_id = pcaf.assignment_id
1551: AND assg.assignment_id = l_assignment_id

Line 1670: FROM per_all_assignments_f paf

1666: and btt.language = USERENV('LANG');
1667:
1668: CURSOR csr_get_assignment_info(l_assignment_id NUMBER) IS
1669: SELECT paf.organization_id
1670: FROM per_all_assignments_f paf
1671: WHERE paf.assignment_id = l_assignment_id
1672: and trunc(sysdate) between paf.effective_start_date and paf.effective_end_date -- Bug#12327352
1673: and paf.assignment_type in ('E', 'A', 'C');
1674:

Line 1677: FROM per_all_assignments_f assg,

1673: and paf.assignment_type in ('E', 'A', 'C');
1674:
1675: CURSOR csr_get_cost_center_info(l_assignment_id NUMBER) IS
1676: SELECT pcak.cost_allocation_keyflex_id
1677: FROM per_all_assignments_f assg,
1678: pay_cost_allocations_f pcaf,
1679: pay_cost_allocation_keyflex pcak
1680: WHERE assg.assignment_id = pcaf.assignment_id
1681: AND assg.assignment_id = l_assignment_id