APPS.CSP_SHIP_TO_ADDRESS_PVT dependencies on JTF_TASK_ASSIGNMENTS

Line 2221: l_resource_id jtf_task_assignments.resource_id%TYPE := NULL;

2217: l_customer_id hz_cust_accounts.cust_account_id%TYPE := NULL;
2218: t_customer_id hz_cust_accounts.cust_account_id%TYPE := NULL;
2219: l_location_id hr_locations_all.location_id%TYPE := NULL;
2220: l_inv_location_id hr_locations_all.location_id%TYPE := NULL;
2221: l_resource_id jtf_task_assignments.resource_id%TYPE := NULL;
2222: l_resource_type jtf_task_assignments.resource_type_code%TYPE := NULL;
2223: l_resource_name jtf_rs_resource_extns_vl.resource_name%TYPE := NULL;
2224: l_party_id hz_parties.party_id%TYPE := NULL;
2225: l_first_name hz_parties.person_first_name%TYPE := NULL;

Line 2222: l_resource_type jtf_task_assignments.resource_type_code%TYPE := NULL;

2218: t_customer_id hz_cust_accounts.cust_account_id%TYPE := NULL;
2219: l_location_id hr_locations_all.location_id%TYPE := NULL;
2220: l_inv_location_id hr_locations_all.location_id%TYPE := NULL;
2221: l_resource_id jtf_task_assignments.resource_id%TYPE := NULL;
2222: l_resource_type jtf_task_assignments.resource_type_code%TYPE := NULL;
2223: l_resource_name jtf_rs_resource_extns_vl.resource_name%TYPE := NULL;
2224: l_party_id hz_parties.party_id%TYPE := NULL;
2225: l_first_name hz_parties.person_first_name%TYPE := NULL;
2226: l_middle_name hz_parties.person_middle_name%TYPE := NULL;

Line 2511: select resource_type_code, resource_id from jtf_task_assignments where task_assignment_id = p_task_assignment_id and assignee_role = 'ASSIGNEE';

2507: and jrre.category = 'PARTY';
2508:
2509:
2510: CURSOR l_resource_id_csr IS
2511: select resource_type_code, resource_id from jtf_task_assignments where task_assignment_id = p_task_assignment_id and assignee_role = 'ASSIGNEE';
2512:
2513: CURSOR l_customer_id_csr IS
2514: select rs_cust_relation_id,
2515: customer_id