3054:
3055: l_pos_structure_version_id NUMBER(15) := 65;
3056: l_pos_id NUMBER(15);
3057: l_job_id NUMBER(15);
3058: l_control_group_id igc_cc_control_groups.control_group_id%TYPE;
3059: l_enabled_flag igc_cc_control_groups.enabled_flag%TYPE;
3060: l_active_date igc_cc_control_groups.active_date%TYPE;
3061: l_group_amount igc_cc_control_groups.amount%TYPE;
3062: l_total_amount igc_cc_control_groups.amount%TYPE;
3055: l_pos_structure_version_id NUMBER(15) := 65;
3056: l_pos_id NUMBER(15);
3057: l_job_id NUMBER(15);
3058: l_control_group_id igc_cc_control_groups.control_group_id%TYPE;
3059: l_enabled_flag igc_cc_control_groups.enabled_flag%TYPE;
3060: l_active_date igc_cc_control_groups.active_date%TYPE;
3061: l_group_amount igc_cc_control_groups.amount%TYPE;
3062: l_total_amount igc_cc_control_groups.amount%TYPE;
3063: l_ccid_in_range boolean;
3056: l_pos_id NUMBER(15);
3057: l_job_id NUMBER(15);
3058: l_control_group_id igc_cc_control_groups.control_group_id%TYPE;
3059: l_enabled_flag igc_cc_control_groups.enabled_flag%TYPE;
3060: l_active_date igc_cc_control_groups.active_date%TYPE;
3061: l_group_amount igc_cc_control_groups.amount%TYPE;
3062: l_total_amount igc_cc_control_groups.amount%TYPE;
3063: l_ccid_in_range boolean;
3064:
3057: l_job_id NUMBER(15);
3058: l_control_group_id igc_cc_control_groups.control_group_id%TYPE;
3059: l_enabled_flag igc_cc_control_groups.enabled_flag%TYPE;
3060: l_active_date igc_cc_control_groups.active_date%TYPE;
3061: l_group_amount igc_cc_control_groups.amount%TYPE;
3062: l_total_amount igc_cc_control_groups.amount%TYPE;
3063: l_ccid_in_range boolean;
3064:
3065: TYPE control_rules_tbl_type IS TABLE OF igc_cc_control_rules%ROWTYPE
3058: l_control_group_id igc_cc_control_groups.control_group_id%TYPE;
3059: l_enabled_flag igc_cc_control_groups.enabled_flag%TYPE;
3060: l_active_date igc_cc_control_groups.active_date%TYPE;
3061: l_group_amount igc_cc_control_groups.amount%TYPE;
3062: l_total_amount igc_cc_control_groups.amount%TYPE;
3063: l_ccid_in_range boolean;
3064:
3065: TYPE control_rules_tbl_type IS TABLE OF igc_cc_control_rules%ROWTYPE
3066: INDEX BY BINARY_INTEGER;
3178: CURSOR c_control_group_info IS
3179: SELECT enabled_flag ,
3180: active_date ,
3181: amount
3182: FROM igc_cc_control_groups
3183: WHERE org_id = g_org_id
3184: AND control_group_id = l_control_group_id;
3185:
3186: