305: if c.p31 is null then
306: L_BALANCE_TYPE_ID:=nn;
307: else
308: L_BALANCE_TYPE_ID :=
309: PAY_BALANCE_TYPES_DATA_PUMP.get_balance_type_id
310: (P_BALANCE_TYPE_USER_KEY => c.p31);
311: end if;
312: --
313: if c.p31 is null then
313: if c.p31 is null then
314: L_OBJECT_VERSION_NUMBER:=nn;
315: else
316: L_OBJECT_VERSION_NUMBER :=
317: PAY_BALANCE_TYPES_DATA_PUMP.GET_BALANCE_TYPE_OVN
318: (P_BALANCE_TYPE_USER_KEY => c.p31);
319: end if;
320: --
321: if c.p1 is null or
324: elsif c.d32 is null then
325: L_BALANCE_CATEGORY_ID:=nh;
326: else
327: L_BALANCE_CATEGORY_ID :=
328: PAY_BALANCE_TYPES_DATA_PUMP.GET_BALANCE_CATEGORY_ID
329: (P_EFFECTIVE_DATE => c.p1
330: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
331: ,P_CATEGORY_NAME => c.p32);
332: end if;
336: elsif c.d33 is null then
337: L_BASE_BALANCE_TYPE_ID:=nh;
338: else
339: L_BASE_BALANCE_TYPE_ID :=
340: PAY_BALANCE_TYPES_DATA_PUMP.GET_BASE_BALANCE_TYPE_ID
341: (P_BASE_BALANCE_NAME => c.p33
342: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
343: end if;
344: --
352: c.d2 is null then
353: L_INPUT_VALUE_ID:=nh;
354: else
355: L_INPUT_VALUE_ID :=
356: PAY_BALANCE_TYPES_DATA_PUMP.GET_INPUT_VALUE_ID
357: (P_ELEMENT_NAME => c.p34
358: ,P_INPUT_NAME => c.p35
359: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
360: ,P_EFFECTIVE_DATE => c.p1