APPS.CSI_INSTANCE_PARTIES_VLD_PVT dependencies on HZ_CUST_ACCOUNTS

Line 387: FROM hz_cust_accounts ha

383: , ar_lookups l
384: WHERE (r.object_id = i_party_id
385: OR
386: r.object_id IN (SELECT DISTINCT ha.party_id
387: FROM hz_cust_accounts ha
388: ,hz_cust_acct_relate_all rel
389: ,hz_cust_accounts hz
390: WHERE ha.cust_account_id=rel.related_cust_account_id
391: AND rel.cust_account_id=hz.cust_account_id

Line 389: ,hz_cust_accounts hz

385: OR
386: r.object_id IN (SELECT DISTINCT ha.party_id
387: FROM hz_cust_accounts ha
388: ,hz_cust_acct_relate_all rel
389: ,hz_cust_accounts hz
390: WHERE ha.cust_account_id=rel.related_cust_account_id
391: AND rel.cust_account_id=hz.cust_account_id
392: AND rel.status='A'
393: AND hz.party_id=i_party_id)

Line 996: /* exists in hz_cust_accounts */

992:
993: /*-----------------------------------------------------------*/
994: /* Procedure name: Is_Pty_accountID_Valid */
995: /* Description : Check if the party account_id */
996: /* exists in hz_cust_accounts */
997: /*-----------------------------------------------------------*/
998:
999: FUNCTION Is_Pty_accountID_Valid
1000: ( p_party_account_id IN NUMBER,

Line 1014: FROM hz_cust_accounts

1010: l_party_source_table VARCHAR2(30);
1011:
1012: CURSOR C1(i_party_account_id NUMBER) IS
1013: SELECT 'x'
1014: FROM hz_cust_accounts
1015: WHERE cust_account_id = i_party_account_id;
1016:
1017: CURSOR C2(i_party_account_id NUMBER,
1018: i_party_id NUMBER) IS

Line 1020: FROM hz_cust_accounts hzca,

1016:
1017: CURSOR C2(i_party_account_id NUMBER,
1018: i_party_id NUMBER) IS
1019: SELECT 'x'
1020: FROM hz_cust_accounts hzca,
1021: hz_parties hzp
1022: WHERE hzca.cust_account_id = i_party_account_id
1023: AND hzca.party_id = i_party_id
1024: AND hzca.party_id = hzp.party_id;