DBA Data[Home] [Help]

APPS.AMS_TCOP_PREVIEW dependencies on AMS_TCOP_PRVW_FATIGUE_S

Line 1318: -- Get Nextval from AMS_TCOP_PRVW_FATIGUE_S

1314: AND PREVIEW_ID = G_PRVW_REQUEST_ID
1315: AND rownum = p_row_num
1316: ORDER BY CONTACT.CONTACT_DATE;
1317:
1318: -- Get Nextval from AMS_TCOP_PRVW_FATIGUE_S
1319: CURSOR C_GET_NEXT_FATIGUE
1320: IS
1321: SELECT AMS_TCOP_PRVW_FATIGUE_S.NEXTVAL
1322: FROM DUAL;

Line 1321: SELECT AMS_TCOP_PRVW_FATIGUE_S.NEXTVAL

1317:
1318: -- Get Nextval from AMS_TCOP_PRVW_FATIGUE_S
1319: CURSOR C_GET_NEXT_FATIGUE
1320: IS
1321: SELECT AMS_TCOP_PRVW_FATIGUE_S.NEXTVAL
1322: FROM DUAL;
1323:
1324: CURSOR C_GET_NEXT_FTG_DTL
1325: IS

Line 2041: -- Get the next val from AMS_TCOP_PRVW_FATIGUE_S

2037: END IF;
2038:
2039: END LOOP;
2040:
2041: -- Get the next val from AMS_TCOP_PRVW_FATIGUE_S
2042: OPEN C_GET_NEXT_FATIGUE;
2043: FETCH C_GET_NEXT_FATIGUE
2044: INTO l_preview_id;
2045: CLOSE C_GET_NEXT_FATIGUE;