DBA Data[Home] [Help]

APPS.WIP_VALIDATE dependencies on BOM_DEPARTMENTS

Line 7181: FROM bom_departments

7177:
7178:
7179: SELECT 'VALID'
7180: INTO l_dummy
7181: FROM bom_departments
7182: WHERE department_code = p_department_code
7183: AND organization_id = p_organization_id;
7184:
7185: RETURN TRUE;

Line 7232: FROM bom_departments

7228:
7229:
7230: SELECT 'VALID'
7231: INTO l_dummy
7232: FROM bom_departments
7233: WHERE department_id = p_department_id;
7234:
7235: RETURN TRUE;
7236:

Line 8514: FROM bom_departments

8510: END IF;
8511:
8512: SELECT 'VALID'
8513: INTO l_dummy
8514: FROM bom_departments
8515: WHERE department_code = p_fm_department_code
8516: AND organization_id = p_organization_id;
8517:
8518: RETURN TRUE;

Line 8564: FROM bom_departments

8560: END IF;
8561:
8562: SELECT 'VALID'
8563: INTO l_dummy
8564: FROM bom_departments
8565: WHERE department_id = p_fm_department_id;
8566:
8567: RETURN TRUE;
8568:

Line 8958: FROM bom_departments

8954: END IF;
8955:
8956: SELECT 'VALID'
8957: INTO l_dummy
8958: FROM bom_departments
8959: WHERE department_code = p_to_department_code
8960: AND organization_id = p_organization_id;
8961:
8962: RETURN TRUE;

Line 9009: FROM bom_departments

9005: END IF;
9006:
9007: SELECT 'VALID'
9008: INTO l_dummy
9009: FROM bom_departments
9010: WHERE department_id = p_to_department_id;
9011:
9012: RETURN TRUE;
9013: