6922: order by creation_date desc;
6923:
6924: cursor c_del_object_type(p_dunn_plan_id number) is
6925: select isc.jtf_object_code
6926: from iex_dunning_plans_vl ipd, IEX_SCORES isc
6927: where ipd.dunning_plan_id = p_dunn_plan_id
6928: and ipd.score_id=isc.score_id;
6929:
6930: l_del_object_type varchar2(50);
7968: order by creation_date desc;
7969:
7970: cursor c_del_object_type(p_dunn_plan_id number) is
7971: select isc.jtf_object_code
7972: from iex_dunning_plans_vl ipd, IEX_SCORES isc
7973: where ipd.dunning_plan_id = p_dunn_plan_id
7974: and ipd.score_id=isc.score_id;
7975:
7976: l_del_object_type varchar2(50);