eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IEX_DUNNING_PUB dependencies on IEX_DELINQUENCIES

Line 408: FROM IEX_DELINQUENCIES

404: Party_cust_id,
405: cust_account_id,
406: customer_site_use_id,
407: score_value
408: FROM IEX_DELINQUENCIES
409: , iex_dunning_plans_vl
410: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
411: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id
412: and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id;

Line 412: and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id;

408: FROM IEX_DELINQUENCIES
409: , iex_dunning_plans_vl
410: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
411: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id
412: and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id;
413: --AND DUNN_YN = 'Y';
414: --
415: -- Changed by gnramasa for bug 5661324 14-Mar-07
416: /* CURSOR C_GET_CUSTOMER (p_dunning_plan_id number) IS

Line 418: FROM IEX_DELINQUENCIES

414: --
415: -- Changed by gnramasa for bug 5661324 14-Mar-07
416: /* CURSOR C_GET_CUSTOMER (p_dunning_plan_id number) IS
417: SELECT distinct party_cust_id
418: FROM IEX_DELINQUENCIES
419: , iex_dunning_plans_vl
420: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
421: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id
422: -- begin bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency

Line 423: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id

419: , iex_dunning_plans_vl
420: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
421: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id
422: -- begin bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
423: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id
424: -- end bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
425: --AND DUNN_YN = 'Y'
426: order by party_cust_id;
427: --

Line 430: FROM IEX_DELINQUENCIES

426: order by party_cust_id;
427: --
428: CURSOR C_GET_CUSTOMER_DEL( in_party_id NUMBER, p_dunning_plan_id number) IS
429: SELECT party_cust_id, cust_account_id, customer_site_use_id, delinquency_ID
430: FROM IEX_DELINQUENCIES
431: , iex_dunning_plans_vl
432: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
433: AND party_cust_id = in_party_id
434: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id

Line 436: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id

432: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
433: AND party_cust_id = in_party_id
434: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id
435: -- begin bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
436: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id
437: -- end bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
438: --AND DUNN_YN = 'Y'
439: ORDER BY cust_account_id, delinquency_id;
440: --

Line 443: FROM IEX_DELINQUENCIES

439: ORDER BY cust_account_id, delinquency_id;
440: --
441: CURSOR C_GET_ACCOUNT (p_dunning_plan_id number) IS
442: SELECT distinct cust_account_id
443: FROM IEX_DELINQUENCIES
444: , iex_dunning_plans_vl
445: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
446: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id
447: -- begin bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency

Line 448: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id

444: , iex_dunning_plans_vl
445: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
446: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id
447: -- begin bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
448: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id
449: -- end bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
450: --AND DUNN_YN = 'Y'
451: ORDER BY cust_account_id;
452: --

Line 455: FROM IEX_DELINQUENCIES

451: ORDER BY cust_account_id;
452: --
453: CURSOR C_GET_ACCOUNT_DEL(IN_ACCOUNT_ID NUMBER, p_dunning_plan_id number) IS
454: SELECT party_cust_id, cust_account_id, customer_site_use_id, delinquency_ID
455: FROM IEX_DELINQUENCIES
456: , iex_dunning_plans_vl
457: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
458: --AND DUNN_YN = 'Y'
459: AND cust_account_id = in_account_id

Line 462: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id

458: --AND DUNN_YN = 'Y'
459: AND cust_account_id = in_account_id
460: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id
461: -- begin bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
462: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id
463: -- end bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
464: ORDER BY cust_account_id, delinquency_id;
465: --
466: CURSOR C_GET_SITE (p_dunning_plan_id number) IS

Line 468: FROM IEX_DELINQUENCIES

464: ORDER BY cust_account_id, delinquency_id;
465: --
466: CURSOR C_GET_SITE (p_dunning_plan_id number) IS
467: SELECT distinct customer_site_use_id
468: FROM IEX_DELINQUENCIES
469: , iex_dunning_plans_vl
470: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
471: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id
472: -- begin bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency

Line 473: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id

469: , iex_dunning_plans_vl
470: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
471: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id
472: -- begin bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
473: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id
474: -- end bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
475: ORDER BY customer_site_use_id;
476: --
477: CURSOR C_GET_SITE_DEL(IN_SITE_ID NUMBER, p_dunning_plan_id number) IS

Line 479: FROM IEX_DELINQUENCIES

475: ORDER BY customer_site_use_id;
476: --
477: CURSOR C_GET_SITE_DEL(IN_SITE_ID NUMBER, p_dunning_plan_id number) IS
478: SELECT party_cust_id, cust_account_id, customer_site_use_id,delinquency_ID
479: FROM IEX_DELINQUENCIES
480: , iex_dunning_plans_vl
481: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
482: AND customer_site_use_id = in_site_id
483: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id

Line 485: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id

481: WHERE STATUS in ('DELINQUENT', 'PREDELINQUENT')
482: AND customer_site_use_id = in_site_id
483: and iex_dunning_plans_vl.dunning_plan_id = p_dunning_plan_id
484: -- begin bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
485: -- and iex_delinquencies.score_id = iex_dunning_plans_vl.score_id
486: -- end bug 4914799 ctlee 12/30/2005, party/account/site level dunning does not have score in delinquency
487: ORDER BY customer_site_use_id, delinquency_id;
488: */
489: --

Line 1062: ' FROM IEX_DELINQUENCIES del' ||

1058: vPLSQL2 := 'SELECT party_cust_id ' ||
1059: ' ,cust_account_id ' ||
1060: ' ,customer_site_use_id ' ||
1061: ' ,delinquency_ID ' ||
1062: ' FROM IEX_DELINQUENCIES del' ||
1063: ' ,iex_dunning_plans_vl ' ||
1064: ' WHERE STATUS in (''DELINQUENT'', ''PREDELINQUENT'') ' ||
1065: ' AND DELINQUENCY_ID = :1 ' ||
1066: ' AND iex_dunning_plans_vl.dunning_plan_id = :p_dunning_plan_id and' ||

Line 1072: -- fetch the party/account/site_use/delinquency from iex_delinquencies table

1068:
1069: --'ORDER BY ' || vSelectColumn || ' ,delinquency_id';
1070: end if;
1071:
1072: -- fetch the party/account/site_use/delinquency from iex_delinquencies table
1073: if p_previous_request_id is null then
1074: vPLSQL := ' SELECT distinct ' || vSelectColumn ||
1075: ' FROM IEX_DELINQUENCIES ' ||
1076: ', IEX_DUNNING_PLANS_VL '||

Line 1075: ' FROM IEX_DELINQUENCIES ' ||

1071:
1072: -- fetch the party/account/site_use/delinquency from iex_delinquencies table
1073: if p_previous_request_id is null then
1074: vPLSQL := ' SELECT distinct ' || vSelectColumn ||
1075: ' FROM IEX_DELINQUENCIES ' ||
1076: ', IEX_DUNNING_PLANS_VL '||
1077: ' WHERE STATUS in (''DELINQUENT'', ''PREDELINQUENT'') ' ||
1078: ' AND iex_dunning_plans_vl.dunning_plan_id = :p_dunning_plan_id ' ||
1079: ' order by ' || vSelectColumn;