APPS.PO_EDA_DATATEMPLATE_PKG dependencies on OKC_SECTIONS_B

Line 1115: SELECT (SELECT heading FROM okc_sections_b WHERE id = kartb.scn_id) Section,get_miscclausetxt(scn_id,'N') MiscellaneousText

1111: l_clob3 CLOB;
1112:
1113:
1114: CURSOR c_misctext_base IS
1115: SELECT (SELECT heading FROM okc_sections_b WHERE id = kartb.scn_id) Section,get_miscclausetxt(scn_id,'N') MiscellaneousText
1116: FROM okc_k_articles_b kartb, okc_articles_all art, okc_article_versions ver
1117: WHERE kartb.document_id = DOCUMENTID
1118: AND kartb.sav_sae_id = art.article_id
1119: AND kartb.article_version_id = ver.article_version_id

Line 1127: SELECT (SELECT heading FROM okc_sections_b WHERE id = kartb.scn_id) Section,get_miscclausetxt(scn_id,'Y') MiscellaneousText

1123: GROUP BY scn_id
1124: ORDER BY scn_id;
1125:
1126: CURSOR c_misctext_mod IS
1127: SELECT (SELECT heading FROM okc_sections_b WHERE id = kartb.scn_id) Section,get_miscclausetxt(scn_id,'Y') MiscellaneousText
1128: FROM okc_k_articles_b kartb, okc_articles_all art, okc_article_versions ver
1129: WHERE kartb.document_id = DRAFTID
1130: AND kartb.sav_sae_id = art.article_id
1131: AND kartb.article_version_id = ver.article_version_id

Line 2870: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn

2866: Decode(art.standard_yn,'Y',decode(article_type,'FAR','http://www.arnet.gov',
2867: 'DFARS','http://www.acq.osd.mil/dpap/dars/index.html',
2868: ' '),
2869: nvl(ver.REFERENCE_SOURCE,' ')) RegulationURL
2870: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn
2871: WHERE
2872: poh.draft_id = p_draftid AND poh.change_status IS NOT NULL
2873: AND kartb.sav_sae_id = art.article_id
2874: AND kartb.article_version_id = ver.article_version_id

Line 2887: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn

2883: Decode(art.standard_yn,'Y',decode(article_type,'FAR','http://www.arnet.gov',
2884: 'DFARS','http://www.acq.osd.mil/dpap/dars/index.html',
2885: ' '),
2886: nvl(ver.REFERENCE_SOURCE,' ')) RegulationURL
2887: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn
2888: WHERE
2889: poh.po_header_id = p_docid AND poh.draft_id = -1 AND poh.change_status is NULL
2890: AND kartb.sav_sae_id = art.article_id
2891: AND kartb.article_version_id = ver.article_version_id

Line 2905: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn

2901: Decode(art.standard_yn,'Y',decode(article_type,'FAR','http://www.arnet.gov',
2902: 'DFARS','http://www.acq.osd.mil/dpap/dars/index.html',
2903: ' '),
2904: nvl(ver.REFERENCE_SOURCE,' ')) RegulationURL
2905: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn
2906: WHERE
2907: poh.po_header_id = p_docid AND poh.draft_id = -1 AND poh.change_status is NULL
2908: AND kartb.sav_sae_id = art.article_id
2909: AND kartb.article_version_id = ver.article_version_id

Line 2922: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn

2918: Decode(art.standard_yn,'Y',decode(article_type,'FAR','http://www.arnet.gov',
2919: 'DFARS','http://www.acq.osd.mil/dpap/dars/index.html',
2920: ' '),
2921: nvl(ver.REFERENCE_SOURCE,' ')) RegulationURL
2922: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn
2923: WHERE
2924: poh.draft_id = p_draftid AND poh.change_status IS NOT NULL
2925: AND kartb.sav_sae_id = art.article_id
2926: AND kartb.article_version_id = ver.article_version_id