DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_PVT dependencies on CSI_COUNTER_ASSOCIATIONS

Line 12151: FROM csi_counter_associations

12147: ,source_object_id
12148: ,counter_id
12149: ,object_version_number
12150: ,start_date_active --Add for bug 6963602
12151: FROM csi_counter_associations
12152: WHERE source_object_id = p_source_object_id
12153: AND source_object_code = 'CP';
12154:
12155: -- Added cursor for bug 8516781, FP bug 8551918

Line 14844: FROM csi_counter_associations

14840: BEGIN
14841:
14842: SELECT 'Y'
14843: INTO l_exists
14844: FROM csi_counter_associations
14845: WHERE source_object_id = p_instance_rec.instance_id
14846: AND source_object_code = 'CP';
14847:
14848: EXCEPTION

Line 14976: FROM csi_counter_associations

14972: l_exists := 'N';
14973: BEGIN
14974: SELECT 'Y'
14975: INTO l_exists
14976: FROM csi_counter_associations
14977: WHERE source_object_id = p_instance_rec.instance_id
14978: AND source_object_code = 'CP';
14979: EXCEPTION
14980: WHEN NO_DATA_FOUND THEN

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

15024: l_ctr_associations_tbl(l_ctr).maint_organization_id :=
15025: l_latest_maint_org_id;
15026:
15027: --Added for bug 6963602, during migration to R12, the start_date_active for entries in
15028: --csi_counter_associations table are not properly populated, in that case, use the
15029: --active_start_date for the associated item instance
15030: IF l_upd_ctr_assn_csr.start_date_active IS NULL THEN
15031: BEGIN
15032: SELECT active_start_date