APPS.LNS_LOAN_PUB dependencies on LNS_INT_RATE_HEADERS

Line 1208: FROM lns_int_rate_headers lirh

1204: IF P_Loan_Details_Rec.index_rate_id IS NOT NULL THEN
1205: BEGIN
1206: SELECT 'Y'
1207: INTO l_dummy
1208: FROM lns_int_rate_headers lirh
1209: WHERE lirh.interest_rate_id = P_Loan_Details_Rec.index_rate_id;
1210: EXCEPTION
1211: WHEN NO_DATA_FOUND THEN
1212: LogErrors(p_message_name=>'LNS_LCREATE_INVALID_ATTRIBUTE'

Line 2325: FROM lns_int_rate_headers hdr,

2321:
2322: BEGIN
2323: SELECT line.interest_rate
2324: INTO l_num_temp
2325: FROM lns_int_rate_headers hdr,
2326: lns_int_rate_lines line
2327: WHERE hdr.interest_rate_id = line.interest_rate_id
2328: AND(p_loan_rates_tbl(l_count).index_date BETWEEN line.start_date_active
2329: AND line.end_date_active)