DBA Data[Home] [Help]

APPS.HZ_ACCT_CREATE_PKG dependencies on HZ_CUST_ACCOUNTS

Line 92: FROM HZ_CUST_ACCOUNTS

88: SELECT ROWID,
89: OBJECT_VERSION_NUMBER,
90: LAST_UPDATE_DATE,
91: NULL
92: FROM HZ_CUST_ACCOUNTS
93: WHERE CUST_ACCOUNT_ID = p_col_id;
94:
95: CURSOR cu_cust_prof_version IS
96: SELECT ROWID,

Line 113: IF p_table_name = 'HZ_CUST_ACCOUNTS' THEN

109: WHERE PARTY_ID = p_col_id;
110:
111: l_last_update_date DATE;
112: BEGIN
113: IF p_table_name = 'HZ_CUST_ACCOUNTS' THEN
114: OPEN cu_cust_acct_version;
115: FETCH cu_cust_acct_version INTO
116: x_rowid ,
117: x_object_version_number,

Line 2121: FROM HZ_CUST_ACCOUNTS

2117: CURSOR cu_cust_acct_version IS
2118: SELECT ROWID,
2119: OBJECT_VERSION_NUMBER,
2120: LAST_UPDATE_DATE
2121: FROM HZ_CUST_ACCOUNTS
2122: WHERE CUST_ACCOUNT_ID = c_cust_account_id;
2123:
2124: CURSOR cu_cust_prof_version IS
2125: SELECT ROWID,

Line 2161: p_table_name => 'HZ_CUST_ACCOUNTS',

2157: --
2158: l_cust_acct_object_version := x_cust_acct_object_version;
2159: IF l_cust_acct_object_version = -1 THEN
2160: object_version_select (
2161: p_table_name => 'HZ_CUST_ACCOUNTS',
2162: p_col_id => c_cust_account_id,
2163: x_rowid => l_cust_acct_rowid,
2164: x_object_version_number => l_cust_acct_object_version,
2165: x_last_update_date => l_cust_acct_last_update_date,

Line 2293: FROM hz_cust_accounts

2289: SELECT last_update_date,
2290: object_version_number
2291: INTO a_last_update_date,
2292: a_object_version
2293: FROM hz_cust_accounts
2294: WHERE cust_account_id = c_cust_account_id;
2295: END IF;
2296:
2297: