APPS.HZ_MIXNM_UTILITY dependencies on HZ_THIRDPARTY_RULE

Line 451: -- hz_thirdparty_rule will now be orig_system specific.

447: -- find out the attributes which can be overwrited by third
448: -- party when they store user entered data.
449:
450: -- SSM SST Integration and Extension
451: -- hz_thirdparty_rule will now be orig_system specific.
452: -- Retrieve orig_system in the cursor.
453: CURSOR c_overwrite_user_rule (
454: p_party_id NUMBER
455: ) IS

Line 458: FROM hz_thirdparty_rule rule

454: p_party_id NUMBER
455: ) IS
456: SELECT rule.entity_attr_id,
457: rule.orig_system
458: FROM hz_thirdparty_rule rule
459: WHERE rule.overwrite_flag = 'Y'
460: AND NOT EXISTS
461: (SELECT '1'
462: FROM hz_thirdparty_exceps exceps

Line 5449: from hz_thirdparty_rule t, hz_orig_systems_vl v

5445: ) Return VARCHAR2 IS
5446:
5447: cursor update_allowed is
5448: select v.orig_system_name
5449: from hz_thirdparty_rule t, hz_orig_systems_vl v
5450: where t.entity_attr_id = p_entity_attr_id
5451: and t.orig_system = v.orig_system
5452: and t.overwrite_flag = 'Y';
5453: