DBA Data[Home] [Help]

APPS.OKC_SUBCLASS_PVT dependencies on OKC_SUBCLASS_RG_DEFS_V

Line 1444: | OKC_SUBCLASS_RG_DEFS_V |

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 |
1448: | OKC_LSE_ROLE_GROUPS_V |

Line 1510: FROM okc_subclass_rg_defs_v

1506: scs_code,
1507: start_date,
1508: end_date,
1509: access_level
1510: FROM okc_subclass_rg_defs_v
1511: WHERE scs_code=b_scs_code;
1512:
1513: /* Cursor to get existing Subclass Rule Group Role Information */
1514:

Line 1540: ( SELECT id FROM okc_subclass_rg_defs_v WHERE scs_code=b_scs_code)

1536: attribute15,
1537: access_level
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:

Line 1579: ( SELECT id FROM okc_subclass_rg_defs_v WHERE scs_code=b_scs_code);

1575: srd_id,
1576: access_level
1577: FROM OKC_LSE_RULE_GROUPS_v
1578: WHERE srd_id IN
1579: ( SELECT id FROM okc_subclass_rg_defs_v WHERE scs_code=b_scs_code);
1580:
1581:
1582: /* Cursor to get existing Subclass Responsibility Information */
1583: