DBA Data[Home] [Help]

APPS.POS_VENDOR_REG_PKG dependencies on HZ_CODE_ASSIGNMENTS

Line 1971: FROM hz_code_assignments

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
1974: AND start_date_active <= SYSDATE
1975: AND NVL(end_date_active, SYSDATE) >= SYSDATE

Line 1987: FROM hz_code_assignments

1983: || ':'
1984: || fnd.lookup_code AS code
1985: FROM fnd_lookup_values_vl fnd,
1986: (SELECT class_category, class_code, owner_table_id
1987: FROM hz_code_assignments
1988: WHERE owner_table_name = 'HZ_PARTIES'
1989: AND owner_table_id = p_party_id
1990: AND start_date_active <= SYSDATE
1991: AND NVL(end_date_active, SYSDATE) >= SYSDATE