DBA Data[Home] [Help]

APPS.AP_WEB_POLICY_UTILS dependencies on AP_POL_LINES_HISTORY

Line 3741: insert into AP_POL_LINES_HISTORY

3737:
3738: ---------------------------------------
3739: -- archive preserved Active policy lines
3740: ---------------------------------------
3741: insert into AP_POL_LINES_HISTORY
3742: (
3743: POLICY_LINE_HISTORY_ID,
3744: POLICY_LINE_ID,
3745: SCHEDULE_PERIOD_ID,

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

3742: (
3743: POLICY_LINE_HISTORY_ID,
3744: POLICY_LINE_ID,
3745: SCHEDULE_PERIOD_ID,
3746: --CURRENCY_CODE, -- need to add CURRENCY_CODE to AP_POL_LINES_HISTORY because of LCR
3747: MEAL_LIMIT,
3748: RATE,
3749: TOLERANCE,
3750: TICKET_CLASS_DOMESTIC,

Line 3774: AP_POL_LINES_HISTORY_S.NEXTVAL AS POLICY_LINE_HISTORY_ID,

3770: REIMBURSEMENT_PERCENTAGE,
3771: MAX_RECEIPT_AMT
3772: )
3773: select
3774: AP_POL_LINES_HISTORY_S.NEXTVAL AS POLICY_LINE_HISTORY_ID,
3775: PARENT_LINE_ID AS POLICY_LINE_ID,
3776: SCHEDULE_PERIOD_ID,
3777: --CURRENCY_CODE,
3778: MEAL_LIMIT,