DBA Data[Home] [Help]

APPS.POS_VENDOR_REG_PKG dependencies on HZ_CLASS_CODE_RELATIONS

Line 1969: FROM hz_class_code_relations hccr,

1965: CURSOR c_tca_class(p_party_id IN NUMBER) IS
1966: SELECT 'HZ:' || REPLACE(hccr.class_category, ' ', '$')
1967: || ':'
1968: || hccr.class_code AS code
1969: FROM hz_class_code_relations hccr,
1970: (SELECT class_category, class_code, owner_table_id
1971: FROM hz_code_assignments
1972: WHERE owner_table_name = 'HZ_PARTIES'
1973: AND owner_table_id = p_party_id