APPS.CSF_TASKS_PUB dependencies on HZ_PARTY_SITES

Line 3979: FROM hz_party_sites ps

3975: l_location_id NUMBER;
3976:
3977: CURSOR c_ps_location IS
3978: SELECT ps.location_id
3979: FROM hz_party_sites ps
3980: WHERE ps.party_site_id = p_party_site_id;
3981:
3982: CURSOR c_task_location IS
3983: SELECT NVL(t.location_id, ps.location_id)

Line 3985: , hz_party_sites ps

3981:
3982: CURSOR c_task_location IS
3983: SELECT NVL(t.location_id, ps.location_id)
3984: FROM jtf_tasks_b t
3985: , hz_party_sites ps
3986: WHERE t.task_id = p_task_id
3987: AND ps.party_site_id(+) = t.address_id;
3988:
3989: BEGIN

Line 4038: FROM hz_party_sites ps

4034: , l.city
4035: , l.state
4036: , l.province
4037: , l.country
4038: FROM hz_party_sites ps
4039: , hz_locations l
4040: WHERE ps.party_site_id = p_party_site_id
4041: AND l.location_id = ps.location_id;
4042:

Line 4054: , hz_party_sites ps

4050: , l.state
4051: , l.province
4052: , l.country
4053: FROM jtf_tasks_b t
4054: , hz_party_sites ps
4055: , hz_locations l
4056: WHERE t.task_id = p_task_id
4057: AND ps.party_site_id(+) = t.address_id
4058: AND l.location_id = NVL(t.location_id, ps.location_id);