DBA Data[Home] [Help]

APPS.AHL_FMP_COMMON_PVT dependencies on AHL_OWNER_DETAILS_V

Line 2007: from ahl_owner_details_v OWN

2003:
2004: CURSOR get_owner_rec_from_value ( c_owner VARCHAR2)
2005: IS
2006: select DISTINCT OWN.owner_id
2007: from ahl_owner_details_v OWN
2008: where upper(owner_name) like upper(c_owner);
2009:
2010:
2011: CURSOR get_owner_rec_from_id ( c_owner_id NUMBER)

Line 2014: from ahl_owner_details_v OWN

2010:
2011: CURSOR get_owner_rec_from_id ( c_owner_id NUMBER)
2012: IS
2013: select DISTINCT OWN.owner_id
2014: from ahl_owner_details_v OWN
2015: where owner_id = c_owner_id;
2016:
2017: CURSOR get_owner_rec_from_id_val ( c_owner_id NUMBER,c_owner VARCHAR2)
2018: IS

Line 2020: from ahl_owner_details_v OWN

2016:
2017: CURSOR get_owner_rec_from_id_val ( c_owner_id NUMBER,c_owner VARCHAR2)
2018: IS
2019: select DISTINCT OWN.owner_id
2020: from ahl_owner_details_v OWN
2021: where owner_id = c_owner_id
2022: and upper(owner_name) like upper(c_owner);
2023:
2024: BEGIN