DBA Data[Home] [Help]

APPS.IEX_DUNNING_PUB dependencies on IEX_SCORES

Line 533: ,iex_scores sc

529: cursor c_scoring_engine(p_dunning_plan_id number) is
530: select sc.score_id
531: ,sc.score_name
532: from iex_dunning_plans_vl d
533: ,iex_scores sc
534: where d.dunning_plan_id = p_dunning_plan_id
535: and sc.score_id = d.score_id;
536:
537: l_score_engine_id number;

Line 542: from IEX_OBJECT_FILTERS iof,iex_dunning_plans_vl ipd, IEX_SCORES isc

538: l_score_engine_name varchar2(60);
539: --Start bug 7197038 gnramasa 9th july 08
540: cursor c_filter_object(p_dunning_plan_id number) is
541: select iof.select_column, iof.entity_name
542: from IEX_OBJECT_FILTERS iof,iex_dunning_plans_vl ipd, IEX_SCORES isc
543: where ipd.dunning_plan_id = p_dunning_plan_id
544: and ipd.score_id=isc.score_id
545: and isc.score_id=iof.object_id;
546: