DBA Data[Home] [Help]

APPS.LNS_FUNDING_PUB dependencies on HZ_PARTY_SITES

Line 1955: FROM HZ_Party_Sites HPS

1951:
1952: -- validate party_site for the party
1953: CURSOR party_site_cur(P_PARTY_ID number, P_DATE date) IS
1954: SELECT party_site_id
1955: FROM HZ_Party_Sites HPS
1956: WHERE HPS.Party_ID = P_PARTY_ID
1957: AND HPS.Identifying_Address_Flag = 'Y'
1958: AND NVL(HPS.Start_Date_Active, P_DATE) = P_DATE;
1959:

Line 2638: FROM HZ_Party_Sites HPS

2634:
2635: -- validate party_site for the party
2636: CURSOR party_site_cur(P_PARTY_ID number, P_DATE date) IS
2637: SELECT party_site_id
2638: FROM HZ_Party_Sites HPS
2639: WHERE HPS.Party_ID = P_PARTY_ID
2640: AND HPS.Identifying_Address_Flag = 'Y'
2641: AND NVL(HPS.Start_Date_Active, P_DATE) = P_DATE;
2642: