APPS.CSF_TASKS_PUB dependencies on CS_SR_CONTACT_POINTS_V

Line 4870: l_contact_type cs_sr_contact_points_v.contact_type%TYPE;

4866: , x_email_address OUT NOCOPY VARCHAR2
4867: ) IS
4868: l_contact_source CONSTANT VARCHAR2(10) := fnd_profile.value('CSF_DFLT_SOURCE_FOR_CONTACT');
4869:
4870: l_contact_type cs_sr_contact_points_v.contact_type%TYPE;
4871: l_contact_point_id cs_sr_contact_points_v.contact_point_id%TYPE;
4872: l_party_id cs_sr_contact_points_v.party_id%TYPE;
4873:
4874: -- Cursor to fetch the Task Contact Points

Line 4871: l_contact_point_id cs_sr_contact_points_v.contact_point_id%TYPE;

4867: ) IS
4868: l_contact_source CONSTANT VARCHAR2(10) := fnd_profile.value('CSF_DFLT_SOURCE_FOR_CONTACT');
4869:
4870: l_contact_type cs_sr_contact_points_v.contact_type%TYPE;
4871: l_contact_point_id cs_sr_contact_points_v.contact_point_id%TYPE;
4872: l_party_id cs_sr_contact_points_v.party_id%TYPE;
4873:
4874: -- Cursor to fetch the Task Contact Points
4875: CURSOR c_task_contact_points IS

Line 4872: l_party_id cs_sr_contact_points_v.party_id%TYPE;

4868: l_contact_source CONSTANT VARCHAR2(10) := fnd_profile.value('CSF_DFLT_SOURCE_FOR_CONTACT');
4869:
4870: l_contact_type cs_sr_contact_points_v.contact_type%TYPE;
4871: l_contact_point_id cs_sr_contact_points_v.contact_point_id%TYPE;
4872: l_party_id cs_sr_contact_points_v.party_id%TYPE;
4873:
4874: -- Cursor to fetch the Task Contact Points
4875: CURSOR c_task_contact_points IS
4876: SELECT pc.person_last_name last_name

Line 4895: FROM cs_sr_contact_points_v

4891: , sub_title title
4892: , contact_point_id
4893: , party_id
4894: , contact_type
4895: FROM cs_sr_contact_points_v
4896: WHERE incident_id = p_incident_id
4897: AND primary_flag = 'Y';
4898:
4899: -- Cursor to fetch the Phone Number of Contacts