APPS.GME_COMMON_PVT dependencies on MTL_PARAMETERS

Line 196: FROM mtl_parameters

192: CURSOR cur_get_inv_params (v_org_id NUMBER, v_org_code VARCHAR2)
193: IS
194: SELECT organization_code, calendar_code, negative_inv_receipt_code
195: ,stock_locator_control_code, organization_id
196: FROM mtl_parameters
197: WHERE (organization_id = v_org_id)
198: OR (v_org_id IS NULL AND organization_code = v_org_code);
199:
200: CURSOR cur_get_user (v_user_id NUMBER)

Line 1778: FROM mtl_parameters

1774:
1775: CURSOR cur_org_details (v_org_id NUMBER)
1776: IS
1777: SELECT negative_inv_receipt_code, stock_locator_control_code
1778: FROM mtl_parameters
1779: WHERE organization_id = v_org_id;
1780:
1781: CURSOR cur_subinventory_details (
1782: v_org_id NUMBER

Line 3261: FROM mtl_parameters

3257: IS
3258: CURSOR get_organization (p_org_code IN VARCHAR2)
3259: IS
3260: SELECT organization_id
3261: FROM mtl_parameters
3262: WHERE organization_code = p_org_code;
3263:
3264: l_batch_header_rec gme_batch_header%ROWTYPE;
3265: l_api_name VARCHAR2 (30) := 'GET_BATCH_HEADER';

Line 3519: FROM mtl_parameters

3515: IS
3516: CURSOR get_organization (l_org_code IN VARCHAR2)
3517: IS
3518: SELECT organization_id
3519: FROM mtl_parameters
3520: WHERE organization_code = p_org_code;
3521:
3522: CURSOR get_batch_id (l_org_id IN NUMBER, l_batch_no IN VARCHAR2)
3523: IS