DBA Data[Home] [Help]

APPS.AMW_SECURITY_PUB dependencies on HZ_PARTIES

Line 545: l_grantee_type hz_parties.party_type%TYPE;

541: )
542: IS
543:
544: --x_grant_guid fnd_grants.grant_guid%TYPE;
545: l_grantee_type hz_parties.party_type%TYPE;
546: l_instance_type fnd_grants.instance_type%TYPE;
547: l_grantee_key fnd_grants.grantee_key%TYPE;
548: l_dummy VARCHAR2(1);
549: l_not_found boolean := true;

Line 553: FROM hz_parties

549: l_not_found boolean := true;
550: CURSOR get_party_type (cp_party_id NUMBER)
551: IS
552: SELECT party_type
553: FROM hz_parties
554: WHERE party_id=cp_party_id;
555:
556: CURSOR check_fnd_grant_exist (cp_grantee_key VARCHAR2,
557: cp_grantee_type VARCHAR2,