DBA Data[Home] [Help]

APPS.AP_WEB_UPLOAD_PDM_PKG dependencies on DUAL

Line 350: from dual;

346: */
347:
348: select ap_pol_locations_s.nextval
349: into l_location_id
350: from dual;
351:
352: insert into AP_POL_LOCATIONS_B (
353: LOCATION_ID,
354: TERRITORY_CODE,

Line 754: from dual;

750: BEGIN
751:
752: select AP_POL_HEADERS_S.NEXTVAL
753: into l_policy_id
754: from dual;
755:
756: insert into AP_POL_HEADERS
757: (
758: POLICY_ID,

Line 852: from dual;

848: BEGIN
849:
850: select AP_POL_SCHEDULE_OPTIONS_S.NEXTVAL
851: into l_schedule_option_id
852: from dual;
853:
854: insert into AP_POL_SCHEDULE_OPTIONS
855: (
856: SCHEDULE_OPTION_ID,

Line 912: from dual;

908: BEGIN
909:
910: select AP_POL_SCHEDULE_PERIODS_S.NEXTVAL
911: into l_schedule_period_id
912: from dual;
913:
914: insert into AP_POL_SCHEDULE_PERIODS
915: (
916: SCHEDULE_PERIOD_ID,

Line 989: from dual;

985: BEGIN
986:
987: select AP_POL_LINES_S.NEXTVAL
988: into l_policy_line_id
989: from dual;
990:
991:
992: insert into AP_POL_LINES
993: (

Line 1133: from dual;

1129: BEGIN
1130:
1131: select AP_POL_LINES_S.NEXTVAL
1132: into l_night_rate_line_id
1133: from dual;
1134:
1135:
1136: insert into AP_POL_LINES
1137: (