APPS.IGI_DUNN_POST_UPG_PKG dependencies on IGI_DUN_CUST_PROF_CLASS

Line 917: FROM igi_dun_cust_prof_class idcpc

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
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

Line 922: 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')
925: WHERE EXISTS (SELECT 'Y'
926: FROM igi_dun_cust_prof_class idcpc1

Line 926: FROM igi_dun_cust_prof_class idcpc1

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')
925: WHERE EXISTS (SELECT 'Y'
926: FROM igi_dun_cust_prof_class idcpc1
927: WHERE idcpc1.customer_profile_class_id = hcpc.profile_class_id
928: AND idcpc1.use_dunning_flag = 'Y');
929:
930: COMMIT;