APPS.CSI_INSTANCE_PARTIES_VLD_PVT dependencies on HZ_CUST_ACCOUNTS

Line 389: FROM hz_cust_accounts ha

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

Line 391: ,hz_cust_accounts hz

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

Line 998: /* exists in hz_cust_accounts */

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

Line 1016: FROM hz_cust_accounts

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

Line 1022: FROM hz_cust_accounts hzca,

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