DBA Data[Home] [Help]

APPS.OKC_TERMS_MULTIREC_GRP dependencies on OKC_ARTICLE_ADOPTIONS

Line 1101: OKC_ARTICLE_ADOPTIONS ADP

1097: ADP.GLOBAL_ARTICLE_VERSION_ID article_version_id,
1098: NVL(VERS.default_section,'UNASSIGNED') scn_code,
1099: NVL(VERS.PROVISION_YN,'N') provision_yn
1100: FROM OKC_ARTICLE_VERSIONS VERS,
1101: OKC_ARTICLE_ADOPTIONS ADP
1102: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
1103: AND VERS.ARTICLE_ID = b_article_id
1104: AND nvl(b_article_effective_date,sysdate) >= VERS.START_DATE
1105: AND nvl(b_article_effective_date,sysdate) <= nvl(VERS.end_date, nvl(b_article_effective_date,sysdate) +1)

Line 1118: OKC_ARTICLE_ADOPTIONS ADP

1114: ADP.GLOBAL_ARTICLE_VERSION_ID article_version_id,
1115: NVL(VERS.default_section,'UNASSIGNED') scn_code,
1116: NVL(VERS.PROVISION_YN,'N') provision_yn
1117: FROM OKC_ARTICLE_VERSIONS VERS,
1118: OKC_ARTICLE_ADOPTIONS ADP
1119: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
1120: AND VERS.ARTICLE_ID = b_article_id
1121: AND VERS.ARTICLE_STATUS IN ('ON_HOLD','APPROVED')
1122: AND ADP.ADOPTION_TYPE = 'ADOPTED'