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

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

878: is
879:
880: l_eventid ota_events.event_id%TYPE;
881: l_activityversionid ota_events.ACTIVITY_VERSION_ID%TYPE;
882: -- l_costAlocationKeyflexId pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
883: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
884: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
885: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;
886: l_assignmentid per_all_assignments.ASSIGNMENT_ID%TYPE;

Line 884: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;

880: l_eventid ota_events.event_id%TYPE;
881: l_activityversionid ota_events.ACTIVITY_VERSION_ID%TYPE;
882: -- l_costAlocationKeyflexId pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
883: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
884: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
885: l_businessgroupid ota_delegate_bookings.BUSINESS_GROUP_ID%TYPE;
886: l_assignmentid per_all_assignments.ASSIGNMENT_ID%TYPE;
887: l_organizationid ota_delegate_bookings.ORGANIZATION_ID%TYPE;
888: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;

Line 1146: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;

1142: is
1143:
1144: l_eventid ota_events.event_id%TYPE;
1145: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
1146: l_keyflexid pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
1147: l_ccselectiontext varchar2(200);
1148: l_tdb_information_category ota_delegate_bookings.TDB_INFORMATION_CATEGORY%TYPE;
1149: l_tdb_information1 ota_delegate_bookings.TDB_INFORMATION1%TYPE;
1150: l_tdb_information2 ota_delegate_bookings.TDB_INFORMATION2%TYPE;

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

2611: SELECT COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
2612: FROM HR_ALL_ORGANIZATION_UNITS WHERE organization_id = p_business_group_id_from;
2613:
2614:
2615: l_dynamicSqlString := 'SELECT ' ||from_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2616: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2617: BEGIN
2618: execute immediate l_dynamicSqlString
2619: into l_segment

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

2646:
2647: ELSIF from_rec.hr_data_source = 'ASG' THEN
2648:
2649: IF from_rec.HR_COST_SEGMENT is not null THEN
2650: l_dynamicSqlString := 'SELECT ' || from_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2651: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2652: BEGIN
2653: execute immediate l_dynamicSqlString
2654: into l_segment

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

2684: WHERE hr.organization_id = asg.organization_id and
2685: asg.organization_id = p_organization_id and
2686: asg.assignment_id = p_assignment_id ; */
2687:
2688: l_dynamicSqlString := 'SELECT ' ||from_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2689: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2690: BEGIN
2691: execute immediate l_dynamicSqlString
2692: into l_segment

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

2725: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2726: OTA_EVENTS EVT
2727: WHERE hr.organization_id = evt.organization_id and
2728: evt.event_id = p_event_id; */
2729: l_dynamicSqlString := 'SELECT ' ||from_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2730: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2731:
2732: BEGIN
2733: execute immediate l_dynamicSqlString

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

2846: SELECT COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
2847: FROM HR_ALL_ORGANIZATION_UNITS WHERE organization_id = p_business_group_id_to;
2848:
2849:
2850: l_dynamicSqlString := 'SELECT ' ||to_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2851: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2852: BEGIN
2853: execute immediate l_dynamicSqlString
2854: into l_segment

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

2879: END IF;
2880:
2881: ELSIF to_rec.hr_data_source = 'ASG' THEN
2882: IF to_rec.HR_COST_SEGMENT is not null THEN
2883: l_dynamicSqlString := 'SELECT ' || to_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2884: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2885: BEGIN
2886: execute immediate l_dynamicSqlString
2887: into l_segment

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

2922: WHERE hr.organization_id = asg.organization_id and
2923: asg.organization_id = p_organization_id and
2924: asg.assignment_id = p_assignment_id ; */
2925:
2926: l_dynamicSqlString := 'SELECT ' ||to_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2927: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2928: BEGIN
2929: execute immediate l_dynamicSqlString
2930: into l_segment

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

2962: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2963: OTA_EVENTS EVT
2964: WHERE hr.organization_id = evt.organization_id and
2965: evt.event_id = p_event_id; */
2966: l_dynamicSqlString := 'SELECT ' ||to_rec.HR_COST_SEGMENT ||' FROM PAY_COST_ALLOCATION_KEYFLEX
2967: WHERE COST_ALLOCATION_KEYFLEX_ID = :txn ' ;
2968:
2969: BEGIN
2970: execute immediate l_dynamicSqlString