DBA Data[Home] [Help]

APPS.QP_BULK_VALUE_TO_ID dependencies on RA_TERMS

Line 92: from RA_TERMS c,

88: set (terms_id, process_status_flag, attribute_status)=
89: (select c.term_id,
90: decode(c.term_id, null, null, 'P'),
91: decode(c.term_id, null, ih.attribute_status||'004', ih.attribute_status)
92: from RA_TERMS c,
93: qp_interface_list_headers iih
94: where iih.terms = c.name(+)
95: and sysdate between nvl(c.start_date_active, sysdate)
96: and nvl(c.end_date_active, sysdate)