APPS.JAI_CMN_RGM_RECORDING_PKG dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 1736: FROM org_organization_definitions

1732:
1733:
1734: CURSOR c_operating_unit_of_inv_org(cp_organization_id IN NUMBER) IS
1735: SELECT to_number(operating_unit) org_id
1736: FROM org_organization_definitions
1737: WHERE organization_id = cp_organization_id;
1738:
1739: CURSOR c_ap_system_parameters(cp_org_id IN NUMBER) IS
1740: SELECT disc_taken_code_combination_id

Line 1913: and org_organization_definitions respectively.

1909: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_recording_pkg.get_period_name';
1910: /* Bug 5243532. Added by Lakshmi Gopalsami
1911: Removed the cursors c_ou_sob_id and c_io_sob_id
1912: which is referring to hr_operating_units
1913: and org_organization_definitions respectively.
1914: Implemented the same using caching logic.
1915: */
1916: CURSOR c_period_dtl(cp_sob_id IN NUMBER, cp_accounting_date IN DATE) IS
1917: SELECT period_name, start_date, end_date, closing_status

Line 1941: and org_organization_definitions for getting SOB and

1937:
1938: -- Validation of whether the accounting date falls under an open period or not, if not, then we populate the first date of period
1939: /* Bug 5243532. Added by Lakshmi Gopalsami
1940: Removed the logic which is referring to hr_operating_units
1941: and org_organization_definitions for getting SOB and
1942: implemented the same using caching logic.
1943: */
1944: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
1945: (p_org_id => p_organization_id );