APPS.AHL_FMP_COMMON_PVT dependencies on CS_CSI_COUNTER_GROUPS

Line 692: CS_CSI_COUNTER_GROUPS CG,

688: IS
689: SELECT 'X'
690: FROM csi_counter_template_vl C,
691: --CS_COUNTER_GROUPS CG,
692: CS_CSI_COUNTER_GROUPS CG,
693: CS_CTR_ASSOCIATIONS CA,
694: AHL_POSITION_ALTERNATES_V PA
695: WHERE C.DEFAULTED_GROUP_ID = CG.COUNTER_GROUP_ID
696: AND CG.TEMPLATE_FLAG = 'Y'

Line 728: CS_CSI_COUNTER_GROUPS CG

724: CSI_COUNTER_TEMPLATE_VL C,
725: --CS_COUNTER_GROUPS CG
726: --Priyan
727: --Perf changes . Refer Bug # 4913671
728: CS_CSI_COUNTER_GROUPS CG
729: WHERE
730: CG.TEMPLATE_FLAG = 'Y'
731: AND C.DEFAULTED_GROUP_ID = CG.COUNTER_GROUP_ID
732: AND C.NAME = c_counter_name

Line 760: CS_CSI_COUNTER_GROUPS CG

756: CSI_COUNTER_TEMPLATE_VL C,
757: --CS_COUNTER_GROUPS CG
758: --Priyan
759: --Perf changes . Refer Bug # 4913671
760: CS_CSI_COUNTER_GROUPS CG
761: WHERE
762: CG.TEMPLATE_FLAG = 'Y'
763: AND C.DEFAULTED_GROUP_ID = CG.COUNTER_GROUP_ID
764: AND C.COUNTER_ID = c_counter_id ;

Line 773: CS_CSI_COUNTER_GROUPS CG,

769: SELECT 'X'
770: FROM --cs_counters c,
771: csi_counter_template_vl C,
772: --cs_counter_groups CG,
773: CS_CSI_COUNTER_GROUPS CG,
774: cs_ctr_associations CA
775: where --C.counter_group_id = CG.counter_group_id
776: C.defaulted_group_id = CG.counter_group_id
777: and CG.template_flag = 'Y'