APPS.AHL_DI_SUBSCRIPTION_PVT dependencies on DUAL

Line 189: FROM DUAL;

185: AHL_DEBUG_PUB.debug( 'Fetching Installation Status of PER','+SUB+');
186: END IF;
187: SELECT AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PER')
188: INTO l_prod_install_status
189: FROM DUAL;
190: END;
191:
192: -- Debug info.
193: IF G_DEBUG='Y' THEN

Line 620: l_subscription_id from dual;

616: l_subscription_info.attribute14 := p_x_subscription_tbl(i).attribute14;
617: l_subscription_info.attribute15 := p_x_subscription_tbl(i).attribute15;
618: -- Retrive the subscription id from sequence
619: Select AHL_SUBSCRIPTIONS_B_S.Nextval Into
620: l_subscription_id from dual;
621: /*-------------------------------------------------------- */
622: /* procedure name: AHL_SUBSCRIPTIONS_PKG.INSERT_ROW */
623: /* description : Added by Senthil to call Table Handler */
624: /* Date : Dec 31 2001 */

Line 1063: FROM DUAL;

1059: AHL_DEBUG_PUB.debug( 'Fetching Installation Status of PER','+SUB+');
1060: END IF;
1061: SELECT AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PER')
1062: INTO l_prod_install_status
1063: FROM DUAL;
1064: END;
1065:
1066: IF p_x_subscription_tbl.COUNT > 0
1067: THEN