DBA Data[Home] [Help]

APPS.AP_WEB_POLICY_UTILS dependencies on AP_POL_LINES_HISTORY

Line 3685: insert into AP_POL_LINES_HISTORY

3681:
3682: ---------------------------------------
3683: -- archive preserved Active policy lines
3684: ---------------------------------------
3685: insert into AP_POL_LINES_HISTORY
3686: (
3687: POLICY_LINE_HISTORY_ID,
3688: POLICY_LINE_ID,
3689: SCHEDULE_PERIOD_ID,

Line 3690: --CURRENCY_CODE, -- need to add CURRENCY_CODE to AP_POL_LINES_HISTORY because of LCR

3686: (
3687: POLICY_LINE_HISTORY_ID,
3688: POLICY_LINE_ID,
3689: SCHEDULE_PERIOD_ID,
3690: --CURRENCY_CODE, -- need to add CURRENCY_CODE to AP_POL_LINES_HISTORY because of LCR
3691: MEAL_LIMIT,
3692: RATE,
3693: TOLERANCE,
3694: TICKET_CLASS_DOMESTIC,

Line 3716: AP_POL_LINES_HISTORY_S.NEXTVAL AS POLICY_LINE_HISTORY_ID,

3712: LAST_UPDATE_DATE,
3713: LAST_UPDATED_BY
3714: )
3715: select
3716: AP_POL_LINES_HISTORY_S.NEXTVAL AS POLICY_LINE_HISTORY_ID,
3717: PARENT_LINE_ID AS POLICY_LINE_ID,
3718: SCHEDULE_PERIOD_ID,
3719: --CURRENCY_CODE,
3720: MEAL_LIMIT,