DBA Data[Home] [Help]

APPS.OZF_THRESHOLD_PVT dependencies on OZF_THRESHOLDS_ALL_B

Line 914: FROM ozf_threshold_rules_all r, ozf_thresholds_all_b t

910:
911: CURSOR c_threshold_rules_cur IS
912: SELECT r.threshold_rule_id,
913: r.threshold_id
914: FROM ozf_threshold_rules_all r, ozf_thresholds_all_b t
915: WHERE r.threshold_id = t.threshold_id
916: AND t.threshold_type = 'BUDGET'
917: AND r.enabled_flag = 'Y'
918: AND r.start_date <= SYSDATE

Line 954: ozf_thresholds_all_b b,

950: c.frequency_period frequency_period,
951: c.converted_days conv_frequency_period, --Not used in current version.
952: c.repeat_frequency repeat_frequency
953: FROM ozf_funds_all_b a,
954: ozf_thresholds_all_b b,
955: ozf_threshold_rules_all c
956: WHERE a.threshold_id = b.threshold_id
957: AND a.status_code = 'ACTIVE'
958: AND b.enable_flag = 'Y'