DBA Data[Home] [Help]

APPS.AR_CMGT_REVIEW_CONC dependencies on HZ_CUST_PROFILE_AMTS

Line 258: p_currency_code hz_cust_profile_amts.currency_code%type,

254: errbuf IN OUT NOCOPY VARCHAR2,
255: retcode IN OUT NOCOPY VARCHAR2,
256: p_review_cycle IN VARCHAR2,
257: p_review_cycle_as_of_date IN VARCHAR2,
258: p_currency_code hz_cust_profile_amts.currency_code%type,
259: p_cust_level IN VARCHAR2,
260: p_check_list_id IN VARCHAR2,
261: p_party_id IN NUMBER,
262: p_cust_account_id IN NUMBER,

Line 289: l_currency_code hz_cust_profile_amts.currency_code%type;

285: l_found_flag VARCHAR2(1) := 'N';
286: l_create_request_flag VARCHAR2(1) := 'N';
287: l_case_folder_count NUMBER;
288: l_review_type VARCHAR2(30);
289: l_currency_code hz_cust_profile_amts.currency_code%type;
290: l_review_cycle_as_of_date hz_customer_profiles.LAST_CREDIT_REVIEW_DATE %type;
291: l_next_review_date hz_customer_profiles.NEXT_CREDIT_REVIEW_DATE%type;
292: l_cust_level VARCHAR2(30);
293: l_cust_account_id VARCHAR2(360);