[Home] [Help]
917: END LOOP; -- FOR expenditure_types_r IN sel_expenditure_types
918:
919: SELECT COUNT(*)
920: INTO x_count
921: From PA_ALL_EXP_TYPES_IT;
922:
923: IF x_count = 0
924: Then
925: INSERT INTO PA_ALL_EXP_TYPES_IT
921: From PA_ALL_EXP_TYPES_IT;
922:
923: IF x_count = 0
924: Then
925: INSERT INTO PA_ALL_EXP_TYPES_IT
926: (
927: ALL_EXPENDITURE_TYPES,
928: LAST_UPDATE_DATE,
929: LAST_UPDATED_BY,