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.

APPS.IEX_DUNNING_PVT dependencies on IEX_DUNNING_PLANS_VL

Line 3003: , IEX_DUNNING_PLANS_VL c -- bug 4914799 ctlee 12/30/2005

2999: -- begin bug 4914799 ctlee 12/30/2005 add p_dunning_plan_id
3000: CURSOR C_GET_SCORE (IN_ID NUMBER, IN_CODE VARCHAR2, p_dunning_plan_id number) IS
3001: SELECT a.score_value
3002: FROM IEX_SCORE_HISTORIES a
3003: , IEX_DUNNING_PLANS_VL c -- bug 4914799 ctlee 12/30/2005
3004: WHERE a.score_object_ID = in_ID
3005: AND a.score_object_code = IN_CODE
3006: and c.score_id = a.score_id -- bug 4914799 ctlee 12/30/2005
3007: and c.dunning_plan_id = p_dunning_plan_id -- bug 4914799 ctlee 12/30/2005

Line 3024: iex_dunning_plans_vl d

3020: upper(x.callback_flag),
3021: x.callback_days
3022: FROM IEX_AG_DN_XREF x,
3023: ar_aging_buckets ar,
3024: iex_dunning_plans_vl d
3025: WHERE x.aging_bucket_line_ID = l_line_ID
3026: and x.dunning_plan_id = p_dunning_plan_id
3027: AND l_score between x.score_range_low and x.score_range_high
3028: AND x.aging_bucket_id = ar.aging_bucket_id

Line 3769: iex_dunning_plans_vl d

3765: x.callback_days,
3766: ar.bucket_name
3767: FROM IEX_AG_DN_XREF x,
3768: ar_aging_buckets ar,
3769: iex_dunning_plans_vl d
3770: WHERE x.aging_bucket_line_ID = l_line_ID
3771: and x.dunning_plan_id = p_dunning_plan_id
3772: AND l_score between x.score_range_low and x.score_range_high
3773: AND x.aging_bucket_id = ar.aging_bucket_id

Line 4400: , IEX_DUNNING_PLANS_VL c -- bug 4914799 ctlee 12/30/2005

4396: -- begin bug 4914799 ctlee 12/30/2005 add p_dunning_plan_id
4397: CURSOR C_GET_SCORE (IN_ID NUMBER, IN_CODE VARCHAR2, p_dunning_plan_id number) IS
4398: SELECT a.score_value
4399: FROM IEX_SCORE_HISTORIES a
4400: , IEX_DUNNING_PLANS_VL c -- bug 4914799 ctlee 12/30/2005
4401: WHERE a.score_object_ID = in_ID
4402: AND a.score_object_code = IN_CODE
4403: and c.score_id = a.score_id -- bug 4914799 ctlee 12/30/2005
4404: and c.dunning_plan_id = p_dunning_plan_id -- bug 4914799 ctlee 12/30/2005

Line 4420: iex_dunning_plans_vl d

4416: upper(x.callback_flag),
4417: x.callback_days
4418: FROM IEX_AG_DN_XREF x,
4419: ar_aging_buckets ar,
4420: iex_dunning_plans_vl d
4421: WHERE x.aging_bucket_line_ID = l_line_ID
4422: and x.dunning_plan_id = p_dunning_plan_id
4423: AND l_score between x.score_range_low and x.score_range_high
4424: AND x.aging_bucket_id = ar.aging_bucket_id

Line 5114: iex_dunning_plans_vl d

5110: x.callback_days,
5111: ar.bucket_name
5112: FROM IEX_AG_DN_XREF x,
5113: ar_aging_buckets ar,
5114: iex_dunning_plans_vl d
5115: WHERE x.aging_bucket_line_ID = l_line_ID
5116: and x.dunning_plan_id = p_dunning_plan_id
5117: AND l_score between x.score_range_low and x.score_range_high
5118: AND x.aging_bucket_id = ar.aging_bucket_id

Line 5773: iex_dunning_plans_vl d

5769: CURSOR C_GET_BUCKET_LINE (IN_DAYS NUMBER, p_dunning_plan_id number) IS
5770: SELECT l.aging_bucket_line_id
5771: FROM ar_aging_bucket_lines l,
5772: ar_aging_buckets b,
5773: iex_dunning_plans_vl d
5774: WHERE d.dunning_plan_id = p_dunning_plan_id
5775: and d.aging_bucket_id = b.aging_bucket_id
5776: and b.aging_bucket_id = l.aging_bucket_id
5777: AND round(IN_DAYS) between l.days_start and l.days_to