DBA Data[Home] [Help]

APPS.GMPRELAP dependencies on MTL_PARAMETERS

Line 444: SELECT calendar_code,organization_code FROM mtl_parameters

440: ) IS
441:
442: -- Contiguity Override changes
443: Cursor calendar_associated(l_organization_id NUMBER) IS
444: SELECT calendar_code,organization_code FROM mtl_parameters
445: WHERE organization_id = l_organization_id ;
446:
447: l_gme_batch_header GME_BATCH_HEADER%ROWTYPE;
448: x_gme_batch_header2 GME_BATCH_HEADER%ROWTYPE;

Line 975: SELECT calendar_code, organization_code FROM mtl_parameters

971: AND b.recipe_use IN (0,1) ;
972:
973: -- Contiguity Override changes
974: Cursor calendar_associated(l_organization_id NUMBER) IS
975: SELECT calendar_code, organization_code FROM mtl_parameters
976: WHERE organization_id = l_organization_id ;
977:
978: x_message_count NUMBER;
979: x_message_list VARCHAR2(2000);

Line 1344: FROM gme_batch_header gbh, mtl_parameters mp

1340: CURSOR get_batch_status IS
1341: SELECT gbh.batch_no, gbh.batch_status,
1342: gbh.recipe_validity_rule_id,
1343: mp.organization_code
1344: FROM gme_batch_header gbh, mtl_parameters mp
1345: WHERE gbh.batch_id = p_batch_id
1346: AND gbh.organization_id = mp.organization_id
1347: AND mp.organization_id = p_organization_id;
1348: