DBA Data[Home] [Help]

APPS.PA_RESOURCE_UTILS dependencies on HZ_PARTIES

Line 3952: FROM per_all_people_f peo, hz_parties hzp

3948: IF l_resource_type_code = 'EMPLOYEE' THEN
3949:
3950: SELECT hzp.party_name
3951: INTO l_name
3952: FROM per_all_people_f peo, hz_parties hzp
3953: WHERE peo.person_id = p_resource_source_id
3954: AND sysdate BETWEEN peo.effective_start_date AND
3955: peo.effective_end_date
3956: AND peo.party_id = hzp.party_id;

Line 3964: FROM hz_parties hzp

3960: ELSIF l_resource_type_code = 'HZ_PARTY' THEN
3961:
3962: SELECT hzp.party_name
3963: INTO l_name
3964: FROM hz_parties hzp
3965: WHERE hzp.party_id = p_resource_source_id;
3966:
3967: RETURN l_name;
3968: