DBA Data[Home] [Help]

APPS.PN_INSURANCE_REQUIREMENTS_PKG dependencies on DUAL

Line 68: FROM DUAL;

64: IF x_insurance_requirement_id IS NULL THEN
65:
66: SELECT pn_insurance_requirements_s.NEXTVAL
67: INTO x_insurance_requirement_id
68: FROM DUAL;
69:
70: END IF;
71:
72: IF x_org_id IS NULL THEN

Line 437: FROM DUAL;

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
440: (
441: INSURANCE_HISTORY_ID,