APPS.HZ_PARTY_ACQUIRE dependencies on HZ_TRANS_ATTRIBUTES_VL

Line 240: FROM HZ_TRANS_ATTRIBUTES_VL

236: AND pe.effective_end_date is NULL
237: AND p.party_id = pe.party_id;
238: CURSOR custom_attribs IS
239: SELECT attribute_name, custom_attribute_procedure
240: FROM HZ_TRANS_ATTRIBUTES_VL
241: WHERE entity_name='PARTY'
242: AND (source_table = 'CUSTOM'
243: OR custom_attribute_procedure is not null);
244:

Line 644: FROM HZ_TRANS_ATTRIBUTES_VL

640: AND (ps.status is null OR ps.status = 'A' or ps.status = 'I');
641:
642: CURSOR custom_attribs IS
643: SELECT attribute_name, custom_attribute_procedure
644: FROM HZ_TRANS_ATTRIBUTES_VL
645: WHERE entity_name='PARTY_SITES'
646: AND (source_table = 'CUSTOM'
647: OR custom_attribute_procedure is not null);
648:

Line 896: FROM HZ_TRANS_ATTRIBUTES_VL

892: AND (pr.status is null OR pr.status = 'A' or pr.status = 'I');
893:
894: CURSOR custom_attribs IS
895: SELECT attribute_name, custom_attribute_procedure
896: FROM HZ_TRANS_ATTRIBUTES_VL
897: WHERE entity_name='CONTACTS'
898: AND (source_table = 'CUSTOM'
899: OR custom_attribute_procedure is not null);
900:

Line 1132: FROM HZ_TRANS_ATTRIBUTES_VL

1128: AND (status is null OR status = 'A' or status = 'I');
1129:
1130: CURSOR custom_attribs IS
1131: SELECT attribute_name, custom_attribute_procedure
1132: FROM HZ_TRANS_ATTRIBUTES_VL
1133: WHERE entity_name='CONTACT_POINTS'
1134: AND (source_table = 'CUSTOM'
1135: OR custom_attribute_procedure IS NOT NULL);
1136: