DBA Data[Home] [Help]

APPS.HZ_EXTRACT_PERSON_BO_PVT dependencies on HZ_FINANCIAL_PROF_OBJ

Line 520: SELECT HZ_FINANCIAL_PROF_OBJ(

516: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
517: FROM HZ_CERTIFICATIONS
518: WHERE PARTY_ID = P_PERSON_ID) AS HZ_CERTIFICATION_OBJ_TBL),
519: CAST(MULTISET (
520: SELECT HZ_FINANCIAL_PROF_OBJ(
521: P_ACTION_TYPE,
522: NULL, -- COMMON_OBJ_ID
523: FINANCIAL_PROFILE_ID,
524: ACCESS_AUTHORITY_DATE,

Line 542: WHERE PARTY_ID = P_PERSON_ID) AS HZ_FINANCIAL_PROF_OBJ_TBL),

538: CREATION_DATE,
539: LAST_UPDATE_DATE,
540: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
541: FROM HZ_FINANCIAL_PROFILE
542: WHERE PARTY_ID = P_PERSON_ID) AS HZ_FINANCIAL_PROF_OBJ_TBL),
543: HZ_CONTACT_PREF_OBJ_TBL(),
544: HZ_PARTY_USAGE_OBJ_TBL())
545: FROM HZ_PERSON_PROFILES PRO, HZ_PARTIES P
546: WHERE PRO.PARTY_ID = P.PARTY_ID