DBA Data[Home] [Help]

APPS.GMPRELAP dependencies on MTL_PARAMETERS

Line 469: SELECT calendar_code,organization_code FROM mtl_parameters

465: ) IS
466:
467: -- Contiguity Override changes
468: Cursor calendar_associated(l_organization_id NUMBER) IS
469: SELECT calendar_code,organization_code FROM mtl_parameters
470: WHERE organization_id = l_organization_id ;
471:
472: l_gme_batch_header GME_BATCH_HEADER%ROWTYPE;
473: x_gme_batch_header2 GME_BATCH_HEADER%ROWTYPE;

Line 1102: SELECT calendar_code, organization_code FROM mtl_parameters

1098: AND b.recipe_use IN (0,1) ;
1099:
1100: -- Contiguity Override changes
1101: Cursor calendar_associated(l_organization_id NUMBER) IS
1102: SELECT calendar_code, organization_code FROM mtl_parameters
1103: WHERE organization_id = l_organization_id ;
1104:
1105: x_message_count NUMBER;
1106: x_message_list VARCHAR2(2000);

Line 1575: FROM gme_batch_header gbh, mtl_parameters mp

1571: SELECT gbh.batch_no, gbh.batch_status,
1572: gbh.recipe_validity_rule_id,
1573: mp.organization_code,
1574: gbh.batch_type
1575: FROM gme_batch_header gbh, mtl_parameters mp
1576: WHERE gbh.batch_id = p_batch_id
1577: AND gbh.organization_id = mp.organization_id
1578: AND mp.organization_id = p_organization_id;
1579: