APPS.IEX_COLL_IND dependencies on AR_SYSTEM_PARAMETERS

Line 602: FROM ar_system_parameters sp,

598: 0) )
599: )
600: ), 0) /* DSO */
601: INTO l_conv_dso
602: FROM ar_system_parameters sp,
603: hz_cust_accounts cust_acct,
604: ar_payment_schedules ps
605: WHERE ps.customer_id = cust_acct.cust_account_id
606: AND cust_acct.party_id = p_party_id

Line 645: FROM ar_system_parameters sp,

641: 0) )
642: )
643: ), 0) /* DSO */
644: INTO l_conv_dso
645: FROM ar_system_parameters sp,
646: ar_payment_schedules ps
647: WHERE ps.customer_id = p_cust_account_id
648: -- Begin fix bug #5261855-jypark-06/16/2006-add addtional condition for performance
649: AND ps.status = 'OP'

Line 687: FROM ar_system_parameters sp,

683: 0) )
684: )
685: ), 0) /* DSO */
686: INTO l_conv_dso
687: FROM ar_system_parameters sp,
688: ar_payment_schedules ps
689: WHERE ps.customer_site_use_id = p_customer_site_use_id
690: -- Begin fix bug #5261855-jypark-06/16/2006-add addtional condition for performance
691: AND ps.status = 'OP'

Line 1488: FROM ar_system_parameters sysp,

1484: c.minimum_accountable_unit
1485: INTO g_curr_rec.base_currency,
1486: g_curr_rec.base_precision,
1487: g_curr_rec.base_min_acc_unit
1488: FROM ar_system_parameters sysp,
1489: gl_sets_of_books sob,
1490: fnd_currencies c
1491: WHERE sob.set_of_books_id = sysp.set_of_books_id
1492: AND sob.currency_code = c.currency_code;