APPS.OKS_SUBSCRIPTION_PVT dependencies on OKS_SUBSCR_PATTERNS

Line 455: From oks_subscr_patterns

451: And rownum < 2;
452:
453: Cursor ptrn_cur Is
454: Select id, object_version_number, year, month, week, week_day, day
455: From oks_subscr_patterns
456: Where dnz_cle_id = p_cle_id;
457:
458: Cursor elem_cur Is
459: Select id, start_date, end_date, quantity, uom_code,

Line 1128: from oks_subscr_patterns

1124: l_scpv_tbl_in OKS_SUBSCR_PTRNS_PUB.scpv_tbl_type;
1125: l_scpv_tbl_out OKS_SUBSCR_PTRNS_PUB.scpv_tbl_type;
1126: Cursor src_osp_cur Is
1127: select year, month, week, week_day, day
1128: from oks_subscr_patterns
1129: where dnz_cle_id = p_source_cle_id;
1130: i Number := 0;
1131: Begin
1132: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1372: From oks_subscr_patterns

1368:
1369: Procedure delete_osp Is
1370: Cursor scpv_cur Is
1371: Select id
1372: From oks_subscr_patterns
1373: Where dnz_cle_id = p_cle_id;
1374: l_scpv_tbl OKS_SUBSCR_PTRNS_PUB.scpv_tbl_type;
1375: i Number := 0;
1376: Begin