[Home] [Help]
2591:
2592: CURSOR relationship_cur IS
2593: select a.object_id
2594: from
2595: hz_relationships a, hz_cust_accounts b
2596: where a.party_id = l_party_id
2597: and a.object_id = b.party_id
2598: and b.cust_account_id = p_cust_account_id
2599: and a.status = 'A'
2689: where party_id = p_party_id and status ='A';
2690:
2691: CURSOR cust_cur IS
2692: SELECT party_id
2693: from hz_cust_accounts
2694: where cust_account_id = p_cust_account_id
2695: AND status = 'A'
2696: AND (sysdate BETWEEN NVL(account_activation_date, sysdate) AND
2697: NVL(account_termination_date, sysdate));
2697: NVL(account_termination_date, sysdate));
2698:
2699: CURSOR person_relationship_cur IS
2700: SELECT b.party_id
2701: from hz_org_contacts a, hz_relationships b, hz_cust_accounts c
2702: where
2703: --a.status = 'A' and -- status column obseleted
2704: a.party_relationship_id = b.relationship_id
2705: and b.subject_id = p_party_id
2912: IS
2913:
2914: CURSOR C_get_cust_id_from_party_id(l_Party_Id NUMBER) IS
2915: SELECT cust_account_id
2916: FROM hz_cust_accounts
2917: WHERE party_id = l_Party_Id
2918: and status = 'A'
2919: AND (sysdate BETWEEN NVL(account_activation_date, sysdate) AND
2920: NVL(account_termination_date, sysdate));
2926: AND status = 'A';
2927:
2928: CURSOR account_user_cur IS
2929: select a.cust_account_id
2930: from hz_cust_accounts a, hz_cust_account_roles b
2931: where a.cust_account_id = b.cust_account_id
2932: and b.party_id = p_party_id
2933: and b.role_type = 'ACCOUNT_USER'
2934: AND b.status = 'A'
3057: CURSOR C_party IS
3058: SELECT par.party_id
3059: FROM hz_relationships par,
3060: hz_org_contacts org ,
3061: hz_cust_accounts acc
3062: WHERE org.party_relationship_id = par.relationship_id
3063: AND org.org_contact_id = p_org_contact_id
3064: -- AND org.status = 'A' -- status column obseleted
3065: and par.status = 'A'