[Home] [Help]
2464: and status = 'A';
2465: CURSOR org_contact IS
2466: select a.org_contact_id
2467: from
2468: hz_org_contacts a, hz_relationships b
2469: where b.party_id = p_party_id
2470: and a.party_relationship_id = b.relationship_id
2471: and b.STATUS = 'A' AND trunc(b.START_DATE) <= trunc(sysdate)
2472: AND trunc(nvl(b.END_DATE, sysdate)) >= trunc(sysdate);
2535:
2536: CURSOR relationship_cur IS
2537: select a.object_id
2538: from
2539: hz_relationships a, hz_cust_accounts b
2540: where a.party_id = l_party_id
2541: and a.object_id = b.party_id
2542: and b.cust_account_id = p_cust_account_id
2543: and a.status = 'A'
2641: NVL(account_termination_date, sysdate));
2642:
2643: CURSOR person_relationship_cur IS
2644: SELECT b.party_id
2645: from hz_org_contacts a, hz_relationships b, hz_cust_accounts c
2646: where
2647: --a.status = 'A' and -- status column obseleted
2648: a.party_relationship_id = b.relationship_id
2649: and b.subject_id = p_party_id
2657:
2658: CURSOR org_contact IS
2659: select a.org_contact_id
2660: from
2661: hz_org_contacts a, hz_relationships b
2662: where
2663: b.party_id = p_party_id
2664: /* and a.status = 'A' vtariker: Status for hz_org_contacts is now obsolete */
2665: and b.relationship_id = a.party_relationship_id
2999:
3000:
3001: CURSOR C_party IS
3002: SELECT par.party_id
3003: FROM hz_relationships par,
3004: hz_org_contacts org ,
3005: hz_cust_accounts acc
3006: WHERE org.party_relationship_id = par.relationship_id
3007: AND org.org_contact_id = p_org_contact_id