APPS.PQH_RNG_BUS dependencies on PQH_TXN_CATEGORY_ATTRIBUTES

Line 639: l_list_identifier pqh_txn_category_attributes.list_identifying_flag%type;

635: --
636: l_col_type pqh_attributes.column_type%type;
637: l_attribute_name pqh_attributes.attribute_name%type;
638: l_dummy_name pqh_attributes.attribute_name%type;
639: l_list_identifier pqh_txn_category_attributes.list_identifying_flag%type;
640: l_member_identifier pqh_txn_category_attributes.member_identifying_flag%type;
641: l_tcat_id pqh_txn_category_attributes.transaction_category_id%type;
642: r_tcat_id pqh_routing_categories.transaction_category_id%type;
643: l_attribute_found boolean := FALSE;

Line 640: l_member_identifier pqh_txn_category_attributes.member_identifying_flag%type;

636: l_col_type pqh_attributes.column_type%type;
637: l_attribute_name pqh_attributes.attribute_name%type;
638: l_dummy_name pqh_attributes.attribute_name%type;
639: l_list_identifier pqh_txn_category_attributes.list_identifying_flag%type;
640: l_member_identifier pqh_txn_category_attributes.member_identifying_flag%type;
641: l_tcat_id pqh_txn_category_attributes.transaction_category_id%type;
642: r_tcat_id pqh_routing_categories.transaction_category_id%type;
643: l_attribute_found boolean := FALSE;
644: --

Line 641: l_tcat_id pqh_txn_category_attributes.transaction_category_id%type;

637: l_attribute_name pqh_attributes.attribute_name%type;
638: l_dummy_name pqh_attributes.attribute_name%type;
639: l_list_identifier pqh_txn_category_attributes.list_identifying_flag%type;
640: l_member_identifier pqh_txn_category_attributes.member_identifying_flag%type;
641: l_tcat_id pqh_txn_category_attributes.transaction_category_id%type;
642: r_tcat_id pqh_routing_categories.transaction_category_id%type;
643: l_attribute_found boolean := FALSE;
644: --
645: l_proc varchar2(72) := g_package||'chk_if_valid_identifiers';

Line 659: from pqh_txn_category_attributes tca,pqh_attributes att

655: select att.attribute_name,nvl(att.column_type,hr_api.g_varchar2),
656: tca.transaction_category_id,
657: nvl(tca.list_identifying_flag,hr_api.g_varchar2),
658: nvl(tca.member_identifying_flag,hr_api.g_varchar2)
659: from pqh_txn_category_attributes tca,pqh_attributes att
660: where att.attribute_id = p_attribute_id
661: AND tca.attribute_id = att.attribute_id
662: AND tca.transaction_category_id = p_transaction_category_id;
663: --