APPS.IGI_DUNN_POST_UPG_PKG dependencies on IGI_DUN_CUST_PROF

Line 898: FROM igi_dun_cust_prof idcp

894: -- Update Customer Profiles
895: UPDATE hz_customer_profiles hcp
896: SET late_charge_type = (SELECT DECODE(dunning_charge_type, 'A', 'ADJ',
897: 'I', 'INV', dunning_charge_type)
898: FROM igi_dun_cust_prof idcp
899: WHERE idcp.customer_profile_id = hcp.cust_account_profile_id
900: AND idcp.use_dunning_flag = 'Y'),
901: /*Added the following to update hz_customer_profiles if Dunning Flaf is enabled - mbremkum*/
902: dunning_letters = (SELECT idcp.use_dunning_flag

Line 903: FROM igi_dun_cust_prof idcp

899: WHERE idcp.customer_profile_id = hcp.cust_account_profile_id
900: AND idcp.use_dunning_flag = 'Y'),
901: /*Added the following to update hz_customer_profiles if Dunning Flaf is enabled - mbremkum*/
902: dunning_letters = (SELECT idcp.use_dunning_flag
903: FROM igi_dun_cust_prof idcp
904: WHERE idcp.customer_profile_id = hcp.cust_account_profile_id
905: AND idcp.use_dunning_flag = 'Y')
906: WHERE EXISTS (SELECT 'Y'
907: FROM igi_dun_cust_prof idcp1

Line 907: FROM igi_dun_cust_prof idcp1

903: FROM igi_dun_cust_prof idcp
904: WHERE idcp.customer_profile_id = hcp.cust_account_profile_id
905: AND idcp.use_dunning_flag = 'Y')
906: WHERE EXISTS (SELECT 'Y'
907: FROM igi_dun_cust_prof idcp1
908: WHERE idcp1.customer_profile_id = hcp.cust_account_profile_id
909: AND idcp1.use_dunning_flag = 'Y');
910:
911: --dbms_output.put_line('Updated Rows in hz_customer_profiles : '|| SQL%ROWCOUNT);

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;