APPS.OKC_SUBCLASS_PVT dependencies on OKC_SUBCLASS_ROLES_V

Line 1443: | OKC_SUBCLASS_ROLES_V |

1439: | This API will copy One category to another one. |
1440: | |
1441: |This will copy all the category related informations from foll. views |
1442: | OKC_SUBCLASSES_V |
1443: | OKC_SUBCLASS_ROLES_V |
1444: | OKC_SUBCLASS_RG_DEFS_V |
1445: | OKC_RG_ROLE_DEFS_V |
1446: | OKC_SUBCLASS_TOP_LINE_V |
1447: | OKC_LINE_STYLE_ROLES_V |

Line 1498: FROM okc_subclass_roles_v

1494: scs_code ,
1495: start_date ,
1496: end_date ,
1497: access_level
1498: FROM okc_subclass_roles_v
1499: WHERE scs_code=b_scs_code;
1500:
1501: /* Cursor to get existing Subclass Rule Group Information */
1502: CURSOR c_get_scs_rg_defs(b_scs_code varchar2)IS

Line 1542: (SELECT id FROM okc_subclass_roles_v WHERE scs_code=b_scs_code);

1538: FROM okc_rg_role_defs_v
1539: WHERE srd_id IN
1540: ( SELECT id FROM okc_subclass_rg_defs_v WHERE scs_code=b_scs_code)
1541: AND sre_id IN
1542: (SELECT id FROM okc_subclass_roles_v WHERE scs_code=b_scs_code);
1543:
1544:
1545: /* Cursor to get existing Subclass Top Line Information */
1546:

Line 1567: (SELECT id FROM okc_subclass_roles_v WHERE scs_code=b_scs_code);

1563: sre_id,
1564: access_level
1565: FROM OKC_LINE_STYLE_ROLES_v
1566: WHERE sre_id IN
1567: (SELECT id FROM okc_subclass_roles_v WHERE scs_code=b_scs_code);
1568:
1569:
1570: /* Cursor to get existing Subclass Top Line Rule Group Information */
1571: