APPS.BIM_I_SGMT_CUST_FACTS_PKG dependencies on HZ_CUST_ACCOUNTS

Line 470: FROM hz_cust_accounts b

466: COMMIT;
467:
468: UPDATE bim_i_party_sgmt_facts a
469: SET account_open_date=(SELECT GREATEST(min(TRUNC(creation_date)),trunc(a.start_date_active))
470: FROM hz_cust_accounts b
471: WHERE a.party_id=b.party_id)
472: WHERE EXISTS
473: ( SELECT 1
474: FROM hz_cust_accounts b

Line 474: FROM hz_cust_accounts b

470: FROM hz_cust_accounts b
471: WHERE a.party_id=b.party_id)
472: WHERE EXISTS
473: ( SELECT 1
474: FROM hz_cust_accounts b
475: WHERE a.party_id=b.party_id);
476:
477:
478: commit;

Line 860: FROM hz_cust_accounts b

856: --update account creation date for those parties which does not have acoounts(in case of prospect)
857:
858: UPDATE bim_i_party_sgmt_facts a
859: SET account_open_date=(SELECT GREATEST(min(TRUNC(creation_date)),trunc(a.start_date_active))
860: FROM hz_cust_accounts b
861: WHERE a.party_id=b.party_id
862: AND b.creation_date >= g_initial_start_date)
863: WHERE EXISTS( SELECT 1
864: FROM hz_cust_accounts b

Line 864: FROM hz_cust_accounts b

860: FROM hz_cust_accounts b
861: WHERE a.party_id=b.party_id
862: AND b.creation_date >= g_initial_start_date)
863: WHERE EXISTS( SELECT 1
864: FROM hz_cust_accounts b
865: WHERE a.party_id=b.party_id
866: AND b.creation_date >= g_initial_start_date)
867: AND account_open_date IS NULL;
868: