APPS.AR_LATE_CHARGE_UPG dependencies on HZ_CUSTOMER_PROFILES

Line 417: l_table_name IN VARCHAR2, -- HZ_CUSTOMER_PROFILES

413:
414: --Phase 7
415: PROCEDURE upgrade_profile
416: (l_table_owner IN VARCHAR2, -- AR
417: l_table_name IN VARCHAR2, -- HZ_CUSTOMER_PROFILES
418: l_script_name IN VARCHAR2, -- ar120lccp.sql
419: l_worker_id IN VARCHAR2,
420: l_num_workers IN VARCHAR2,
421: l_batch_size IN VARCHAR2)

Line 447: FROM hz_customer_profiles cp,

443: , DECODE(JGZZ_ATTRIBUTE1,'Y','Y',
444: NVL(INTEREST_CHARGES,'N')) INTEREST_CHARGES
445: , f_NUMBER(JGZZ_ATTRIBUTE4) Message_text_id
446: , decode(cons_inv_flag,'Y', decode(cons_bill_level,NULL,'SITE',NULL), NULL) cons_bill_level
447: FROM hz_customer_profiles cp,
448: (SELECT MAX(jgzz_attribute7) dom,
449: CUST_ACCOUNT_PROFILE_ID
450: FROM hz_cust_profile_amts
451: WHERE jgzz_attribute7 = 'M'

Line 531: UPDATE hz_customer_profiles

527: EXIT;
528: END IF;
529:
530: FORALL i IN l_rowid_tab.FIRST .. l_rowid_tab.LAST
531: UPDATE hz_customer_profiles
532: SET LATE_CHARGE_CALCULATION_TRX = l_LATE_CHARGE_CALCULATION_TRX(i),
533: CREDIT_ITEMS_FLAG = l_CREDIT_ITEMS_FLAG(i),
534: DISPUTED_TRANSACTIONS_FLAG = l_DISPUTED_TRANSACTIONS_FLAG(i),
535: LATE_CHARGE_TYPE = l_LATE_CHARGE_TYPE(i),