DBA Data[Home] [Help]

APPS.LNS_FUNDING_PUB dependencies on HZ_PARTY_SITES

Line 1905: FROM HZ_Party_Sites HPS

1901:
1902: -- validate party_site for the party
1903: CURSOR party_site_cur(P_PARTY_ID number, P_DATE date) IS
1904: SELECT party_site_id
1905: FROM HZ_Party_Sites HPS
1906: WHERE HPS.Party_ID = P_PARTY_ID
1907: AND HPS.Identifying_Address_Flag = 'Y'
1908: AND NVL(HPS.Start_Date_Active, P_DATE) = P_DATE;
1909:

Line 2569: FROM HZ_Party_Sites HPS

2565:
2566: -- validate party_site for the party
2567: CURSOR party_site_cur(P_PARTY_ID number, P_DATE date) IS
2568: SELECT party_site_id
2569: FROM HZ_Party_Sites HPS
2570: WHERE HPS.Party_ID = P_PARTY_ID
2571: AND HPS.Identifying_Address_Flag = 'Y'
2572: AND NVL(HPS.Start_Date_Active, P_DATE) = P_DATE;
2573: