DBA Data[Home] [Help]

APPS.IGC_CC_APPROVAL_WF_PKG dependencies on IGC_CC_CONTROL_GROUPS

Line 3058: l_control_group_id igc_cc_control_groups.control_group_id%TYPE;

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;

Line 3059: l_enabled_flag igc_cc_control_groups.enabled_flag%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;

Line 3060: l_active_date igc_cc_control_groups.active_date%TYPE;

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:

Line 3061: l_group_amount igc_cc_control_groups.amount%TYPE;

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

Line 3062: l_total_amount igc_cc_control_groups.amount%TYPE;

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;

Line 3182: FROM igc_cc_control_groups

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: