DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_PVT dependencies on CSI_COUNTER_ASSOCIATIONS

Line 11845: FROM csi_counter_associations

11841: ,source_object_id
11842: ,counter_id
11843: ,object_version_number
11844: ,start_date_active --Add for bug 6963602
11845: FROM csi_counter_associations
11846: WHERE source_object_id = p_source_object_id
11847: AND source_object_code = 'CP';
11848:
11849: l_ins_hist_id NUMBER;

Line 14396: FROM csi_counter_associations

14392: BEGIN
14393:
14394: SELECT 'Y'
14395: INTO l_exists
14396: FROM csi_counter_associations
14397: WHERE source_object_id = p_instance_rec.instance_id
14398: AND source_object_code = 'CP';
14399:
14400: EXCEPTION

Line 14520: FROM csi_counter_associations

14516: l_exists := 'N';
14517: BEGIN
14518: SELECT 'Y'
14519: INTO l_exists
14520: FROM csi_counter_associations
14521: WHERE source_object_id = p_instance_rec.instance_id
14522: AND source_object_code = 'CP';
14523: EXCEPTION
14524: WHEN NO_DATA_FOUND THEN

Line 14572: --csi_counter_associations table are not properly populated, in that case, use the

14568: l_ctr_associations_tbl(l_ctr).maint_organization_id :=
14569: l_latest_maint_org_id;
14570:
14571: --Added for bug 6963602, during migration to R12, the start_date_active for entries in
14572: --csi_counter_associations table are not properly populated, in that case, use the
14573: --active_start_date for the associated item instance
14574: IF l_upd_ctr_assn_csr.start_date_active IS NULL THEN
14575: BEGIN
14576: SELECT active_start_date