APPS.IEX_PROFILE dependencies on HZ_CUST_PROFILE_AMTS

Line 518: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt

514: -- DECODE(MAX(DECODE(prof.dunning_letters, 'Y', 1, 0)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N')),
515: NULL,
516: NULL, -- end for bug 13583293 by sunagesh
517: g_curr_rec.base_currency
518: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt
519: -- ar_cmgt_setup_options cm_opt
520: WHERE prof.party_id = p_party_id
521: AND prof.site_use_id IS NULL
522: AND prof.status = 'A'

Line 548: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt

544: -- DECODE(MAX(DECODE(prof.dunning_letters, 'Y', 1, 0)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N')),
545: NULL,
546: NULL, -- end for bug 13583293 by sunagesh
547: g_curr_rec.base_currency
548: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt
549: -- ar_cmgt_setup_options cm_opt
550: WHERE prof.cust_account_id = p_cust_account_id
551: AND prof.site_use_id IS NULL
552: AND prof.status = 'A'

Line 575: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt

571: --DECODE(MAX(DECODE(prof.dunning_letters, 'Y', 1, 0)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N')),
572: NULL,
573: NULL, -- end for bug 13583293 by sunagesh
574: g_curr_rec.base_currency
575: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt
576: -- ar_cmgt_setup_options cm_opt
577: WHERE prof.site_use_id = p_customer_site_use_id
578: AND prof.status = 'A'
579: -- Begin fix bug #5194537-JYPARK-05/03/2006-add outer join when credit limit not exist