APPS.ASO_MAP_QUOTE_ORDER_INT dependencies on HZ_ORG_CONTACTS

Line 2468: hz_org_contacts a, hz_relationships b

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);

Line 2473: --and a.status = 'A'; /* status column in hz_org_contacts is obseleted */

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);
2473: --and a.status = 'A'; /* status column in hz_org_contacts is obseleted */
2474: l_party_type varchar2(30);
2475: begin
2476:
2477: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 2645: from hz_org_contacts a, hz_relationships b, hz_cust_accounts c

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

Line 2661: hz_org_contacts a, hz_relationships b

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

Line 2664: /* and a.status = 'A' vtariker: Status for hz_org_contacts is now obsolete */

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
2666: and b.status = 'A'
2667: and (sysdate between nvl(b.start_date, sysdate) and nvl(b.end_date, sysdate));
2668:

Line 3004: hz_org_contacts org ,

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
3008: -- AND org.status = 'A' -- status column obseleted