APPS.AR_CMGT_REVIEW_CONC dependencies on HZ_PARTIES

Line 284: l_party_id hz_parties.party_id%TYPE;

280: l_return_status VARCHAR2(1);
281: l_msg_count NUMBER;
282: l_msg_index NUMBER;
283: l_msg_data VARCHAR2(2000);
284: l_party_id hz_parties.party_id%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);

Line 300: party_id hz_parties.party_id%type,

296: l_exist_trx_currency ar_cmgt_credit_requests.trx_currency%type;
297:
298: Type review_row IS RECORD
299: (
300: party_id hz_parties.party_id%type,
301: cust_account_id hz_customer_profiles.cust_account_id%type,
302: site_use_id hz_customer_profiles.site_use_id%type,
303: review_cycle hz_customer_profiles.review_cycle%type,
304: next_review_date hz_customer_profiles.NEXT_CREDIT_REVIEW_DATE%type ,

Line 357: hz_parties party

353: hcp.CUST_ACCOUNT_PROFILE_ID profile_id,
354: hcp.credit_classification cp_credit_classification
355: FROM hz_customer_profiles hcp,
356: ar_cmgt_check_lists checklist,
357: hz_parties party
358: WHERE hcp.party_id = NVL(:bnd_party_id ,hcp.party_id)
359: AND :bnd_cust_account_id IS NULL
360: AND hcp.cust_account_id = -1
361: AND hcp.site_use_id IS NULL

Line 383: FROM hz_parties party,

379: checklist.review_type review_type,
380: checklist.credit_classification credit_classification,
381: hcp.CUST_ACCOUNT_PROFILE_ID profile_id,
382: hcp.credit_classification cp_credit_classification
383: FROM hz_parties party,
384: hz_customer_profiles hcp,
385: ar_cmgt_check_lists checklist,
386: hz_cust_accounts cust
387: WHERE hcp.party_id = NVL(:bnd_party_id ,hcp.party_id)

Line 413: FROM hz_parties party,

409: checklist.review_type review_type,
410: checklist.credit_classification credit_classification,
411: hcp.CUST_ACCOUNT_PROFILE_ID profile_id,
412: hcp.credit_classification cp_credit_classification
413: FROM hz_parties party,
414: HZ_CUST_SITE_USES_ALL uses ,
415: hz_customer_profiles hcp,
416: ar_cmgt_check_lists checklist
417: WHERE hcp.party_id = NVL(:bnd_party_id,hcp.party_id)

Line 446: hz_parties party,

442: hcp.CUST_ACCOUNT_PROFILE_ID profile_id,
443: hcp.credit_classification cp_credit_classification
444: FROM hz_customer_profiles hcp,
445: ar_cmgt_check_lists checklist,
446: hz_parties party,
447: HZ_CUST_SITE_USES_ALL uses
448: WHERE party.party_id = hcp.party_id
449: AND :bnd_party_id IS NULL
450: AND :bnd_cust_account_id IS NULL