APPS.OTA_ENROLL_REVIEW_SS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 905: l_business_group_id_to hr_all_organization_units.organization_id%type;

901: l_cancel_boolean BOOLEAN;
902: l_auto_create_finance VARCHAR2(40);
903: l_price_basis OTA_EVENTS.price_basis%TYPE;
904: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;
905: l_business_group_id_to hr_all_organization_units.organization_id%type;
906: l_assignment_id PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE;
907: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;
908: l_user NUMBER;
909: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;

Line 914: l_sponsor_organization_id hr_all_organization_units.organization_id%type;

910: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
911: fapi_result VARCHAR2(40);
912: fapi_from VARCHAR2(5);
913: fapi_to VARCHAR2(5);
914: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
915: l_event_currency_code ota_events.currency_code%type;
916: l_event_status ota_events.event_status%type;
917: l_cost_allocation_keyflex_id VARCHAR2(1000);
918: l_maximum_internal_attendees NUMBER;

Line 979: HR_ALL_ORGANIZATION_UNITS hao

975: evt.course_start_date,
976: evt.course_end_date,
977: evt.business_group_id bg_id -- Bug#2215026 evt.business_group_id included.
978: FROM OTA_EVENTS_VL evt,
979: HR_ALL_ORGANIZATION_UNITS hao
980: WHERE evt.event_id = l_eventid
981: AND evt.organization_id = hao.organization_id (+); --Bug#2215026 (+) included.
982:
983:

Line 2058: FROM HR_ALL_ORGANIZATION_UNITS

2054: CURSOR ORG
2055: IS
2056: SELECT
2057: COST_ALLOCATION_KEYFLEX_ID
2058: FROM HR_ALL_ORGANIZATION_UNITS
2059: WHERE ORGANIZATION_ID = l_organization_id;
2060:
2061: CURSOR SOB(p_set_of_books_id in number)
2062: IS

Line 2069: FROM HR_ALL_ORGANIZATION_UNITS hr ,

2065: WHERE SET_OF_BOOKS_ID = p_set_of_books_id;
2066:
2067: CURSOR OFA IS
2068: SELECT hr.COST_ALLOCATION_KEYFLEX_ID
2069: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2070: PER_ALL_ASSIGNMENTS_F asg
2071: WHERE hr.organization_id = asg.organization_id and
2072: asg.organization_id = p_organization_id and
2073: asg.assignment_id = p_assignment_id and

Line 2079: FROM HR_ALL_ORGANIZATION_UNITS hr ,

2075: asg.effective_end_date;
2076:
2077: CURSOR SPO IS
2078: SELECT hr.COST_ALLOCATION_KEYFLEX_ID
2079: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2080: OTA_EVENTS EVT
2081: WHERE hr.organization_id = evt.organization_id and
2082: evt.event_id = p_event_id;
2083:

Line 2133: FROM HR_ALL_ORGANIZATION_UNITS WHERE organization_id = p_business_group_id_from;

2129: IF from_rec.HR_COST_SEGMENT is not null THEN
2130: BEGIN
2131:
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 ' ;

Line 2203: FROM HR_ALL_ORGANIZATION_UNITS hr ,

2199: OPEN OFA;
2200: FETCH OFA INTO l_cost_allocation_keyflex_id ;
2201: CLOSE OFA;
2202: /* SELECT hr.COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
2203: FROM HR_ALL_ORGANIZATION_UNITS hr ,
2204: PER_ALL_ASSIGNMENTS_F asg
2205: WHERE hr.organization_id = asg.organization_id and
2206: asg.organization_id = p_organization_id and
2207: asg.assignment_id = p_assignment_id ; */

Line 2246: FROM HR_ALL_ORGANIZATION_UNITS hr ,

2242: FETCH SPO INTO l_cost_allocation_keyflex_id ;
2243: CLOSE SPO;
2244:
2245: /* SELECT hr.COST_ALLOCATION_KEYFLEX_ID INTO l_cost_allocation_keyflex_id
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

Line 2368: FROM HR_ALL_ORGANIZATION_UNITS WHERE organization_id = p_business_group_id_to;

2364: IF to_rec.hr_data_source = 'BGP' THEN
2365: IF to_rec.HR_COST_SEGMENT is not null THEN
2366: BEGIN
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 ' ;