APPS.JAI_CMN_RGM_RECORDING_PKG dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 1291: FROM org_organization_definitions

1287:
1288:
1289: CURSOR c_operating_unit_of_inv_org(cp_organization_id IN NUMBER) IS
1290: SELECT to_number(operating_unit) org_id
1291: FROM org_organization_definitions
1292: WHERE organization_id = cp_organization_id;
1293:
1294: CURSOR c_ap_system_parameters(cp_org_id IN NUMBER) IS
1295: SELECT disc_taken_code_combination_id

Line 1463: and org_organization_definitions respectively.

1459: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_recording_pkg.get_period_name';
1460: /* Bug 5243532. Added by Lakshmi Gopalsami
1461: Removed the cursors c_ou_sob_id and c_io_sob_id
1462: which is referring to hr_operating_units
1463: and org_organization_definitions respectively.
1464: Implemented the same using caching logic.
1465: */
1466: CURSOR c_period_dtl(cp_sob_id IN NUMBER, cp_accounting_date IN DATE) IS
1467: SELECT period_name, start_date, end_date, closing_status

Line 1489: and org_organization_definitions for getting SOB and

1485:
1486: -- Validation of whether the accounting date falls under an open period or not, if not, then we populate the first date of period
1487: /* Bug 5243532. Added by Lakshmi Gopalsami
1488: Removed the logic which is referring to hr_operating_units
1489: and org_organization_definitions for getting SOB and
1490: implemented the same using caching logic.
1491: */
1492: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
1493: (p_org_id => p_organization_id );