APPS.GME_COMMON_PVT dependencies on MTL_PARAMETERS

Line 282: FROM mtl_parameters

278: CURSOR cur_get_inv_params (v_org_id NUMBER, v_org_code VARCHAR2)
279: IS
280: SELECT organization_code, calendar_code, negative_inv_receipt_code
281: ,stock_locator_control_code, organization_id
282: FROM mtl_parameters
283: WHERE (organization_id = v_org_id)
284: OR (v_org_id IS NULL AND organization_code = v_org_code);
285:
286: CURSOR cur_get_user (v_user_id NUMBER)

Line 1884: FROM mtl_parameters

1880:
1881: CURSOR cur_org_details (v_org_id NUMBER)
1882: IS
1883: SELECT negative_inv_receipt_code, stock_locator_control_code
1884: FROM mtl_parameters
1885: WHERE organization_id = v_org_id;
1886:
1887: CURSOR cur_subinventory_details (
1888: v_org_id NUMBER

Line 3520: FROM mtl_parameters

3516: IS
3517: CURSOR get_organization (p_org_code IN VARCHAR2)
3518: IS
3519: SELECT organization_id
3520: FROM mtl_parameters
3521: WHERE organization_code = p_org_code;
3522:
3523: l_batch_header_rec gme_batch_header%ROWTYPE;
3524: l_api_name VARCHAR2 (30) := 'GET_BATCH_HEADER';

Line 3778: FROM mtl_parameters

3774: IS
3775: CURSOR get_organization (l_org_code IN VARCHAR2)
3776: IS
3777: SELECT organization_id
3778: FROM mtl_parameters
3779: WHERE organization_code = p_org_code;
3780:
3781: CURSOR get_batch_id (l_org_id IN NUMBER, l_batch_no IN VARCHAR2)
3782: IS