DBA Data[Home] [Help]

APPS.CSTPPIPV dependencies on HR_ORGANIZATION_INFORMATION

Line 1218: /* select legal entity from HR_ORGANIZATION_INFORMATION instead of cst_organization_definitions

1214: l_server_le_offset := 0;
1215:
1216: l_stmt_num := 42;
1217:
1218: /* select legal entity from HR_ORGANIZATION_INFORMATION instead of cst_organization_definitions
1219: for performance improvement */
1220:
1221: SELECT org_information2
1222: INTO l_legal_entity

Line 1223: FROM HR_ORGANIZATION_INFORMATION

1219: for performance improvement */
1220:
1221: SELECT org_information2
1222: INTO l_legal_entity
1223: FROM HR_ORGANIZATION_INFORMATION
1224: where ORG_INFORMATION_CONTEXT = 'Accounting Information'
1225: and organization_id = p_organization_id;
1226:
1227: l_server_day_time := INV_LE_TIMEZONE_PUB.GET_SERVER_DAY_TIME_FOR_LE(

Line 2300: /* select legal entity from HR_ORGANIZATION_INFORMATION instead of cst_organization_definitions

2296:
2297: -- Get legal entity for timezone conversion.
2298: l_stmt_num := 30;
2299:
2300: /* select legal entity from HR_ORGANIZATION_INFORMATION instead of cst_organization_definitions
2301: for performance improvement */
2302:
2303: SELECT org_information2
2304: INTO l_legal_entity

Line 2305: FROM HR_ORGANIZATION_INFORMATION

2301: for performance improvement */
2302:
2303: SELECT org_information2
2304: INTO l_legal_entity
2305: FROM HR_ORGANIZATION_INFORMATION
2306: where ORG_INFORMATION_CONTEXT = 'Accounting Information'
2307: and organization_id = p_organization_id;
2308:
2309: -- Need to convert start and end dates to server time.

Line 2389: /* select legal entity from HR_ORGANIZATION_INFORMATION instead of cst_organization_definitions

2385:
2386: -- Get legal entity for timezone conversion.
2387: l_stmt_num := 15;
2388:
2389: /* select legal entity from HR_ORGANIZATION_INFORMATION instead of cst_organization_definitions
2390: for performance improvement */
2391:
2392: SELECT org_information2
2393: INTO l_legal_entity

Line 2394: FROM HR_ORGANIZATION_INFORMATION

2390: for performance improvement */
2391:
2392: SELECT org_information2
2393: INTO l_legal_entity
2394: FROM HR_ORGANIZATION_INFORMATION
2395: where ORG_INFORMATION_CONTEXT = 'Accounting Information'
2396: and organization_id = p_organization_id;
2397:
2398: -- Need to convert start and end dates to server time.