APPS.ARH_DQM_CUST_HELPER dependencies on HZ_CUST_ACCOUNTS

Line 14: hz_cust_accounts ca,

10: ret VARCHAR2(1);
11: CURSOR c_exist IS
12: SELECT 'Y'
13: FROM hz_cust_account_roles car,
14: hz_cust_accounts ca,
15: hz_matched_parties_gt mp
16: WHERE car.cust_account_role_id = p_cust_account_role_id
17: AND car.cust_account_id = ca.cust_account_id
18: AND DECODE(p_status,'ALL','ALL',NVL(car.status,'A'))= p_status

Line 44: hz_cust_accounts b

40: IS
41: CURSOR c1 IS
42: SELECT 'Y'
43: FROM hz_matched_parties_gt a,
44: hz_cust_accounts b
45: WHERE a.search_context_id = p_ctx_id
46: AND -a.party_id = p_cust_account_id
47: AND b.cust_account_id = p_cust_account_id
48: AND DECODE(p_status, 'ALL', 'ALL', NVL(b.status,'A')) = p_status

Line 415: hz_cust_accounts e,

411: FROM hz_matched_contacts_gt a,
412: hz_org_contacts b,
413: hz_relationships c,
414: hz_cust_account_roles d,
415: hz_cust_accounts e,
416: hz_matched_parties_gt f,
417: hz_parties g
418: WHERE a.search_context_id = p_ctx_id
419: AND a.org_contact_id = p_org_contact_id

Line 545: FROM hz_cust_accounts a,

541: RETURN NUMBER
542: IS
543: CURSOR c1 IS
544: SELECT NVL(score,0)
545: FROM hz_cust_accounts a,
546: hz_matched_parties_gt b
547: WHERE a.cust_account_id = p_cust_account_id
548: AND b.search_context_id = p_ctx_id
549: AND a.party_id = b.party_id

Line 1000: FROM hz_cust_accounts

996: p_status IN VARCHAR2)
997: IS
998: CURSOR c1 IS
999: SELECT cust_account_id
1000: FROM hz_cust_accounts
1001: WHERE party_id = p_party_id
1002: AND DECODE(p_status, 'ALL','ALL',NVL(status,'A')) = p_status;
1003: lrec c1%ROWTYPE;
1004: l_score NUMBER;

Line 1043: FROM hz_cust_accounts a,

1039: RETURN VARCHAR2
1040: IS
1041: CURSOR c1 IS
1042: SELECT 'Y'
1043: FROM hz_cust_accounts a,
1044: hz_matched_parties_gt b
1045: WHERE a.party_id = p_party_id
1046: AND a.cust_account_id = -b.party_id
1047: AND b.search_context_id = p_ctx_id