APPS.CSP_SHIP_TO_ADDRESS_PVT dependencies on JTF_RS_RESOURCE_EXTNS_VL

Line 2223: l_resource_name jtf_rs_resource_extns_vl.resource_name%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;
2227: l_last_name hz_parties.person_last_name%TYPE := NULL;

Line 2535: from jtf_rs_resource_extns_vl

2531: select resource_name,
2532: source_first_name,
2533: source_middle_name,
2534: source_last_name
2535: from jtf_rs_resource_extns_vl
2536: where category = substr(l_resource_type, 4) and resource_id = l_resource_id;
2537:
2538: -- CURSOR l_sql_str_csr IS
2539: -- select 'select '||select_id||' select_id, '||select_name||' select_name '|| 'from '||from_table sql_str, where_clause