APPS.AR_DEPOSIT_LIB_PVT dependencies on RA_TERMS

Line 900: FROM ra_terms

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

Line 1479: FROM ra_terms

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

Line 1496: FROM ra_terms

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