APPS.CSP_SHIP_TO_ADDRESS_PVT dependencies on JTF_RS_RESOURCE_EXTNS

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 2494: from jtf_rs_resource_extns jrre,

2490:
2491:
2492: CURSOR c_party_id IS
2493: select papf.party_id
2494: from jtf_rs_resource_extns jrre,
2495: per_all_people_f papf
2496: where papf.person_id = jrre.source_id
2497: and jrre.resource_id = l_resource_id
2498: and trunc(sysdate) between trunc(papf.effective_start_date) and

Line 2503: from jtf_rs_resource_extns jrre,

2499: trunc(papf.effective_end_date)
2500: and jrre.category = 'EMPLOYEE'
2501: UNION ALL
2502: select hp.party_id
2503: from jtf_rs_resource_extns jrre,
2504: hz_parties hp
2505: where hp.party_id = jrre.source_id
2506: and jrre.resource_id = l_resource_id
2507: and jrre.category = 'PARTY';

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