APPS.AR_DEPOSIT_LIB_PVT dependencies on RA_TERMS

Line 898: FROM ra_terms

894: ELSIF ( p_entity = 'TERM_NAME' )
895: THEN
896: SELECT term_id
897: INTO l_selected_id
898: FROM ra_terms
899: WHERE name = p_value;
900:
901: ELSIF (p_entity = 'RECEIPT_METHOD_NAME' )
902:

Line 1477: FROM ra_terms

1473: IF p_term_name IS NOT NULL THEN
1474: begin
1475: SELECT term_id
1476: INTO x_term_id
1477: FROM ra_terms
1478: WHERE name = p_term_name and
1479: nvl(p_deposit_date, trunc(sysdate)) between start_date_active
1480: and nvl(end_date_active,nvl(p_deposit_date,trunc(sysdate)));
1481:

Line 1494: FROM ra_terms

1490: ELSE
1491: begin
1492: SELECT term_id
1493: INTO x_term_id
1494: FROM ra_terms
1495: WHERE term_id = x_term_id and
1496: nvl(p_deposit_date, trunc(sysdate)) between start_date_active
1497: and nvl(end_date_active,nvl(p_deposit_date,trunc(sysdate)));
1498: