APPS.AMS_TCOP_SUMMARIZATION_PKG dependencies on AMS_TCOP_FR_PERIODS_B

Line 135: ,AMS_TCOP_FR_PERIODS_B period

131: IS
132: SELECT RULE.RULE_ID
133: ,PERIOD.NO_OF_DAYS
134: FROM AMS_TCOP_FR_RULES_SETUP RULE
135: ,AMS_TCOP_FR_PERIODS_B period
136: WHERE RULE.RULE_TYPE='GLOBAL'
137: AND RULE.ENABLED_FLAG = 'Y'
138: AND RULE.PERIOD_ID = PERIOD.PERIOD_ID;
139:

Line 145: ,AMS_TCOP_FR_PERIODS_B period

141: CURSOR C_GET_CHANNEL_RULE
142: IS
143: SELECT rule.RULE_ID,period.no_of_days
144: FROM AMS_TCOP_FR_RULES_SETUP rule
145: ,AMS_TCOP_FR_PERIODS_B period
146: WHERE rule.RULE_TYPE = 'CHANNEL_BASED'
147: AND rule.CHANNEL_ID = p_activity_id
148: AND rule.ENABLED_FLAG = 'Y'
149: AND rule.period_id = period.period_id;