APPS.IEX_DUNNING_PVT dependencies on AR_AGING_BUCKETS

Line 3023: ar_aging_buckets ar,

3019: x.fm_method,
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

Line 3768: ar_aging_buckets ar,

3764: upper(x.callback_flag),
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

Line 4419: ar_aging_buckets ar,

4415: x.fm_method,
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

Line 5113: ar_aging_buckets ar,

5109: upper(x.callback_flag),
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

Line 5772: ar_aging_buckets b,

5768:
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