DBA Data[Home] [Help]

APPS.OKS_K_ACTIONS_PVT dependencies on XDO_TEMPLATES_VL

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 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