APPS.AHL_DI_DOC_REVISION_PUB dependencies on HZ_PARTIES

Line 83: FROM hz_parties

79: WHERE upper(party_name) = upper(c_approved_by_pty_name);
80: */
81: -- changes for performance pbarman 7.5.2003
82: SELECT party_id
83: FROM hz_parties
84: WHERE upper(PARTY_NAME) = upper(c_approved_by_pty_name)
85: AND AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PER') IN ('N','L')
86: AND party_type = 'PERSON'
87: UNION

Line 101: FROM hz_parties

97: -- Check for ID
98: CURSOR approved_by_party_id(c_approved_by_pty_id IN NUMBER)
99: IS
100: SELECT party_id
101: FROM hz_parties
102: WHERE party_id = c_approved_by_pty_id;
103:
104: --Check for Name
105: CURSOR approved_by_party_desc(c_approved_by_pty_name IN VARCHAR2)

Line 108: FROM hz_parties

104: --Check for Name
105: CURSOR approved_by_party_desc(c_approved_by_pty_name IN VARCHAR2)
106: IS
107: SELECT party_id
108: FROM hz_parties
109: WHERE UPPER(party_name) = UPPER(c_approved_by_pty_name);
110:
111: --Used to retrieve the party id for party name and party id
112: CURSOR get_party_name_id (c_party_name IN VARCHAR2, c_party_id IN NUMBER)

Line 816: FROM hz_parties

812: WHERE upper(party_name) = upper(c_approved_by_pty_name);
813: */
814: --changes due to performance pbarman 7.5.2003
815: SELECT party_id
816: FROM hz_parties
817: WHERE upper(PARTY_NAME) = upper(c_approved_by_pty_name)
818: AND AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PER') IN ('N','L')
819: AND party_type = 'PERSON'
820: UNION

Line 834: FROM hz_parties

830: -- Check for ID
831: CURSOR approved_by_party_id(c_approved_by_pty_id IN NUMBER)
832: IS
833: SELECT party_id
834: FROM hz_parties
835: WHERE party_id = c_approved_by_pty_id;
836:
837: --Check for Name
838: CURSOR approved_by_party_desc(c_approved_by_pty_name IN VARCHAR2)

Line 841: FROM hz_parties

837: --Check for Name
838: CURSOR approved_by_party_desc(c_approved_by_pty_name IN VARCHAR2)
839: IS
840: SELECT party_id
841: FROM hz_parties
842: WHERE UPPER(party_name) = UPPER(c_approved_by_pty_name);
843:
844: --Used to retrieve the party id for party name and party id
845: CURSOR get_party_name_id (c_party_name IN VARCHAR2, c_party_id IN NUMBER)