APPS.CSP_SHIP_TO_ADDRESS_PVT dependencies on JTF_RS_RESOURCE_EXTNS_VL

Line 2729: l_resource_name jtf_rs_resource_extns_vl.resource_name%TYPE := NULL;

2725: l_location_id hr_locations_all.location_id%TYPE := NULL;
2726: l_inv_location_id hr_locations_all.location_id%TYPE := NULL;
2727: l_resource_id jtf_task_assignments.resource_id%TYPE := NULL;
2728: l_resource_type jtf_task_assignments.resource_type_code%TYPE := NULL;
2729: l_resource_name jtf_rs_resource_extns_vl.resource_name%TYPE := NULL;
2730: l_party_id hz_parties.party_id%TYPE := NULL;
2731: l_first_name hz_parties.person_first_name%TYPE := NULL;
2732: l_middle_name hz_parties.person_middle_name%TYPE := NULL;
2733: l_last_name hz_parties.person_last_name%TYPE := NULL;

Line 3043: from jtf_rs_resource_extns_vl

3039: select resource_name,
3040: source_first_name,
3041: source_middle_name,
3042: source_last_name
3043: from jtf_rs_resource_extns_vl
3044: where category = substr(l_resource_type, 4) and resource_id = l_resource_id;
3045:
3046: -- CURSOR l_sql_str_csr IS
3047: -- select 'select '||select_id||' select_id, '||select_name||' select_name '|| 'from '||from_table sql_str, where_clause