APPS.JTF_FM_INT_REQUEST_PKG dependencies on HZ_CONTACT_PREFERENCES
Line 72: FROM hz_contact_preferences b ,
68: TYPE l_line_id_table_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
69: l_line_id l_line_id_table_type ;
70: CURSOR c_parties IS
71: SELECT c.request_line_id 72: FROM hz_contact_preferences b , 73: jtf_fm_int_request_lines c
74: WHERE b.preference_code = 'DO_NOT'
75: AND b.contact_level_table = 'HZ_PARTIES'
76: AND b.contact_level_table_id = c.party_id