DBA Data[Home] [Help]

APPS.AMS_CAMPAIGNRULES_PVT dependencies on GL_PERIODS_V

Line 1119: FROM gl_periods_v

1115: SELECT 1
1116: FROM DUAL
1117: WHERE EXISTS(
1118: SELECT 1
1119: FROM gl_periods_v
1120: WHERE period_set_name = p_campaign_calendar
1121: );
1122:
1123: CURSOR c_start_period IS

Line 1125: FROM gl_periods_v

1121: );
1122:
1123: CURSOR c_start_period IS
1124: SELECT start_date, end_date
1125: FROM gl_periods_v
1126: WHERE period_set_name = p_campaign_calendar
1127: AND period_name = p_start_period_name;
1128:
1129: CURSOR c_end_period IS

Line 1131: FROM gl_periods_v

1127: AND period_name = p_start_period_name;
1128:
1129: CURSOR c_end_period IS
1130: SELECT start_date, end_date
1131: FROM gl_periods_v
1132: WHERE period_set_name = p_campaign_calendar
1133: AND period_name = p_end_period_name;
1134:
1135: BEGIN