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 775: from dual;

771: BEGIN
772:
773: select AP_POL_HEADERS_S.NEXTVAL
774: into l_policy_id
775: from dual;
776:
777: insert into AP_POL_HEADERS
778: (
779: POLICY_ID,

Line 873: from dual;

869: BEGIN
870:
871: select AP_POL_SCHEDULE_OPTIONS_S.NEXTVAL
872: into l_schedule_option_id
873: from dual;
874:
875: insert into AP_POL_SCHEDULE_OPTIONS
876: (
877: SCHEDULE_OPTION_ID,

Line 933: from dual;

929: BEGIN
930:
931: select AP_POL_SCHEDULE_PERIODS_S.NEXTVAL
932: into l_schedule_period_id
933: from dual;
934:
935: insert into AP_POL_SCHEDULE_PERIODS
936: (
937: SCHEDULE_PERIOD_ID,

Line 1010: from dual;

1006: BEGIN
1007:
1008: select AP_POL_LINES_S.NEXTVAL
1009: into l_policy_line_id
1010: from dual;
1011:
1012:
1013: insert into AP_POL_LINES
1014: (

Line 1155: from dual;

1151: BEGIN
1152:
1153: select AP_POL_LINES_S.NEXTVAL
1154: into l_night_rate_line_id
1155: from dual;
1156:
1157:
1158: insert into AP_POL_LINES
1159: (