DBA Data[Home] [Help]

APPS.AP_ACCTG_PAY_DIST_PKG dependencies on DUAL

Line 772: FROM dual

768: AND l_final_payment = TRUE) THEN
769: BEGIN
770: SELECT 'N'
771: INTO l_exec_final_pay
772: FROM dual
773: WHERE EXISTS(
774: SELECT 'Unreversed clearing txns with different xrates'
775: FROM ap_payment_history_all aph,
776: ap_invoice_payments_all aip

Line 3223: FROM sys.dual;

3219: ,0
3220: )
3221: )
3222: INTO l_inv_dist_amount
3223: FROM sys.dual;
3224:
3225: END IF;
3226:
3227: l_prorated_amount := GL_Currency_API.Convert_Amount(

Line 3414: FROM sys.dual;

3410: ,0
3411: )
3412: )
3413: INTO l_inv_dist_amount
3414: FROM sys.dual;
3415:
3416: --Need to recalculate the l_inv_dist_amount as the difference between the amount to be prorated for the
3417: -- distribution and the already prorated amount
3418:

Line 5106: FROM dual

5102: l_reversed_in_R12 := 'N';
5103:
5104: SELECT 'Y'
5105: INTO l_reversed_in_R12
5106: FROM dual
5107: WHERE EXISTS
5108: (SELECT 'reversed in R12'
5109: FROM ap_payment_history_all aph,
5110: xla_ae_headers xah,