APPS.OE_VERIFY_PAYMENT_PUB dependencies on OE_COMMITMENT_PVT

Line 7428: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN

7424:
7425: -- Select the committment applied amount
7426: BEGIN
7427: --pnpl added the Do_Commitment_Sequencing check
7428: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
7429: SELECT SUM(nvl(op.commitment_applied_amount,0))
7430: INTO l_commitment_applied
7431: FROM oe_payments op
7432: WHERE op.line_id = p_line_id

Line 7702: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN

7698: END IF;
7699:
7700: BEGIN
7701: --pnpl added the Do_Commitment_Sequencing check
7702: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
7703: -- Select the committment applied amount
7704: SELECT SUM(nvl(op.commitment_applied_amount,0))
7705: INTO l_commitment_applied
7706: FROM oe_payments op

Line 7930: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN

7926: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
7927: AND (mti.invoiceable_item_flag = 'N'
7928: OR mti.invoice_enabled_flag = 'N'));
7929:
7930: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
7931: -- Select the committment applied amount if Commitment Sequencing "On"
7932: SELECT SUM(ROUND(nvl(op.commitment_applied_amount,0),OE_ORDER_UTIL.G_Precision))
7933: INTO l_commitment_total
7934: FROM oe_payments op,