371: AND ppp.MULTIPLE_COMPONENTS = 'Y';
372:
373: CURSOR change_amount_cur is
374: Select CHANGE_AMOUNT
375: From per_pay_proposal_components pppc
376: where pppc.pay_proposal_id = p_pay_proposal_id;
377:
378: l_change_amount per_pay_proposal_components.change_amount%Type;
379: l_multiple_comp number;
374: Select CHANGE_AMOUNT
375: From per_pay_proposal_components pppc
376: where pppc.pay_proposal_id = p_pay_proposal_id;
377:
378: l_change_amount per_pay_proposal_components.change_amount%Type;
379: l_multiple_comp number;
380: BEGIN
381: IF p_pay_proposal_id is not null then
382: OPEN is_multiple_comp;
405: AND ppp.MULTIPLE_COMPONENTS = 'Y';
406:
407: CURSOR change_percent_cur is
408: Select CHANGE_PERCENTAGE
409: From per_pay_proposal_components pppc
410: where pppc.pay_proposal_id = p_pay_proposal_id;
411:
412: l_change_percent per_pay_proposal_components.change_percentage%Type;
413: l_multiple_comp number;
408: Select CHANGE_PERCENTAGE
409: From per_pay_proposal_components pppc
410: where pppc.pay_proposal_id = p_pay_proposal_id;
411:
412: l_change_percent per_pay_proposal_components.change_percentage%Type;
413: l_multiple_comp number;
414: BEGIN
415: IF p_pay_proposal_id is not null then
416: OPEN is_multiple_comp;