DBA Data[Home] [Help]

APPS.ENG_VALIDATE_ECO dependencies on HZ_PARTIES

Line 30: l_grantee_type hz_parties.party_type%TYPE;

26: )
27: IS
28:
29: --x_grant_guid fnd_grants.grant_guid%TYPE;
30: l_grantee_type hz_parties.party_type%TYPE;
31: l_instance_type fnd_grants.instance_type%TYPE;
32: l_grantee_key fnd_grants.grantee_key%TYPE;
33: l_dummy VARCHAR2(1);
34: CURSOR get_party_type (cp_party_id NUMBER)

Line 37: FROM hz_parties

33: l_dummy VARCHAR2(1);
34: CURSOR get_party_type (cp_party_id NUMBER)
35: IS
36: SELECT party_type
37: FROM hz_parties
38: WHERE party_id=cp_party_id;
39: --Changing NULL to '*NULL*' as FND is upgrading their grants data model
40: CURSOR check_fnd_grant_exist (cp_grantee_key VARCHAR2,
41: cp_grantee_type VARCHAR2,