APPS.IGIRRPI dependencies on RA_BATCH_SOURCES

Line 147: , ra_batch_sources bs

143: , sc.legal_entity_id
144: FROM gl_sets_of_books sob
145: , igi_rpi_standing_charges sc
146: , ar_system_parameters sp
147: , ra_batch_sources bs
148: , ra_cust_trx_types ct
149: , hz_cust_accounts ca
150: WHERE sp.set_of_books_id = cp_sob_id
151: AND sp.set_of_books_id = sob.set_of_books_id

Line 312: FROM ra_batch_sources

308:
309: FUNCTION UseSalesCreditsAtSource (p_source_id in number) return BOOLEAN IS
310: CURSOR c_batch_sources (cp_source_id in number) IS
311: SELECT 'x'
312: FROM ra_batch_sources
313: WHERE allow_sales_credit_flag = 'Y'
314: AND batch_source_id = cp_source_id
315: ;
316: BEGIN

Line 790: FROM ra_batch_sources

786: FUNCTION SalesCreditRuleAmt ( fp_batch_source_id in number) RETURN BOOLEAN
787: IS
788: CURSOR c_rule IS
789: SELECT 'x'
790: FROM ra_batch_sources
791: WHERE batch_source_id = fp_batch_source_id
792: AND upper(sales_credit_rule) = upper('Amount')
793: ;
794: BEGIN

Line 808: FROM ra_batch_sources

804: FUNCTION UseSalesCreditTypeValue ( fp_batch_source_id in number) RETURN BOOLEAN
805: IS
806: CURSOR c_typeid IS
807: SELECT 'x'
808: FROM ra_batch_sources
809: WHERE batch_source_id = fp_batch_source_id
810: AND upper(sales_credit_type_rule) = upper('Value')
811: ;
812: BEGIN

Line 826: FROM ra_batch_sources

822: FUNCTION UseSalesRepNumber ( fp_batch_source_id in number) RETURN BOOLEAN
823: IS
824: CURSOR c_repid IS
825: SELECT 'x'
826: FROM ra_batch_sources
827: WHERE batch_source_id = fp_batch_source_id
828: AND upper(salesperson_rule) = upper('Number')
829: ;
830: BEGIN