APPS.BOM_RTG_VAL_TO_ID dependencies on BOM_ALTERNATE_DESIGNATORS

Line 938: FROM bom_alternate_designators

934:
935: CURSOR c_Check_Alternate( p_alt_designator VARCHAR2,
936: p_organization_id NUMBER ) IS
937: SELECT 1
938: FROM bom_alternate_designators
939: WHERE alternate_designator_code = p_alt_designator
940: AND organization_id = p_organization_id;
941:
942: BEGIN

Line 1583: FROM bom_alternate_designators

1579:
1580: CURSOR c_Check_Alternate( p_alt_designator VARCHAR2,
1581: p_organization_id NUMBER ) IS
1582: SELECT 1
1583: FROM bom_alternate_designators
1584: WHERE alternate_designator_code = p_alt_designator
1585: AND organization_id = p_organization_id;
1586:
1587: BEGIN

Line 2500: FROM bom_alternate_designators

2496:
2497: CURSOR c_Check_Alternate( p_alt_designator VARCHAR2,
2498: p_organization_id NUMBER ) IS
2499: SELECT 1
2500: FROM bom_alternate_designators
2501: WHERE alternate_designator_code = p_alt_designator
2502: AND organization_id = p_organization_id;
2503:
2504: BEGIN

Line 3247: FROM bom_alternate_designators

3243:
3244: CURSOR c_Check_Alternate( p_alt_designator VARCHAR2,
3245: p_organization_id NUMBER ) IS
3246: SELECT 1
3247: FROM bom_alternate_designators
3248: WHERE alternate_designator_code = p_alt_designator
3249: AND organization_id = p_organization_id;
3250:
3251: BEGIN

Line 4074: FROM bom_alternate_designators

4070:
4071: CURSOR c_Check_Alternate( p_alt_designator VARCHAR2,
4072: p_organization_id NUMBER ) IS
4073: SELECT 1
4074: FROM bom_alternate_designators
4075: WHERE alternate_designator_code = p_alt_designator
4076: AND organization_id = p_organization_id;
4077:
4078: /***BEGIN 1838261***/