DBA Data[Home] [Help]

APPS.GCS_DYN_FEM_POSTING_PKG dependencies on GCS_CATEGORIES_B

Line 839: FROM GCS_CATEGORIES_B

835:
836: -- Get object_id
837: SELECT associated_object_id
838: INTO l_object_id
839: FROM GCS_CATEGORIES_B
840: WHERE category_code = p_category_code;
841:
842: -- Bugfix 5646770: Add check to determine if its the topmost entity
843: IF (p_category_code = 'AGGREGATION') THEN

Line 1042: FROM gcs_categories_b

1038:
1039: BEGIN
1040: SELECT associated_object_id
1041: BULK COLLECT INTO l_objects_id
1042: FROM gcs_categories_b
1043: WHERE category_type_code IN ('ELIMINATION_RULE', 'CONSOLIDATION_RULE')
1044: AND target_entity_code IN ('PARENT', 'ELIMINATION');
1045: EXCEPTION
1046: WHEN no_data_found THEN

Line 1065: FROM gcs_categories_b

1061: ELSE
1062: BEGIN
1063: SELECT associated_object_id
1064: BULK COLLECT INTO l_objects_id
1065: FROM gcs_categories_b
1066: WHERE category_type_code IN ('ELIMINATION_RULE', 'CONSOLIDATION_RULE')
1067: AND target_entity_code = 'CHILD';
1068: EXCEPTION
1069: WHEN no_data_found THEN