APPS.PQH_GENERIC dependencies on PQH_TRANSACTION_CATEGORIES

Line 42: l_transaction_category_id pqh_transaction_categories.transaction_category_id%TYPE;

38: l_cet number ;
39: l_cer1 number ;
40: l_cer2 number ;
41: l_status pqh_copy_entity_txns.status%TYPE;
42: l_transaction_category_id pqh_transaction_categories.transaction_category_id%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

Line 43: l_transaction_short_name pqh_transaction_categories.short_name%TYPE;

39: l_cer1 number ;
40: l_cer2 number ;
41: l_status pqh_copy_entity_txns.status%TYPE;
42: l_transaction_category_id pqh_transaction_categories.transaction_category_id%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;

Line 68: , pqh_transaction_categories_vl tct

64: , to_char(nvl(cet.src_effective_date,sysdate),'RRRR/MM/DD HH24:MI:SS') effective_date
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