APPS.CSFW_TASKS_PUB dependencies on HZ_PARTIES

Line 1084: SELECT party_type FROM hz_parties WHERE party_id = v_contact_id;

1080: l_category_set_id number;
1081: l_category_id number;
1082:
1083: CURSOR c_party_type( v_contact_id number) IS
1084: SELECT party_type FROM hz_parties WHERE party_id = v_contact_id;
1085:
1086: CURSOR c_contact_points_next IS
1087: SELECT CS_HZ_SR_CONTACT_POINTS_S.NEXTVAL FROM DUAL;
1088:

Line 1505: FROM Hz_Parties p,

1501: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(r.START_DATE, SYSDATE)) AND TRUNC(NVL(r.END_DATE, SYSDATE)) )
1502: -- or one of its Related parties
1503: OR s.party_id IN (
1504: SELECT sub.party_id
1505: FROM Hz_Parties p,
1506: Hz_Parties sub,
1507: Hz_Parties obj,
1508: Hz_Relationships r
1509: WHERE obj.party_id = p_customer_id

Line 1506: Hz_Parties sub,

1502: -- or one of its Related parties
1503: OR s.party_id IN (
1504: SELECT sub.party_id
1505: FROM Hz_Parties p,
1506: Hz_Parties sub,
1507: Hz_Parties obj,
1508: Hz_Relationships r
1509: WHERE obj.party_id = p_customer_id
1510: AND sub.status = 'A'

Line 1507: Hz_Parties obj,

1503: OR s.party_id IN (
1504: SELECT sub.party_id
1505: FROM Hz_Parties p,
1506: Hz_Parties sub,
1507: Hz_Parties obj,
1508: Hz_Relationships r
1509: WHERE obj.party_id = p_customer_id
1510: AND sub.status = 'A'
1511: AND sub.party_type IN ('PERSON','ORGANIZATION')