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 807: FROM hz_parties

803: WHERE upper(party_name) = upper(c_approved_by_pty_name);
804: */
805: --changes due to performance pbarman 7.5.2003
806: SELECT party_id
807: FROM hz_parties
808: WHERE upper(PARTY_NAME) = upper(c_approved_by_pty_name)
809: AND AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PER') IN ('N','L')
810: AND party_type = 'PERSON'
811: UNION

Line 825: FROM hz_parties

821: -- Check for ID
822: CURSOR approved_by_party_id(c_approved_by_pty_id IN NUMBER)
823: IS
824: SELECT party_id
825: FROM hz_parties
826: WHERE party_id = c_approved_by_pty_id;
827:
828: --Check for Name
829: CURSOR approved_by_party_desc(c_approved_by_pty_name IN VARCHAR2)

Line 832: FROM hz_parties

828: --Check for Name
829: CURSOR approved_by_party_desc(c_approved_by_pty_name IN VARCHAR2)
830: IS
831: SELECT party_id
832: FROM hz_parties
833: WHERE UPPER(party_name) = UPPER(c_approved_by_pty_name);
834:
835: --Used to retrieve the party id for party name and party id
836: CURSOR get_party_name_id (c_party_name IN VARCHAR2, c_party_id IN NUMBER)