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 HR_ALL_ORGANIZATION_UNITS

Line 1355: l_business_group_id_to hr_all_organization_units.organization_id%type;

1351: l_cancel_boolean BOOLEAN;
1352: l_auto_create_finance VARCHAR2(40);
1353: l_price_basis OTA_EVENTS.price_basis%TYPE;
1354: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;
1355: l_business_group_id_to hr_all_organization_units.organization_id%type;
1356: l_assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE;
1357: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;
1358: l_user NUMBER;
1359: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;

Line 1364: l_sponsor_organization_id hr_all_organization_units.organization_id%type;

1360: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
1361: fapi_result VARCHAR2(40);
1362: fapi_from VARCHAR2(5);
1363: fapi_to VARCHAR2(5);
1364: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
1365: l_event_currency_code ota_events.currency_code%type;
1366: l_event_status ota_events.event_status%type;
1367: l_cost_allocation_keyflex_id VARCHAR2(1000);
1368: l_maximum_internal_attendees NUMBER;

Line 1429: HR_ALL_ORGANIZATION_UNITS hao

1425: evt.course_start_date,
1426: evt.course_end_date,
1427: evt.business_group_id bg_id -- Bug#2215026 evt.business_group_id included.
1428: FROM OTA_EVENTS_VL evt,
1429: HR_ALL_ORGANIZATION_UNITS hao
1430: WHERE evt.event_id = l_eventid
1431: AND evt.organization_id = hao.organization_id (+); --Bug#2215026 (+) included.
1432:
1433:

Line 2537: FROM HR_ALL_ORGANIZATION_UNITS

2533: CURSOR ORG
2534: IS
2535: SELECT
2536: COST_ALLOCATION_KEYFLEX_ID
2537: FROM HR_ALL_ORGANIZATION_UNITS
2538: WHERE ORGANIZATION_ID = l_organization_id;
2539:
2540: CURSOR SOB(p_set_of_books_id in number)
2541: IS

Line 2548: FROM HR_ALL_ORGANIZATION_UNITS hr ,

2544: WHERE SET_OF_BOOKS_ID = p_set_of_books_id;
2545:
2546: CURSOR OFA IS
2547: SELECT hr.COST_ALLOCATION_KEYFLEX_ID
2548: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2549: PER_ALL_ASSIGNMENTS_F asg
2550: WHERE hr.organization_id = asg.organization_id and
2551: asg.organization_id = p_organization_id and
2552: asg.assignment_id = p_assignment_id and

Line 2558: FROM HR_ALL_ORGANIZATION_UNITS hr ,

2554: asg.effective_end_date;
2555:
2556: CURSOR SPO IS
2557: SELECT hr.COST_ALLOCATION_KEYFLEX_ID
2558: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2559: OTA_EVENTS EVT
2560: WHERE hr.organization_id = evt.organization_id and
2561: evt.event_id = p_event_id;
2562:

Line 2612: FROM HR_ALL_ORGANIZATION_UNITS WHERE organization_id = p_business_group_id_from;

2608: IF from_rec.HR_COST_SEGMENT is not null THEN
2609: BEGIN
2610:
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 ' ;

Line 2682: FROM HR_ALL_ORGANIZATION_UNITS hr ,

2678: OPEN OFA;
2679: FETCH OFA INTO l_cost_allocation_keyflex_id ;
2680: CLOSE OFA;
2681: /* SELECT hr.COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
2682: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2683: PER_ALL_ASSIGNMENTS_F asg
2684: WHERE hr.organization_id = asg.organization_id and
2685: asg.organization_id = p_organization_id and
2686: asg.assignment_id = p_assignment_id ; */

Line 2725: FROM HR_ALL_ORGANIZATION_UNITS hr ,

2721: FETCH SPO INTO l_cost_allocation_keyflex_id ;
2722: CLOSE SPO;
2723:
2724: /* SELECT hr.COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
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

Line 2847: FROM HR_ALL_ORGANIZATION_UNITS WHERE organization_id = p_business_group_id_to;

2843: IF to_rec.hr_data_source = 'BGP' THEN
2844: IF to_rec.HR_COST_SEGMENT is not null THEN
2845: BEGIN
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 ' ;

Line 2920: FROM HR_ALL_ORGANIZATION_UNITS hr ,

2916: OPEN OFA;
2917: FETCH OFA INTO l_cost_allocation_keyflex_id ;
2918: CLOSE OFA;
2919: /* SELECT hr.COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
2920: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2921: PER_ALL_ASSIGNMENTS_F asg
2922: WHERE hr.organization_id = asg.organization_id and
2923: asg.organization_id = p_organization_id and
2924: asg.assignment_id = p_assignment_id ; */

Line 2962: FROM HR_ALL_ORGANIZATION_UNITS hr ,

2958: FETCH SPO INTO l_cost_allocation_keyflex_id ;
2959: CLOSE SPO;
2960:
2961: /* SELECT hr.COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
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