DBA Data[Home] [Help]

APPS.PN_INSURANCE_REQUIREMENTS_PKG dependencies on PN_INSUR_REQUIRE_HISTORY

Line 435: SELECT pn_insur_require_history_s.NEXTVAL

431: CLOSE c2;
432:
433: IF (recInfoForHist.LEASE_CHANGE_ID <> X_LEASE_CHANGE_ID) THEN
434:
435: SELECT pn_insur_require_history_s.NEXTVAL
436: INTO l_insuranceHistoryId
437: FROM DUAL;
438:
439: INSERT INTO PN_INSUR_REQUIRE_HISTORY

Line 439: INSERT INTO PN_INSUR_REQUIRE_HISTORY

435: SELECT pn_insur_require_history_s.NEXTVAL
436: INTO l_insuranceHistoryId
437: FROM DUAL;
438:
439: INSERT INTO PN_INSUR_REQUIRE_HISTORY
440: (
441: INSURANCE_HISTORY_ID,
442: INSURANCE_TYPE_LOOKUP_CODE,
443: LEASE_ID,