DBA Data[Home] [Help]

APPS.JAI_AR_TRX_HEADERS_PKG dependencies on JAI_AR_TRX_APPS_RELS_T

Line 82: SELECT organization_id, location_id FROM JAI_AR_TRX_APPS_RELS_T;

78: lv_api_name CONSTANT VARCHAR2(200) := 'POPULATE_AR_TRXS';
79: lv_debug_info VARCHAR2(4000);
80:
81: CURSOR loc_app_cur IS
82: SELECT organization_id, location_id FROM JAI_AR_TRX_APPS_RELS_T;
83:
84: CURSOR register_code_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
85: SELECT register_code
86: FROM JAI_OM_OE_BOND_REG_HDRS

Line 978: SELECT organization_id, location_id FROM JAI_AR_TRX_APPS_RELS_T;

974: and unit_code = v_uom_code
975: AND NVL(end_date_active, SYSDATE) >= p_trx_date;
976:
977: CURSOR ORG_CUR IS
978: SELECT organization_id, location_id FROM JAI_AR_TRX_APPS_RELS_T;
979:
980: CURSOR organization_cur IS
981: SELECT organization_id, location_id
982: FROM JAI_AR_TRXS