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.CSTPPIPV dependencies on HR_ORGANIZATION_INFORMATION

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

1168: l_server_le_offset := 0;
1169:
1170: l_stmt_num := 42;
1171:
1172: /* select legal entity from HR_ORGANIZATION_INFORMATION instead of cst_organization_definitions
1173: for performance improvement */
1174:
1175: SELECT org_information2
1176: INTO l_legal_entity

Line 1177: FROM HR_ORGANIZATION_INFORMATION

1173: for performance improvement */
1174:
1175: SELECT org_information2
1176: INTO l_legal_entity
1177: FROM HR_ORGANIZATION_INFORMATION
1178: where ORG_INFORMATION_CONTEXT = 'Accounting Information'
1179: and organization_id = p_organization_id;
1180:
1181: l_server_day_time := INV_LE_TIMEZONE_PUB.GET_SERVER_DAY_TIME_FOR_LE(

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

2210: --
2211: -- -- Get legal entity for timezone conversion.
2212: -- l_stmt_num := 30;
2213: --
2214: /* select legal entity from HR_ORGANIZATION_INFORMATION instead of cst_organization_definitions
2215: for performance improvement */
2216:
2217: -- SELECT org_information2
2218: -- INTO l_legal_entity

Line 2219: -- FROM HR_ORGANIZATION_INFORMATION

2215: for performance improvement */
2216:
2217: -- SELECT org_information2
2218: -- INTO l_legal_entity
2219: -- FROM HR_ORGANIZATION_INFORMATION
2220: -- where ORG_INFORMATION_CONTEXT = 'Accounting Information'
2221: -- and organization_id = p_organization_id;
2222:
2223: -- Need to convert start and end dates to server time.

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

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

Line 2307: FROM HR_ORGANIZATION_INFORMATION

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