APPS.CST_SUBELEMENTS_PVT dependencies on BOM_DEPARTMENT_CLASSES

Line 924: INSERT INTO bom_department_classes

920: l_statement := 140;
921:
922: IF (l_department_class_code IS NOT NULL) THEN
923:
924: INSERT INTO bom_department_classes
925: (
926: department_class_code,
927: organization_id,
928: last_update_date,

Line 984: FROM bom_department_classes bdc

980: l_request_id,
981: l_prog_app_id,
982: l_prog_id,
983: SYSDATE
984: FROM bom_department_classes bdc
985: WHERE bdc.organization_id = p_from_organization_id
986: AND bdc.department_class_code = l_department_class_code
987: AND NOT EXISTS
988: ( SELECT 'X'

Line 989: FROM bom_department_classes bdc2

985: WHERE bdc.organization_id = p_from_organization_id
986: AND bdc.department_class_code = l_department_class_code
987: AND NOT EXISTS
988: ( SELECT 'X'
989: FROM bom_department_classes bdc2
990: WHERE bdc2.organization_id = p_to_organization_id
991: AND bdc2.department_class_code = l_department_class_code);
992:
993: IF (SQL%ROWCOUNT) > 0 THEN