DBA Data[Home] [Help]

APPS.PO_XML_DELIVERY dependencies on HZ_CODE_ASSIGNMENTS

Line 1981: from hz_parties hp, hz_code_assignments hca

1977: x_shipto_name := '';
1978:
1979: select count(*)
1980: into l_num_enterprises
1981: from hz_parties hp, hz_code_assignments hca
1982: where hca.owner_table_id = hp.party_id
1983: and hca.owner_table_name = 'HZ_PARTIES'
1984: and hca.class_category = 'POS_PARTICIPANT_TYPE'
1985: and hca.class_code = 'ENTERPRISE'

Line 1993: from hz_parties hp, hz_code_assignments hca

1989:
1990: IF l_num_enterprises = 1 THEN
1991: select hp.party_name
1992: into x_shipto_name
1993: from hz_parties hp, hz_code_assignments hca
1994: where hca.owner_table_id = hp.party_id
1995: and hca.owner_table_name = 'HZ_PARTIES'
1996: and hca.class_category = 'POS_PARTICIPANT_TYPE'
1997: and hca.class_code = 'ENTERPRISE'