DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_DIMENSIONS dependencies on PA_EXP_TYPES_IT

Line 813: PA_EXP_TYPES_IT

809:
810: -- First Try to Update the Row in the Interface Table
811:
812: UPDATE
813: PA_EXP_TYPES_IT
814: SET
815: ALL_EXPENDITURE_TYPES = EXPENDITURE_TYPES_R.ALL_EXPENDITURE_TYPES,
816: EXPENDITURE_CATEGORY = EXPENDITURE_TYPES_R.EXPENDITURE_CATEGORY,
817: REVENUE_CATEGORY_CODE = EXPENDITURE_TYPES_R.REVENUE_CATEGORY_CODE,

Line 847: INSERT INTO PA_EXP_TYPES_IT

843: -- Check If Any row was updated
844:
845: IF (SQL%ROWCOUNT = 0) THEN
846: -- No row was updated, So Insert a new row into the interface table
847: INSERT INTO PA_EXP_TYPES_IT
848: (
849: EXPENDITURE_TYPE,
850: ALL_EXPENDITURE_TYPES,
851: EXPENDITURE_CATEGORY,