APPS.IGI_DUNN_POST_UPG_PKG dependencies on HZ_CUST_PROFILE_CLASSES

Line 914: UPDATE hz_cust_profile_classes hcpc

910:
911: --dbms_output.put_line('Updated Rows in hz_customer_profiles : '|| SQL%ROWCOUNT);
912:
913: -- Update Customer Profile Classes
914: UPDATE hz_cust_profile_classes hcpc
915: SET late_charge_type = (SELECT DECODE(dunning_charge_type, 'A', 'ADJ',
916: 'I', 'INV', dunning_charge_type)
917: FROM igi_dun_cust_prof_class idcpc
918: WHERE idcpc.customer_profile_class_id = hcpc.profile_class_id

Line 920: /*Added the following to update hz_cust_profile_classes if Dunning Flaf is enabled - mbremkum*/

916: 'I', 'INV', dunning_charge_type)
917: FROM igi_dun_cust_prof_class idcpc
918: WHERE idcpc.customer_profile_class_id = hcpc.profile_class_id
919: AND idcpc.use_dunning_flag = 'Y'),
920: /*Added the following to update hz_cust_profile_classes if Dunning Flaf is enabled - mbremkum*/
921: dunning_letters = (SELECT idcpc.use_dunning_flag
922: FROM igi_dun_cust_prof_class idcpc
923: WHERE idcpc.customer_profile_class_id = hcpc.profile_class_id
924: AND idcpc.use_dunning_flag = 'Y')

Line 932: --dbms_output.put_line('Updated Rows in hz_cust_profile_classes : '|| SQL%ROWCOUNT);

928: AND idcpc1.use_dunning_flag = 'Y');
929:
930: COMMIT;
931:
932: --dbms_output.put_line('Updated Rows in hz_cust_profile_classes : '|| SQL%ROWCOUNT);
933:
934:
935: EXCEPTION
936: