DBA Data[Home] [Help]

APPS.AHL_DI_SUBSCRIPTION_PVT dependencies on HZ_PARTIES

Line 131: FROM HZ_PARTIES

127:
128: CURSOR get_requested_name_hz(c_requested_by_party_id NUMBER)
129: IS
130: SELECT PARTY_NAME
131: FROM HZ_PARTIES
132: WHERE party_id= c_requested_by_party_id
133: AND PARTY_TYPE ='PERSON';
134:
135: CURSOR get_requested_name_ppf(c_requested_by_party_id NUMBER)

Line 987: FROM HZ_PARTIES

983:
984: CURSOR get_requested_name_hz(c_requested_by_party_id NUMBER)
985: IS
986: SELECT PARTY_NAME
987: FROM HZ_PARTIES
988: WHERE party_id= c_requested_by_party_id
989: AND PARTY_TYPE ='PERSON';
990:
991: CURSOR get_requested_name_ppf(c_requested_by_party_id NUMBER)