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 HR_ALL_ORGANIZATION_UNITS

Line 1100: l_business_group_id_to hr_all_organization_units.organization_id%type;

1096: l_cancel_boolean BOOLEAN;
1097: l_auto_create_finance VARCHAR2(40);
1098: l_price_basis OTA_EVENTS.price_basis%TYPE;
1099: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;
1100: l_business_group_id_to hr_all_organization_units.organization_id%type;
1101: l_assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE;
1102: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;
1103: l_user NUMBER;
1104: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;

Line 1109: l_sponsor_organization_id hr_all_organization_units.organization_id%type;

1105: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
1106: fapi_result VARCHAR2(40);
1107: fapi_from VARCHAR2(5);
1108: fapi_to VARCHAR2(5);
1109: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
1110: l_event_currency_code ota_events.currency_code%type;
1111: l_event_status ota_events.event_status%type;
1112: l_cost_allocation_keyflex_id VARCHAR2(1000);
1113: l_maximum_internal_attendees NUMBER;

Line 1175: HR_ALL_ORGANIZATION_UNITS hao

1171: evt.course_end_date,
1172: evt.business_group_id bg_id -- Bug#2215026 evt.business_group_id included.
1173: FROM OTA_EVENTS evt,
1174: OTA_EVENTS_TL evttl,
1175: HR_ALL_ORGANIZATION_UNITS hao
1176: WHERE evt.event_id = l_event_id
1177: AND evt.event_id = evttl.event_id
1178: AND evt.organization_id = hao.organization_id (+) --Bug#2215026 (+) included.
1179: AND evttl.language(+) = userenv('LANG');

Line 2127: FROM HR_ALL_ORGANIZATION_UNITS

2123: CURSOR ORG
2124: IS
2125: SELECT
2126: COST_ALLOCATION_KEYFLEX_ID
2127: FROM HR_ALL_ORGANIZATION_UNITS
2128: WHERE ORGANIZATION_ID = l_organization_id;
2129:
2130: CURSOR SOB(p_set_of_books_id in number)
2131: IS

Line 2138: FROM HR_ALL_ORGANIZATION_UNITS hr ,

2134: WHERE SET_OF_BOOKS_ID = p_set_of_books_id;
2135:
2136: CURSOR OFA IS
2137: SELECT hr.COST_ALLOCATION_KEYFLEX_ID
2138: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2139: PER_ALL_ASSIGNMENTS_F asg
2140: WHERE hr.organization_id = asg.organization_id and
2141: asg.organization_id = p_organization_id and
2142: asg.assignment_id = p_assignment_id and

Line 2148: FROM HR_ALL_ORGANIZATION_UNITS hr ,

2144: asg.effective_end_date;
2145:
2146: CURSOR SPO IS
2147: SELECT hr.COST_ALLOCATION_KEYFLEX_ID
2148: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2149: OTA_EVENTS EVT
2150: WHERE hr.organization_id = evt.organization_id and
2151: evt.event_id = p_event_id;
2152:

Line 2202: FROM HR_ALL_ORGANIZATION_UNITS WHERE organization_id = p_business_group_id_from;

2198: IF from_rec.HR_COST_SEGMENT is not null THEN
2199: BEGIN
2200:
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 ' ;

Line 2272: FROM HR_ALL_ORGANIZATION_UNITS hr ,

2268: OPEN OFA;
2269: FETCH OFA INTO l_cost_allocation_keyflex_id ;
2270: CLOSE OFA;
2271: /* SELECT hr.COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
2272: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2273: PER_ALL_ASSIGNMENTS_F asg
2274: WHERE hr.organization_id = asg.organization_id and
2275: asg.organization_id = p_organization_id and
2276: asg.assignment_id = p_assignment_id ; */

Line 2315: FROM HR_ALL_ORGANIZATION_UNITS hr ,

2311: FETCH SPO INTO l_cost_allocation_keyflex_id ;
2312: CLOSE SPO;
2313:
2314: /* SELECT hr.COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
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

Line 2437: FROM HR_ALL_ORGANIZATION_UNITS WHERE organization_id = p_business_group_id_to;

2433: IF to_rec.hr_data_source = 'BGP' THEN
2434: IF to_rec.HR_COST_SEGMENT is not null THEN
2435: BEGIN
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 ' ;

Line 2510: FROM HR_ALL_ORGANIZATION_UNITS hr ,

2506: OPEN OFA;
2507: FETCH OFA INTO l_cost_allocation_keyflex_id ;
2508: CLOSE OFA;
2509: /* SELECT hr.COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
2510: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2511: PER_ALL_ASSIGNMENTS_F asg
2512: WHERE hr.organization_id = asg.organization_id and
2513: asg.organization_id = p_organization_id and
2514: asg.assignment_id = p_assignment_id ; */

Line 2552: FROM HR_ALL_ORGANIZATION_UNITS hr ,

2548: FETCH SPO INTO l_cost_allocation_keyflex_id ;
2549: CLOSE SPO;
2550:
2551: /* SELECT hr.COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
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