DBA Data[Home] [Help]

APPS.PSA_MFAR_RECEIPTS dependencies on DUAL

Line 820: from sys.dual;

816: -- different from the transaction AND when MFAR for the Trx has not been created through the other means.
817:
818: select psa_mF_error_log_s.currval
819: into run_num
820: from sys.dual;
821:
822: -- ========================= FND LOG ===========================
823: psa_utils.debug_other_string(g_state_level,l_full_path,' Creating distribution for Cust trx id ==> ' || run_num || ' -- ' || p_cust_trx_id);
824: -- ========================= FND LOG ===========================

Line 870: FROM DUAL

866: BEGIN
867:
868: SELECT 1
869: INTO l_zero_amt_flag
870: FROM DUAL
871: WHERE EXISTS (SELECT 1
872: FROM ra_customer_trx_lines_all
873: WHERE customer_trx_id = p_cust_trx_id
874: AND extended_amount <> 0 );

Line 1474: from sys.dual;

1470: -- different from the transaction AND when MFAR for the Trx has not been created through the other means.
1471:
1472: select psa_mF_error_log_s.currval
1473: into run_num
1474: from sys.dual;
1475:
1476: -- ========================= FND LOG ===========================
1477: psa_utils.debug_other_string(g_state_level,l_full_path,' Creating distribution for Cust trx id ==> ' || run_num || ' -- ' || p_cust_trx_id);
1478: -- ========================= FND LOG ===========================