APPS.PQH_GEN_FORM dependencies on PQH_COPY_ENTITY_CONTEXTS

Line 2121: from pqh_copy_entity_contexts

2117: select context
2118: ,application_short_name
2119: ,legislation_code
2120: ,responsibility_key
2121: from pqh_copy_entity_contexts
2122: where transaction_short_name = p_transaction_short_name ;
2123:
2124: cursor c_gbl is
2125: select context

Line 2126: from pqh_copy_entity_contexts

2122: where transaction_short_name = p_transaction_short_name ;
2123:
2124: cursor c_gbl is
2125: select context
2126: from pqh_copy_entity_contexts
2127: where transaction_short_name = p_transaction_short_name -- +++ ENSURE index on txn_short_name +++
2128: and nvl(upper(application_short_name), 'NULL') = 'NULL'
2129: and nvl(upper(legislation_code) , 'NULL') = 'NULL'
2130: and nvl(upper(responsibility_key) , 'NULL') = 'NULL';

Line 2287: from pqh_copy_entity_contexts ce1, pqh_copy_entity_contexts ce2

2283: and cet.copy_entity_txn_id = p_copy_entity_txn_id ;
2284: --
2285: cursor c_gbl(v_context in varchar2) is
2286: select ce1.context
2287: from pqh_copy_entity_contexts ce1, pqh_copy_entity_contexts ce2
2288: where ce1.transaction_short_name = ce2.transaction_short_name
2289: and ce2.context = v_context
2290: and nvl(upper(ce1.application_short_name), 'NULL') = 'NULL'
2291: and nvl(upper(ce1.legislation_code) , 'NULL') = 'NULL'