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