APPS.OKS_K_ACTIONS_PVT dependencies on OKS_REPORT_TEMPLATES

Line 168: FROM OKS_REPORT_TEMPLATES ort ,OKS_LAYOUT_TEMPLATES_V olt

164:
165:
166: /* CURSOR c_attachment
167: IS SELECT ort.report_id,ort.template_set_type, nvl(ort.attachment_name, olt.template_name)
168: FROM OKS_REPORT_TEMPLATES ort ,OKS_LAYOUT_TEMPLATES_V olt
169: WHERE ort.report_id=olt.template_id
170: AND ort.id=p_attachment_template_id;*/
171:
172: CURSOR c_attachment

Line 174: FROM oks_report_templates ort ,XDO_TEMPLATES_VL XTVL

170: AND ort.id=p_attachment_template_id;*/
171:
172: CURSOR c_attachment
173: IS SELECT ort.report_id,ort.template_set_type, nvl(ort.attachment_name, xtvl.template_name)
174: FROM oks_report_templates ort ,XDO_TEMPLATES_VL XTVL
175: WHERE XTVL.APPLICATION_ID = 515 AND
176: XTVL.TEMPLATE_TYPE_CODE = 'RTF' AND
177: SYSDATE BETWEEN XTVL.START_DATE AND
178: NVL(XTVL.END_DATE,SYSDATE) AND NVL(XTVL.DEPENDENCY_FLAG,'P') = 'P' AND

Line 1095: FROM OKS_REPORT_TEMPLATES ort ,OKS_LAYOUT_TEMPLATES_V olt

1091:
1092:
1093: /* CURSOR c_attachment
1094: IS SELECT ort.report_id,ort.template_set_type, nvl(ort.attachment_name, olt.template_name)
1095: FROM OKS_REPORT_TEMPLATES ort ,OKS_LAYOUT_TEMPLATES_V olt
1096: WHERE ort.report_id=olt.template_id
1097: AND ort.id=p_attachment_template_id;*/
1098:
1099: CURSOR c_attachment

Line 1101: FROM oks_report_templates ort ,XDO_TEMPLATES_VL XTVL

1097: AND ort.id=p_attachment_template_id;*/
1098:
1099: CURSOR c_attachment
1100: IS SELECT ort.report_id,ort.template_set_type, nvl(ort.attachment_name, xtvl.template_name)
1101: FROM oks_report_templates ort ,XDO_TEMPLATES_VL XTVL
1102: WHERE XTVL.APPLICATION_ID = 515 AND
1103: XTVL.TEMPLATE_TYPE_CODE = 'RTF' AND
1104: SYSDATE BETWEEN XTVL.START_DATE AND
1105: NVL(XTVL.END_DATE,SYSDATE) AND NVL(XTVL.DEPENDENCY_FLAG,'P') = 'P' AND