APPS.IEX_CUST_OVERVIEW_PVT dependencies on IEX_CU_STS_RL_LINES

Line 113: FROM iex_cu_sts_rl_lines rl, iex_cust_status_rules r

109:
110: CURSOR c_rule IS
111: SELECT rl.delinquency_status, rl.priority,
112: iex_utilities.get_lookup_meaning('IEX_DELINQUENCY_STATUS', rl.delinquency_status) meaning
113: FROM iex_cu_sts_rl_lines rl, iex_cust_status_rules r
114: WHERE rl.status_rule_id = l_status_rule_id
115: AND r.status_rule_id = rl.status_rule_id
116: AND trunc(sysdate) BETWEEN trunc(nvl(r.start_date,sysdate)) AND trunc(nvl(r.end_date,sysdate))
117: AND NVL(rl.enabled_flag, 'N') = 'Y'

Line 1937: FROM iex_cu_sts_rl_lines rl, iex_cust_status_rules r

1933:
1934: CURSOR c_rule IS
1935: SELECT rl.delinquency_status, rl.priority,
1936: iex_utilities.get_lookup_meaning('IEX_DELINQUENCY_STATUS', rl.delinquency_status) meaning
1937: FROM iex_cu_sts_rl_lines rl, iex_cust_status_rules r
1938: WHERE rl.status_rule_id = l_status_rule_id
1939: AND r.status_rule_id = rl.status_rule_id
1940: AND trunc(sysdate) BETWEEN trunc(nvl(r.start_date,sysdate)) AND trunc(nvl(r.end_date,sysdate))
1941: AND NVL(rl.enabled_flag, 'N') = 'Y'