APPS.CSF_TASKS_PUB dependencies on HZ_PARTY_SITES

Line 94: and owner_table_name ='HZ_PARTY_SITES'

90: into l_phone
91: from (select phone_number, phone_area_code, phone_country_code
92: from hz_contact_points
93: where owner_table_id = party_id
94: and owner_table_name ='HZ_PARTY_SITES'
95: and contact_point_type = 'PHONE'
96: order by primary_flag desc, creation_date asc)
97: where rownum = 1;
98:

Line 1806: from jtf_tasks_b t, hz_party_sites ps

1802: t.location_id,
1803: t.address_id,
1804: t.customer_id,
1805: NVL(t.location_id, ps.location_id) loc_id
1806: from jtf_tasks_b t, hz_party_sites ps
1807: where task_id=p_task_id
1808: AND ps.party_site_id(+) = t.address_id;
1809: l_task_dtls c_task_details%rowtype;
1810:

Line 4627: FROM hz_party_sites ps

4623: l_location_id NUMBER;
4624:
4625: CURSOR c_ps_location IS
4626: SELECT ps.location_id
4627: FROM hz_party_sites ps
4628: WHERE ps.party_site_id = p_party_site_id;
4629:
4630: CURSOR c_task_location IS
4631: SELECT NVL(t.location_id, ps.location_id)

Line 4633: , hz_party_sites ps

4629:
4630: CURSOR c_task_location IS
4631: SELECT NVL(t.location_id, ps.location_id)
4632: FROM jtf_tasks_b t
4633: , hz_party_sites ps
4634: WHERE t.task_id = p_task_id
4635: AND ps.party_site_id(+) = t.address_id;
4636:
4637: BEGIN

Line 4686: FROM hz_party_sites ps

4682: , l.city
4683: , l.state
4684: , l.province
4685: , l.country
4686: FROM hz_party_sites ps
4687: , hz_locations l
4688: WHERE ps.party_site_id = p_party_site_id
4689: AND l.location_id = ps.location_id;
4690:

Line 4702: , hz_party_sites ps

4698: , l.state
4699: , l.province
4700: , l.country
4701: FROM jtf_tasks_b t
4702: , hz_party_sites ps
4703: , hz_locations l
4704: WHERE t.task_id = p_task_id
4705: AND ps.party_site_id(+) = t.address_id
4706: AND l.location_id = NVL(t.location_id, ps.location_id);

Line 5668: hz_party_sites s,

5664: s.party_site_name,
5665: s.addressee,
5666: csf_tasks_pub.return_primary_phone(s.party_site_id) phone_no
5667: FROM hz_locations l,
5668: hz_party_sites s,
5669: hz_parties p
5670: WHERE s.location_id = p_location_id
5671: AND l.location_id = s.location_id
5672: AND s.party_id = p.party_id

Line 5723: from jtf_tasks_b t, hz_party_sites ps

5719: t.location_id,
5720: t.address_id,
5721: t.customer_id,
5722: NVL(t.location_id, ps.location_id) loc_id
5723: from jtf_tasks_b t, hz_party_sites ps
5724: where task_id=p_task_id
5725: AND ps.party_site_id(+) = t.address_id;
5726: l_task_dtls c_task_details%rowtype;
5727: