[Home] [Help]
2167:
2168: CURSOR validate_bill_to_contact_csr IS
2169: SELECT 'x'
2170: FROM Hz_Parties sub,
2171: Hz_Relationships r
2172: WHERE r.object_id = p_bill_to_party_id
2173: AND r.party_id = p_bill_to_contact_id
2174: AND sub.status = 'A'
2175: AND r.status = 'A'
2263:
2264: CURSOR validate_bill_to_contact_csr IS
2265: SELECT 'x'
2266: FROM Hz_Parties sub,
2267: Hz_Relationships r
2268: WHERE r.object_id = p_customer_id
2269: AND r.party_id = p_customer_contact_id
2270: AND sub.status = 'A'
2271: AND r.status = 'A'
2334:
2335: CURSOR party_relationship IS
2336: SELECT 'x'
2337: FROM Hz_Parties sub,
2338: Hz_Relationships r,
2339: Hz_Parties obj
2340: WHERE r.object_id = p_customer_id
2341: AND r.party_id = p_customer_contact_id
2342: AND sub.status = 'A'
2397:
2398: CURSOR party_relationship_per IS
2399: SELECT 'x'
2400: FROM Hz_Parties sub,
2401: Hz_Relationships r,
2402: Hz_Parties obj
2403: WHERE r.object_id = p_customer_id
2404: AND r.party_id = p_customer_contact_id
2405: AND sub.status = 'A'
3434:
3435: CURSOR Bill_To_Party IS
3436: SELECT p.party_type
3437: FROM Hz_parties p ,
3438: Hz_Relationships r
3439: WHERE p.party_id = p_bill_to_party_id
3440: AND p.status = 'A'
3441: AND p.party_type IN ('PERSON','ORGANIZATION')
3442: AND r.object_id = p_customer_id
3580: AND ( s.party_id = p_customer_id
3581: -- or one of its relationships
3582: OR s.party_id IN (
3583: SELECT r.party_id
3584: FROM Hz_Relationships r
3585: WHERE r.object_id = p_customer_id
3586: AND r.status = 'A'
3587: -- Added to remove TCA violation -- Relationship should be active -- anmukher -- 08/14/03
3588: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(r.START_DATE, SYSDATE)) AND TRUNC(NVL(r.END_DATE, SYSDATE)) )
3591: SELECT sub.party_id
3592: FROM Hz_Parties p,
3593: Hz_Parties sub,
3594: Hz_Parties obj,
3595: Hz_Relationships r
3596: WHERE obj.party_id = p_customer_id
3597: AND sub.status = 'A'
3598: AND obj.status = 'A'
3599: AND r.status = 'A'