APPS.HZ_ACCT_CREATE_PKG dependencies on HZ_CUSTOMER_PROFILES

Line 100: FROM HZ_CUSTOMER_PROFILES

96: SELECT ROWID,
97: OBJECT_VERSION_NUMBER,
98: LAST_UPDATE_DATE,
99: CUST_ACCOUNT_ID
100: FROM HZ_CUSTOMER_PROFILES
101: WHERE CUST_ACCOUNT_PROFILE_ID = p_col_id;
102:
103: CURSOR cu_org IS
104: SELECT ROWID,

Line 121: ELSIF p_table_name = 'HZ_CUSTOMER_PROFILES' THEN

117: x_object_version_number,
118: l_last_update_date ,
119: x_id_value;
120: CLOSE cu_cust_acct_version;
121: ELSIF p_table_name = 'HZ_CUSTOMER_PROFILES' THEN
122: OPEN cu_cust_prof_version;
123: FETCH cu_cust_prof_version INTO
124: x_rowid ,
125: x_object_version_number,

Line 2129: FROM HZ_CUSTOMER_PROFILES

2125: SELECT ROWID,
2126: OBJECT_VERSION_NUMBER,
2127: LAST_UPDATE_DATE,
2128: CUST_ACCOUNT_ID
2129: FROM HZ_CUSTOMER_PROFILES
2130: WHERE CUST_ACCOUNT_PROFILE_ID = p_cust_account_profile_id;
2131:
2132:
2133: l_cust_acct_rowid ROWID;

Line 2306: p_table_name => 'HZ_CUSTOMER_PROFILES',

2302:
2303: l_cust_prof_object_version := x_cust_prof_object_version;
2304: IF l_cust_prof_object_version = -1 THEN
2305: object_version_select(
2306: p_table_name => 'HZ_CUSTOMER_PROFILES',
2307: p_col_id => p_cust_account_profile_id,
2308: x_rowid => l_cust_prof_rowid,
2309: x_object_version_number => l_cust_prof_object_version,
2310: x_last_update_date => l_cust_prof_last_update_date,

Line 2449: FROM hz_customer_profiles

2445: return;
2446: END IF;
2447:
2448: SELECT last_update_date INTO p_last_update_date
2449: FROM hz_customer_profiles
2450: WHERE cust_account_profile_id = p_cust_account_profile_id;
2451: END IF;
2452:
2453: ----------------------------