APPS.AMS_TRACKING_PVT dependencies on JTF_AMV_ATTACHMENTS

Line 80: SELECT NVL(display_rule_id,0) FROM jtf_amv_attachments WHERE

76: l_activity_type VARCHAR2(30);
77: obj_type VARCHAR2(4);
78:
79: CURSOR c_minisite_id(p_webcontent_id NUMBER) IS
80: SELECT NVL(display_rule_id,0) FROM jtf_amv_attachments WHERE
81: attachment_id = p_webcontent_id;
82:
83: CURSOR c_minisite_id_lite(p_webcontent_id NUMBER) IS
84: select p.action_param_value

Line 507: from jtf_amv_attachments

503:
504: IF (p_web_content_id IS NOT NULL) THEN
505: select display_url, link_to
506: into x_redirect_url, x_action_parameter_code
507: from jtf_amv_attachments
508: where attachment_id = p_web_content_id;
509: END IF;
510: End get_redirect_url;
511: