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_LEARNER_ENROLL_REVIEW_SS dependencies on PAY_COST_ALLOCATION_KEYFLEX

Line 486: -- l_costAlocationKeyflexId pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;

482: is
483:
484: l_eventid ota_events.event_id%TYPE;
485: l_activityversionid ota_events.ACTIVITY_VERSION_ID%TYPE;
486: -- l_costAlocationKeyflexId pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
487: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
488: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
489: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;
490: l_assignmentid per_all_assignments.ASSIGNMENT_ID%TYPE;

Line 488: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;

484: l_eventid ota_events.event_id%TYPE;
485: l_activityversionid ota_events.ACTIVITY_VERSION_ID%TYPE;
486: -- l_costAlocationKeyflexId pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
487: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
488: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
489: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;
490: l_assignmentid per_all_assignments.ASSIGNMENT_ID%TYPE;
491: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;
492: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;

Line 752: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;

748: is
749:
750: l_eventid ota_events.event_id%TYPE;
751: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
752: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
753: l_ccselectiontext varchar2(2000);
754: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
755: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
756: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;

Line 2226: l_dynamicSqlString := 'SELECT ' ||from_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX

2222: SELECT COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
2223: FROM HR_ALL_ORGANIZATION_UNITS WHERE organization_id = p_business_group_id_from;
2224:
2225:
2226: l_dynamicSqlString := 'SELECT ' ||from_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2227: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2228: BEGIN
2229: execute immediate l_dynamicSqlString
2230: into l_segment

Line 2261: l_dynamicSqlString := 'SELECT ' || from_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX

2257:
2258: ELSIF from_rec.hr_data_source = 'ASG' THEN
2259:
2260: IF from_rec.HR_COST_SEGMENT is not null THEN
2261: l_dynamicSqlString := 'SELECT ' || from_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2262: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2263: BEGIN
2264: execute immediate l_dynamicSqlString
2265: into l_segment

Line 2299: l_dynamicSqlString := 'SELECT ' ||from_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX

2295: WHERE hr.organization_id = asg.organization_id and
2296: asg.organization_id = p_organization_id and
2297: asg.assignment_id = p_assignment_id ; */
2298:
2299: l_dynamicSqlString := 'SELECT ' ||from_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2300: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2301: BEGIN
2302: execute immediate l_dynamicSqlString
2303: into l_segment

Line 2340: l_dynamicSqlString := 'SELECT ' ||from_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX

2336: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2337: OTA_EVENTS EVT
2338: WHERE hr.organization_id = evt.organization_id and
2339: evt.event_id = p_event_id; */
2340: l_dynamicSqlString := 'SELECT ' ||from_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2341: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2342:
2343: BEGIN
2344: execute immediate l_dynamicSqlString

Line 2461: l_dynamicSqlString := 'SELECT ' ||to_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX

2457: SELECT COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
2458: FROM HR_ALL_ORGANIZATION_UNITS WHERE organization_id = p_business_group_id_to;
2459:
2460:
2461: l_dynamicSqlString := 'SELECT ' ||to_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2462: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2463: BEGIN
2464: execute immediate l_dynamicSqlString
2465: into l_segment

Line 2494: l_dynamicSqlString := 'SELECT ' || to_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX

2490: END IF;
2491:
2492: ELSIF to_rec.hr_data_source = 'ASG' THEN
2493: IF to_rec.HR_COST_SEGMENT is not null THEN
2494: l_dynamicSqlString := 'SELECT ' || to_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2495: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2496: BEGIN
2497: execute immediate l_dynamicSqlString
2498: into l_segment

Line 2532: l_dynamicSqlString := 'SELECT ' ||to_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX

2528: FETCH OFA INTO l_cost_allocation_keyflex_id ;
2529: CLOSE OFA;
2530:
2531:
2532: l_dynamicSqlString := 'SELECT ' ||to_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2533: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2534: BEGIN
2535: execute immediate l_dynamicSqlString
2536: into l_segment

Line 2568: l_dynamicSqlString := 'SELECT ' ||to_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX

2564: FETCH SPO INTO l_cost_allocation_keyflex_id ;
2565: CLOSE SPO;
2566:
2567:
2568: l_dynamicSqlString := 'SELECT ' ||to_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2569: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2570:
2571: BEGIN
2572: execute immediate l_dynamicSqlString