APPS.OKS_TEMPLATE_SET_PUB dependencies on OKS_K_HEADERS_B

Line 1659: FROM oks_k_headers_b

1655:
1656:
1657: CURSOR csr_renewal_k_yn IS
1658: SELECT DECODE(renewal_type_used,NULL,'N','R')
1659: FROM oks_k_headers_b
1660: WHERE chr_id = p_contract_id;
1661:
1662: CURSOR csr_tmpl_set_dtls(p_template_set_id IN NUMBER,
1663: p_process_code IN VARCHAR2,

Line 1683: FROM oks_k_headers_b

1679: AND NVL(r.report_duration,-99) = NVL(p_report_duration, NVL(r.report_duration,-99)) ;
1680:
1681: CURSOR csr_k_item_key IS
1682: SELECT wf_item_key
1683: FROM oks_k_headers_b
1684: WHERE chr_id = p_contract_id;
1685:
1686: CURSOR csr_xdo_template_name(p_attachment_template_id IN NUMBER)IS
1687: SELECT template_name