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,