DBA Data[Home] [Help]

APPS.PQH_SS_PRINT dependencies on PER_PAY_PROPOSAL_COMPONENTS

Line 375: From per_pay_proposal_components pppc

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;

Line 378: l_change_amount per_pay_proposal_components.change_amount%Type;

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;

Line 409: From per_pay_proposal_components pppc

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;

Line 412: l_change_percent per_pay_proposal_components.change_percentage%Type;

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;