[Home] [Help]
2516: and status = 'A';
2517: CURSOR org_contact IS
2518: select a.org_contact_id
2519: from
2520: hz_org_contacts a, hz_relationships b
2521: where b.party_id = p_party_id
2522: and a.party_relationship_id = b.relationship_id
2523: and b.STATUS = 'A' AND trunc(b.START_DATE) <= trunc(sysdate)
2524: AND trunc(nvl(b.END_DATE, sysdate)) >= trunc(sysdate);
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'
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
2713:
2714: CURSOR org_contact IS
2715: select a.org_contact_id
2716: from
2717: hz_org_contacts a, hz_relationships b
2718: where
2719: b.party_id = p_party_id
2720: /* and a.status = 'A' vtariker: Status for hz_org_contacts is now obsolete */
2721: and b.relationship_id = a.party_relationship_id
3055:
3056:
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