APPS.CSI_COUNTER_TEMPLATE_PVT dependencies on CSI_COUNTER_TEMPLATE_VL

Line 226: FROM csi_counter_template_vl

222: --Changed for Bug 7462345, validating the name while update
223: BEGIN
224: SELECT 'x'
225: INTO l_exists
226: FROM csi_counter_template_vl
227: WHERE upper(name) = upper(p_name)
228: AND Nvl(group_id, FND_API.G_MISS_NUM) = Nvl(p_group_id, FND_API.G_MISS_NUM)-- Added for bug 9088368
229: AND COUNTER_ID <> Nvl(p_counter_id, FND_API.G_MISS_NUM);
230: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CSI_API_CTR_DUP_NAME','CTR_NAME',p_name);

Line 4105: FROM csi_counter_template_vl

4101: comments,
4102: association_type,
4103: time_based_manual_entry,
4104: eam_required_flag
4105: FROM csi_counter_template_vl
4106: WHERE counter_id = p_counter_id
4107: FOR UPDATE OF OBJECT_VERSION_NUMBER;
4108: l_old_counter_template_rec cur_ctr_template_rec%ROWTYPE;
4109:

Line 6028: FROM csi_counter_template_vl

6024: csi_ctr_gen_utility_pvt.put_line('before updating csi_counters_vl');
6025: BEGIN
6026: SELECT 'x'
6027: INTO l_found
6028: FROM csi_counter_template_vl
6029: WHERE counter_id = p_ctr_derived_filters_tbl(tab_row).COUNTER_ID;
6030:
6031: UPDATE csi_counter_template_b
6032: SET valid_flag = decode(l_valid_flag, 'Y', 'Y', 'N')

Line 6960: FROM csi_counter_template_vl

6956: used_in_scheduling,
6957: security_group_id,
6958: nvl(time_based_manual_entry, 'N') tm_based_manual_entry,
6959: eam_required_flag
6960: FROM csi_counter_template_vl
6961: WHERE counter_id = p_counter_id
6962: AND NVL(end_date_active, SYSDATE+1) > SYSDATE;
6963:
6964: CURSOR fmla_ctr_cur(p_counter_id NUMBER) IS

Line 7518: FROM csi_counter_template_vl ctr,

7514: csi_ctr_gen_utility_pvt.put_line('Inside the ctr_der_filter_cur_rec ');
7515:
7516: SELECT counter_property_id
7517: INTO l_new_der_ctr_prop_id
7518: FROM csi_counter_template_vl ctr,
7519: csi_ctr_prop_template_vl ctrprop
7520: WHERE ctrprop.counter_property_id = ctr_der_filter_cur_rec.counter_property_id
7521: AND ctrprop.counter_id = l_new_ctr_id;
7522:

Line 7894: FROM csi_counter_template_vl

7890: used_in_scheduling,
7891: security_group_id,
7892: nvl(time_based_manual_entry, 'N') tm_based_manual_entry,
7893: eam_required_flag
7894: FROM csi_counter_template_vl
7895: WHERE group_id = p_counter_group_id
7896: AND NVL(end_date_active, SYSDATE+1) > SYSDATE; --Added for bug 9115470
7897:
7898: CURSOR fmla_ctr_cur(p_counter_group_id NUMBER) IS

Line 8441: FROM csi_counter_template_vl ctr,

8437: csi_ctr_gen_utility_pvt.put_line('Inside the ctr_der_filter_cur_rec ');
8438:
8439: SELECT counter_property_id
8440: INTO l_new_der_ctr_prop_id
8441: FROM csi_counter_template_vl ctr,
8442: csi_ctr_prop_template_vl ctrprop
8443: WHERE ctrprop.counter_property_id = ctr_der_filter_cur_rec.counter_property_id
8444: AND ctrprop.counter_id = l_new_ctr_id;
8445: