DBA Data[Home] [Help]

APPS.PA_RESOURCE_UTILS dependencies on HZ_PARTIES

Line 4288: FROM per_all_people_f peo, hz_parties hzp

4284: IF l_resource_type_code = 'EMPLOYEE' THEN
4285:
4286: SELECT hzp.party_name
4287: INTO l_name
4288: FROM per_all_people_f peo, hz_parties hzp
4289: WHERE peo.person_id = p_resource_source_id
4290: AND sysdate BETWEEN peo.effective_start_date AND
4291: peo.effective_end_date
4292: AND peo.party_id = hzp.party_id;

Line 4300: FROM hz_parties hzp

4296: ELSIF l_resource_type_code = 'HZ_PARTY' THEN
4297:
4298: SELECT hzp.party_name
4299: INTO l_name
4300: FROM hz_parties hzp
4301: WHERE hzp.party_id = p_resource_source_id;
4302:
4303: RETURN l_name;
4304: