DBA Data[Home] [Help]

APPS.OKL_PRB_UPGRADE_PVT dependencies on HR_OPERATING_UNITS

Line 439: (SELECT name from hr_operating_units where organization_id = p_org_id) org_id

435: -- Cursor to get the meaning of the Parameters appropriately
436: CURSOR get_params_def_csr
437: IS
438: SELECT
439: (SELECT name from hr_operating_units where organization_id = p_org_id) org_id
440: ,DECODE(p_criteria_set, 'CONTRACT', 'Contract - Criteria', 'REAMORT', 'Reamort', 'Revision - Criteria' ) criteria_set
441: ,( SELECT DISTINCT legal_entity_name from XLE_LE_OU_LEDGER_V
442: WHERE legal_entity_id = p_le_id
443: AND rownum <= 1 ) le_id