APPS.OE_VERIFY_PAYMENT_PUB dependencies on OE_COMMITMENT_PVT

Line 6803: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN

6799:
6800: -- Select the committment applied amount
6801: BEGIN
6802: --pnpl added the Do_Commitment_Sequencing check
6803: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
6804: SELECT SUM(nvl(op.commitment_applied_amount,0))
6805: INTO l_commitment_applied
6806: FROM oe_payments op
6807: WHERE op.line_id = p_line_id

Line 7069: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN

7065: END IF;
7066:
7067: BEGIN
7068: --pnpl added the Do_Commitment_Sequencing check
7069: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
7070: -- Select the committment applied amount
7071: SELECT SUM(nvl(op.commitment_applied_amount,0))
7072: INTO l_commitment_applied
7073: FROM oe_payments op

Line 7291: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN

7287: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
7288: AND (mti.invoiceable_item_flag = 'N'
7289: OR mti.invoice_enabled_flag = 'N'));
7290:
7291: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
7292: -- Select the committment applied amount if Commitment Sequencing "On"
7293: SELECT SUM(ROUND(nvl(op.commitment_applied_amount,0),OE_ORDER_UTIL.G_Precision))
7294: INTO l_commitment_total
7295: FROM oe_payments op,