APPS.CSFW_TASKS_PUB dependencies on HZ_PARTIES

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

1097: l_category_set_id number;
1098: l_category_id number;
1099:
1100: CURSOR c_party_type( v_contact_id number) IS
1101: SELECT party_type FROM hz_parties WHERE party_id = v_contact_id;
1102:
1103: CURSOR c_contact_points_next IS
1104: SELECT CS_HZ_SR_CONTACT_POINTS_S.NEXTVAL FROM DUAL;
1105:

Line 1523: FROM Hz_Parties p,

1519: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(r.START_DATE, SYSDATE)) AND TRUNC(NVL(r.END_DATE, SYSDATE)) )
1520: -- or one of its Related parties
1521: OR s.party_id IN (
1522: SELECT sub.party_id
1523: FROM Hz_Parties p,
1524: Hz_Parties sub,
1525: Hz_Parties obj,
1526: Hz_Relationships r
1527: WHERE obj.party_id = p_customer_id

Line 1524: Hz_Parties sub,

1520: -- or one of its Related parties
1521: OR s.party_id IN (
1522: SELECT sub.party_id
1523: FROM Hz_Parties p,
1524: Hz_Parties sub,
1525: Hz_Parties obj,
1526: Hz_Relationships r
1527: WHERE obj.party_id = p_customer_id
1528: AND sub.status = 'A'

Line 1525: Hz_Parties obj,

1521: OR s.party_id IN (
1522: SELECT sub.party_id
1523: FROM Hz_Parties p,
1524: Hz_Parties sub,
1525: Hz_Parties obj,
1526: Hz_Relationships r
1527: WHERE obj.party_id = p_customer_id
1528: AND sub.status = 'A'
1529: AND sub.party_type IN ('PERSON','ORGANIZATION')