APPS.AHL_DI_SUBSCRIPTION_PUB dependencies on HZ_PARTIES

Line 79: FROM hz_parties

75: --Used to retrieve the party id for party name
76: CURSOR for_party_name(c_party_name IN VARCHAR2)
77: IS
78: SELECT party_id
79: FROM hz_parties
80: WHERE upper(party_name) = upper(c_party_name);
81:
82: --Get the party id from hz parties
83: CURSOR for_party_id(c_party_id IN NUMBER)

Line 82: --Get the party id from hz parties

78: SELECT party_id
79: FROM hz_parties
80: WHERE upper(party_name) = upper(c_party_name);
81:
82: --Get the party id from hz parties
83: CURSOR for_party_id(c_party_id IN NUMBER)
84: IS
85: SELECT party_id
86: FROM hz_parties

Line 86: FROM hz_parties

82: --Get the party id from hz parties
83: CURSOR for_party_id(c_party_id IN NUMBER)
84: IS
85: SELECT party_id
86: FROM hz_parties
87: WHERE party_id = c_party_id;
88:
89: -- enhancement #2525108: lov for PO Number : pbarman april 2003
90: -- Get Puchase Order Number from PO_PURCHASE_ORDER_V

Line 710: -- Get the party id from hz parties

706: x_msg_data OUT NOCOPY VARCHAR2
707: )
708: IS
709:
710: -- Get the party id from hz parties
711: CURSOR for_party_name(c_party_name IN VARCHAR2)
712: IS
713: SELECT party_id
714: FROM hz_parties

Line 714: FROM hz_parties

710: -- Get the party id from hz parties
711: CURSOR for_party_name(c_party_name IN VARCHAR2)
712: IS
713: SELECT party_id
714: FROM hz_parties
715: WHERE upper(party_name) = upper(c_party_name);
716:
717: --Get the party id from hz parties
718: CURSOR for_party_id(c_party_id IN NUMBER)

Line 717: --Get the party id from hz parties

713: SELECT party_id
714: FROM hz_parties
715: WHERE upper(party_name) = upper(c_party_name);
716:
717: --Get the party id from hz parties
718: CURSOR for_party_id(c_party_id IN NUMBER)
719: IS
720: SELECT party_id
721: FROM hz_parties

Line 721: FROM hz_parties

717: --Get the party id from hz parties
718: CURSOR for_party_id(c_party_id IN NUMBER)
719: IS
720: SELECT party_id
721: FROM hz_parties
722: WHERE party_id = c_party_id;
723:
724: -- Enhancement #2525108: lov for PO Number : pbarman april 2003
725: -- Get Puchase Order Number from PO_PURCHASE_ORDER_V