DBA Data[Home] [Help]

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 2069: FROM iex_cu_sts_rl_lines rl, iex_cust_status_rules r

2065:
2066: CURSOR c_rule IS
2067: SELECT rl.delinquency_status, rl.priority,
2068: iex_utilities.get_lookup_meaning('IEX_DELINQUENCY_STATUS', rl.delinquency_status) meaning
2069: FROM iex_cu_sts_rl_lines rl, iex_cust_status_rules r
2070: WHERE rl.status_rule_id = l_status_rule_id
2071: AND r.status_rule_id = rl.status_rule_id
2072: AND trunc(sysdate) BETWEEN trunc(nvl(r.start_date,sysdate)) AND trunc(nvl(r.end_date,sysdate))
2073: AND NVL(rl.enabled_flag, 'N') = 'Y'