DBA Data[Home] [Help]

APPS.PQH_TEM_BUS dependencies on PQH_ATTRIBUTES_VL

Line 1138: From pqh_txn_category_attributes tca,pqh_attributes_vl att,

1134: Cursor c1 is
1135: Select nvl(att.master_attribute_id,att.attribute_id),
1136: tca.attribute_id,rtrim(att.attribute_name),nvl(tat.attribute_id,-1),
1137: nvl(tat.view_flag,'N') , nvl(tat.edit_flag,'N')
1138: From pqh_txn_category_attributes tca,pqh_attributes_vl att,
1139: pqh_template_attributes tat
1140: Where tca.transaction_category_id = p_transaction_category_id
1141: AND tca.attribute_id = att.attribute_id
1142: AND att.attribute_id = tat.attribute_id(+)

Line 1148: from pqh_attributes_vl

1144: Order by 1,2;
1145: --
1146: Cursor csr_master_attr(p_attribute_id in number) is
1147: Select rtrim(attribute_name)
1148: from pqh_attributes_vl
1149: Where attribute_id = p_attribute_id;
1150: --
1151: --
1152: -- Declaring local variables.