APPS.PQH_GENERIC dependencies on PQH_COPY_ENTITY_CONTEXTS

Line 47: l_function_context pqh_copy_entity_contexts.context%TYPE;

43: l_transaction_short_name pqh_transaction_categories.short_name%TYPE;
44: l_name pqh_copy_entity_txns.display_name%TYPE;
45: l_master_table_route_id pqh_table_route.table_route_id%TYPE;
46: l_effective_date varchar2(30); -- would hold date in char format
47: l_function_context pqh_copy_entity_contexts.context%TYPE;
48: l_context pqh_copy_entity_txns.context%TYPE;
49: l_function_type_cd pqh_copy_entity_functions.function_type_cd%TYPE;
50: l_pre_copy_function_name pqh_copy_entity_functions.pre_copy_function_name%TYPE;
51: l_copy_function_name pqh_copy_entity_functions.copy_function_name%TYPE;

Line 69: , pqh_copy_entity_contexts cec

65: , cet.context -- application_id
66: , cec.context gbl_context
67: from pqh_copy_entity_txns cet
68: , pqh_transaction_categories_vl tct
69: , pqh_copy_entity_contexts cec
70: where tct.transaction_category_id = cet.transaction_category_id
71: and cec.transaction_short_name = tct.short_name
72: and cec.application_short_name is null
73: and cec.legislation_code is null

Line 208: from pqh_copy_entity_contexts cec

204: return varchar2 is
205: --
206: cursor c_con is
207: select cec.application_short_name, cec.legislation_code, cec.responsibility_key
208: from pqh_copy_entity_contexts cec
209: where cec.context = p_context
210: and cec.transaction_short_name = p_transaction_short_name;
211: --
212: cursor c_all is

Line 215: from pqh_copy_entity_contexts cec, pqh_copy_entity_functions cef

211: --
212: cursor c_all is
213: select cec.context, cec.application_short_name, cec.legislation_code, cec.responsibility_key,
214: cef.function_type_cd, cef.pre_copy_function_name, cef.copy_function_name, cef.post_copy_function_name
215: from pqh_copy_entity_contexts cec, pqh_copy_entity_functions cef
216: where cec.context = cef.context
217: and cef.table_route_id = p_table_route_id
218: and cec.transaction_short_name = p_transaction_short_name;
219: begin