APPS.AMS_CT_RULE_PVT dependencies on AMS_CONTENT_RULES_VL

Line 794: FROM ams_content_rules_vl

790: RETURN VARCHAR2
791: IS
792: CURSOR c_rule_det
793: IS SELECT 1
794: FROM ams_content_rules_vl
795: WHERE object_type = p_object_type
796: AND trigger_code = p_trigger_code
797: AND object_id = p_object_id
798: AND enabled_flag = p_enabled_flag;

Line 802: FROM ams_content_rules_vl

798: AND enabled_flag = p_enabled_flag;
799:
800: CURSOR c_rule_det_null
801: IS SELECT 1
802: FROM ams_content_rules_vl
803: WHERE object_type = p_object_type
804: AND trigger_code = p_trigger_code
805: AND object_id IS null;
806:

Line 1517: FROM ams_content_rules_vl

1513: IS
1514:
1515: CURSOR c_rules_generic IS
1516: SELECT cover_letter_id, email_subject,sender, reply_to,sender_display_name, delivery_mode
1517: FROM ams_content_rules_vl
1518: WHERE object_type = p_object_type
1519: AND trigger_code = p_trigger_type
1520: AND object_id IS NULL;
1521:

Line 1525: FROM ams_content_rules_vl

1521:
1522:
1523: CURSOR c_rules_for_object_enabled IS
1524: SELECT cover_letter_id, email_subject,sender, reply_to,sender_display_name, delivery_mode
1525: FROM ams_content_rules_vl
1526: WHERE object_type = p_object_type
1527: AND trigger_code = p_trigger_type
1528: AND object_id = p_object_id
1529: AND enabled_flag = 'Y'; -- 'Y' for (1) ; 'N' for (3)

Line 1533: FROM ams_content_rules_vl

1529: AND enabled_flag = 'Y'; -- 'Y' for (1) ; 'N' for (3)
1530:
1531: CURSOR c_rules_for_object_disabled IS
1532: SELECT cover_letter_id, email_subject,sender, reply_to,sender_display_name, delivery_mode
1533: FROM ams_content_rules_vl
1534: WHERE object_type = p_object_type
1535: AND trigger_code = p_trigger_type
1536: AND object_id = p_object_id
1537: AND enabled_flag = 'N'; -- 'Y' for (1) ; 'N' for (3)