APPS.PSA_MFAR_VAL_PKG dependencies on RA_INTERFACE_LINES_GT

Line 664: FROM ra_interface_lines_gt L,

660: SELECT /*+ ORDERED */ nvl(L.INTERFACE_LINE_ID,0 ) ,
661: DECODE(B.TYPE ,'GUAR','Commitments Can not be Multi Fund Transactions Type',
662: 'CB' ,'Multi Fund TRansactions Can not be Charged Back' ,
663: 'CM' , 'On-Account Credit Can not use Multi Fund Transaction types')
664: FROM ra_interface_lines_gt L,
665: ra_cust_trx_types_all B,
666: psa_trx_types_all C
667: WHERE L.REQUEST_ID = l_request_id
668: AND L.cust_trx_type_id = B.cust_trx_type_id

Line 684: FROM RA_INTERFACE_LINES_GT L

680: (INTERFACE_LINE_ID,
681: MESSAGE_TEXT)
682: SELECT L.INTERFACE_LINE_ID,
683: 'Can not Assign Rules to Multi Fund Transactions'
684: FROM RA_INTERFACE_LINES_GT L
685: WHERE L.REQUEST_ID = l_request_id
686: AND ( L.INVOICING_RULE_ID IS NOT NULL
687: OR L.INVOICING_RULE_NAME IS NOT NULL )
688: AND exists

Line 705: FROM RA_INTERFACE_LINES_GT L

701: (INTERFACE_LINE_ID,
702: MESSAGE_TEXT)
703: SELECT nvl(L.INTERFACE_LINE_ID,0) ,
704: 'Transaction Currency Should be Equal to the GL Functional Currency'
705: FROM RA_INTERFACE_LINES_GT L
706: WHERE L.REQUEST_ID = l_request_id
707: AND exists
708: (SELECT 'X' FROM RA_CUST_TRX_TYPES_ALL B,
709: PSA_TRX_TYPES_ALL C

Line 732: FROM RA_INTERFACE_LINES_GT L

728: (INTERFACE_LINE_ID,
729: MESSAGE_TEXT )
730: SELECT nvl(L.INTERFACE_LINE_ID,0) ,
731: 'Can not Mark Multi Fund Transactions for Automatic Receipts '
732: FROM RA_INTERFACE_LINES_GT L
733: WHERE L.REQUEST_ID = l_request_id
734: AND exists
735: (SELECT 'X' FROM RA_CUST_TRX_TYPES_ALL B,
736: PSA_TRX_TYPES_ALL C

Line 761: FROM RA_INTERFACE_LINES_GT L

757: (INTERFACE_LINE_ID,
758: MESSAGE_TEXT)
759: SELECT nvl(L.INTERFACE_LINE_ID,0) ,
760: 'Can not Assign Commitments to Multi Fund Transactions'
761: FROM RA_INTERFACE_LINES_GT L
762: WHERE L.REQUEST_ID = l_request_id
763: AND exists
764: (SELECT 'X' FROM RA_CUST_TRX_TYPES_ALL B,
765: PSA_TRX_TYPES_ALL C

Line 786: FROM RA_INTERFACE_LINES_GT L

782: (INTERFACE_LINE_ID,
783: MESSAGE_TEXT)
784: SELECT nvl(L.INTERFACE_LINE_ID,0) ,
785: 'Credit Memo Profile Option must use Invoice Accounting for Multi Fund Transactions'
786: FROM RA_INTERFACE_LINES_GT L
787: WHERE L.REQUEST_ID = l_request_id
788: AND exists
789: (SELECT 'X' FROM RA_CUST_TRX_TYPES_ALL B,
790: PSA_TRX_TYPES_ALL C