DBA Data[Home] [Help]

APPS.OKS_K_ACTIONS_PVT dependencies on XDO_TEMPLATES_VL

Line 203: FROM oks_report_templates ort ,XDO_TEMPLATES_VL XTVL

199: AND ort.id=p_attachment_template_id;*/
200:
201: CURSOR c_attachment
202: IS SELECT ort.report_id,ort.template_set_type, nvl(ort.attachment_name, xtvl.template_name)
203: FROM oks_report_templates ort ,XDO_TEMPLATES_VL XTVL
204: WHERE XTVL.APPLICATION_ID = 515 AND
205: XTVL.TEMPLATE_TYPE_CODE = 'RTF' AND
206: SYSDATE BETWEEN XTVL.START_DATE AND
207: NVL(XTVL.END_DATE,SYSDATE) AND NVL(XTVL.DEPENDENCY_FLAG,'P') = 'P' AND

Line 1130: FROM oks_report_templates ort ,XDO_TEMPLATES_VL XTVL

1126: AND ort.id=p_attachment_template_id;*/
1127:
1128: CURSOR c_attachment
1129: IS SELECT ort.report_id,ort.template_set_type, nvl(ort.attachment_name, xtvl.template_name)
1130: FROM oks_report_templates ort ,XDO_TEMPLATES_VL XTVL
1131: WHERE XTVL.APPLICATION_ID = 515 AND
1132: XTVL.TEMPLATE_TYPE_CODE = 'RTF' AND
1133: SYSDATE BETWEEN XTVL.START_DATE AND
1134: NVL(XTVL.END_DATE,SYSDATE) AND NVL(XTVL.DEPENDENCY_FLAG,'P') = 'P' AND