DBA Data[Home] [Help]

APPS.AMV_MATCH_PVT dependencies on DUAL

Line 1686: from dual;

1682: CURSOR Get_IdAndDate_csr IS
1683: select
1684: AMV_C_CHL_ITEM_MATCH_S.nextval,
1685: sysdate
1686: from dual;
1687: --
1688: CURSOR Get_Resourceid_csr IS
1689: select owner_id
1690: from jtf_amv_items_b

Line 2031: from dual;

2027: CURSOR Get_IdAndDate_csr IS
2028: select
2029: AMV_C_CHL_ITEM_MATCH_S.nextval,
2030: sysdate
2031: from dual;
2032: --
2033: BEGIN
2034: SAVEPOINT Do_ItemChannelMatch_Pvt;
2035: IF NOT FND_API.Compatible_API_Call (

Line 2406: from dual;

2402: CURSOR Get_IdAndDate_csr IS
2403: select
2404: AMV_C_CHL_ITEM_MATCH_S.nextval,
2405: sysdate
2406: from dual;
2407: --
2408: BEGIN
2409: SAVEPOINT Remove_ItemChannelMatch_PVT;
2410: IF NOT FND_API.Compatible_API_Call (