DBA Data[Home] [Help]

APPS.HZ_EXTRACT_ORGANIZATION_BO_PVT dependencies on HZ_FINANCIAL_NUMBER_OBJ

Line 90: SELECT HZ_FINANCIAL_NUMBER_OBJ(

86: CREATION_DATE,
87: LAST_UPDATE_DATE,
88: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
89: CAST(MULTISET (
90: SELECT HZ_FINANCIAL_NUMBER_OBJ(
91: P_ACTION_TYPE,
92: NULL, -- COMMON_OBJ_ID
93: FINANCIAL_NUMBER_ID,
94: FINANCIAL_REPORT_ID,

Line 109: WHERE FINANCIAL_REPORT_ID = FR.FINANCIAL_REPORT_ID) AS HZ_FINANCIAL_NUMBER_OBJ_TBL))

105: LAST_UPDATE_DATE,
106: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY),
107: ACTUAL_CONTENT_SOURCE)
108: FROM HZ_FINANCIAL_NUMBERS
109: WHERE FINANCIAL_REPORT_ID = FR.FINANCIAL_REPORT_ID) AS HZ_FINANCIAL_NUMBER_OBJ_TBL))
110: FROM HZ_FINANCIAL_REPORTS FR
111: WHERE PARTY_ID = P_ORGANIZATION_ID;
112:
113: l_debug_prefix VARCHAR2(30) := '';