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

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

440: is
441:
442: l_eventid ota_events.event_id%TYPE;
443: l_activityversionid ota_events.ACTIVITY_VERSION_ID%TYPE;
444: -- l_costAlocationKeyflexId pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
445: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
446: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
447: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;
448: l_assignmentid per_all_assignments.ASSIGNMENT_ID%TYPE;

Line 446: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;

442: l_eventid ota_events.event_id%TYPE;
443: l_activityversionid ota_events.ACTIVITY_VERSION_ID%TYPE;
444: -- l_costAlocationKeyflexId pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
445: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
446: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
447: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;
448: l_assignmentid per_all_assignments.ASSIGNMENT_ID%TYPE;
449: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;
450: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;

Line 696: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;

692: is
693:
694: l_eventid ota_events.event_id%TYPE;
695: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
696: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
697: l_ccselectiontext varchar2(200);
698: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
699: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
700: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;

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

2132: SELECT COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
2133: FROM HR_ALL_ORGANIZATION_UNITS WHERE organization_id = p_business_group_id_from;
2134:
2135:
2136: l_dynamicSqlString := 'SELECT ' ||from_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2137: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2138: BEGIN
2139: execute immediate l_dynamicSqlString
2140: into l_segment

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

2167:
2168: ELSIF from_rec.hr_data_source = 'ASG' THEN
2169:
2170: IF from_rec.HR_COST_SEGMENT is not null THEN
2171: l_dynamicSqlString := 'SELECT ' || from_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2172: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2173: BEGIN
2174: execute immediate l_dynamicSqlString
2175: into l_segment

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

2205: WHERE hr.organization_id = asg.organization_id and
2206: asg.organization_id = p_organization_id and
2207: asg.assignment_id = p_assignment_id ; */
2208:
2209: l_dynamicSqlString := 'SELECT ' ||from_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2210: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2211: BEGIN
2212: execute immediate l_dynamicSqlString
2213: into l_segment

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

2246: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2247: OTA_EVENTS EVT
2248: WHERE hr.organization_id = evt.organization_id and
2249: evt.event_id = p_event_id; */
2250: l_dynamicSqlString := 'SELECT ' ||from_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2251: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2252:
2253: BEGIN
2254: execute immediate l_dynamicSqlString

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

2367: SELECT COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
2368: FROM HR_ALL_ORGANIZATION_UNITS WHERE organization_id = p_business_group_id_to;
2369:
2370:
2371: l_dynamicSqlString := 'SELECT ' ||to_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2372: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2373: BEGIN
2374: execute immediate l_dynamicSqlString
2375: into l_segment

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

2400: END IF;
2401:
2402: ELSIF to_rec.hr_data_source = 'ASG' THEN
2403: IF to_rec.HR_COST_SEGMENT is not null THEN
2404: l_dynamicSqlString := 'SELECT ' || to_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2405: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2406: BEGIN
2407: execute immediate l_dynamicSqlString
2408: into l_segment

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

2438: FETCH OFA INTO l_cost_allocation_keyflex_id ;
2439: CLOSE OFA;
2440:
2441:
2442: l_dynamicSqlString := 'SELECT ' ||to_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2443: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2444: BEGIN
2445: execute immediate l_dynamicSqlString
2446: into l_segment

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

2474: FETCH SPO INTO l_cost_allocation_keyflex_id ;
2475: CLOSE SPO;
2476:
2477:
2478: l_dynamicSqlString := 'SELECT ' ||to_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2479: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2480:
2481: BEGIN
2482: execute immediate l_dynamicSqlString