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

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

624: is
625:
626: l_eventid ota_events.event_id%TYPE;
627: l_activityversionid ota_events.ACTIVITY_VERSION_ID%TYPE;
628: -- l_costAlocationKeyflexId pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
629: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
630: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
631: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;
632: l_assignmentid per_all_assignments.ASSIGNMENT_ID%TYPE;

Line 630: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;

626: l_eventid ota_events.event_id%TYPE;
627: l_activityversionid ota_events.ACTIVITY_VERSION_ID%TYPE;
628: -- l_costAlocationKeyflexId pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
629: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
630: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
631: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;
632: l_assignmentid per_all_assignments.ASSIGNMENT_ID%TYPE;
633: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;
634: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;

Line 892: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;

888: is
889:
890: l_eventid ota_events.event_id%TYPE;
891: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
892: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
893: l_ccselectiontext varchar2(200);
894: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
895: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
896: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;

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

2201: SELECT COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
2202: FROM HR_ALL_ORGANIZATION_UNITS WHERE organization_id = p_business_group_id_from;
2203:
2204:
2205: l_dynamicSqlString := 'SELECT ' ||from_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2206: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2207: BEGIN
2208: execute immediate l_dynamicSqlString
2209: into l_segment

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

2236:
2237: ELSIF from_rec.hr_data_source = 'ASG' THEN
2238:
2239: IF from_rec.HR_COST_SEGMENT is not null THEN
2240: l_dynamicSqlString := 'SELECT ' || from_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2241: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2242: BEGIN
2243: execute immediate l_dynamicSqlString
2244: into l_segment

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

2274: WHERE hr.organization_id = asg.organization_id and
2275: asg.organization_id = p_organization_id and
2276: asg.assignment_id = p_assignment_id ; */
2277:
2278: l_dynamicSqlString := 'SELECT ' ||from_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2279: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2280: BEGIN
2281: execute immediate l_dynamicSqlString
2282: into l_segment

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

2315: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2316: OTA_EVENTS EVT
2317: WHERE hr.organization_id = evt.organization_id and
2318: evt.event_id = p_event_id; */
2319: l_dynamicSqlString := 'SELECT ' ||from_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2320: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2321:
2322: BEGIN
2323: execute immediate l_dynamicSqlString

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

2436: SELECT COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
2437: FROM HR_ALL_ORGANIZATION_UNITS WHERE organization_id = p_business_group_id_to;
2438:
2439:
2440: l_dynamicSqlString := 'SELECT ' ||to_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2441: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2442: BEGIN
2443: execute immediate l_dynamicSqlString
2444: into l_segment

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

2469: END IF;
2470:
2471: ELSIF to_rec.hr_data_source = 'ASG' THEN
2472: IF to_rec.HR_COST_SEGMENT is not null THEN
2473: l_dynamicSqlString := 'SELECT ' || to_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2474: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2475: BEGIN
2476: execute immediate l_dynamicSqlString
2477: into l_segment

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

2512: WHERE hr.organization_id = asg.organization_id and
2513: asg.organization_id = p_organization_id and
2514: asg.assignment_id = p_assignment_id ; */
2515:
2516: l_dynamicSqlString := 'SELECT ' ||to_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2517: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2518: BEGIN
2519: execute immediate l_dynamicSqlString
2520: into l_segment

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

2552: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2553: OTA_EVENTS EVT
2554: WHERE hr.organization_id = evt.organization_id and
2555: evt.event_id = p_event_id; */
2556: l_dynamicSqlString := 'SELECT ' ||to_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2557: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2558:
2559: BEGIN
2560: execute immediate l_dynamicSqlString