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 2503: FROM bom_alternate_designators

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

Line 3250: FROM bom_alternate_designators

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

Line 4077: FROM bom_alternate_designators

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