DBA Data[Home] [Help]

APPS.AP_APXT7CMT_XMLP_PKG dependencies on AP_INCOME_TAX_REGIONS

Line 357: AP_INCOME_TAX_REGIONS ITR

353: SELECT
354: TD.ROWID
355: FROM
356: AP_1099_TAPE_DATA TD,
357: AP_INCOME_TAX_REGIONS ITR
358: WHERE ITR.REGION_CODE = TD.REGION_CODE
359: AND NVL(ITR.INACTIVE_DATE
360: ,TO_DATE(P_END_YEAR_DATE
361: ,'DD-MON-RR') + 1) > TO_DATE(P_END_YEAR_DATE

Line 450: AP_INCOME_TAX_REGIONS

446:
447: FUNCTION CLEAR_REGION_TOTALS RETURN BOOLEAN IS
448: BEGIN
449: UPDATE
450: AP_INCOME_TAX_REGIONS
451: SET
452: CONTROL_TOTAL1 = 0
453: ,CONTROL_TOTAL2 = 0
454: ,CONTROL_TOTAL3 = 0

Line 523: AP_INCOME_TAX_REGIONS

519: L_STATE_TOTAL9,L_STATE_TOTAL10,L_STATE_TOTAL13,L_STATE_TOTAL14,L_STATE_TOTAL15A,L_STATE_TOTAL15B,
520: L_STATE_NUM_OF_PAYEES,L_REGION_CODE_NUM;
521: EXIT WHEN DETERMINE_STATE_TOTALS%NOTFOUND;
522: UPDATE
523: AP_INCOME_TAX_REGIONS
524: SET
525: CONTROL_TOTAL1 = L_STATE_TOTAL1
526: ,CONTROL_TOTAL2 = L_STATE_TOTAL2
527: ,CONTROL_TOTAL3 = L_STATE_TOTAL3