APPS.AHL_FMP_COMMON_PVT dependencies on CS_CSI_COUNTER_GROUPS

Line 703: CS_CSI_COUNTER_GROUPS CG,

699: IS
700: SELECT 'X'
701: FROM csi_counter_template_vl C,
702: --CS_COUNTER_GROUPS CG,
703: CS_CSI_COUNTER_GROUPS CG,
704: CS_CTR_ASSOCIATIONS CA,
705: AHL_POSITION_ALTERNATES_V PA
706: WHERE C.DEFAULTED_GROUP_ID = CG.COUNTER_GROUP_ID
707: AND CG.TEMPLATE_FLAG = 'Y'

Line 739: CS_CSI_COUNTER_GROUPS CG

735: CSI_COUNTER_TEMPLATE_VL C,
736: --CS_COUNTER_GROUPS CG
737: --Priyan
738: --Perf changes . Refer Bug # 4913671
739: CS_CSI_COUNTER_GROUPS CG
740: WHERE
741: CG.TEMPLATE_FLAG = 'Y'
742: AND C.DEFAULTED_GROUP_ID = CG.COUNTER_GROUP_ID
743: AND C.NAME = c_counter_name

Line 771: CS_CSI_COUNTER_GROUPS CG

767: CSI_COUNTER_TEMPLATE_VL C,
768: --CS_COUNTER_GROUPS CG
769: --Priyan
770: --Perf changes . Refer Bug # 4913671
771: CS_CSI_COUNTER_GROUPS CG
772: WHERE
773: CG.TEMPLATE_FLAG = 'Y'
774: AND C.DEFAULTED_GROUP_ID = CG.COUNTER_GROUP_ID
775: AND C.COUNTER_ID = c_counter_id ;

Line 784: CS_CSI_COUNTER_GROUPS CG,

780: SELECT 'X'
781: FROM --cs_counters c,
782: csi_counter_template_vl C,
783: --cs_counter_groups CG,
784: CS_CSI_COUNTER_GROUPS CG,
785: cs_ctr_associations CA
786: where --C.counter_group_id = CG.counter_group_id
787: C.defaulted_group_id = CG.counter_group_id
788: and CG.template_flag = 'Y'