APPS.PA_RESOURCE_UTILS dependencies on PA_RESOURCE_TXN_ATTRIBUTES

Line 1782: FROM pa_resource_txn_attributes

1778: IF P_resourceid is NOT NULL then
1779: -- may raise too many rows exception
1780: SELECT Person_id
1781: INTO x_personId
1782: FROM pa_resource_txn_attributes
1783: WHERE resource_id = P_ResourceId;
1784:
1785: IF x_PersonId is NULL then
1786: raise PersonException;

Line 2067: FROM pa_resource_txn_attributes

2063: BEGIN
2064:
2065: SELECT resource_id
2066: INTO l_resource_id
2067: FROM pa_resource_txn_attributes
2068: WHERE person_id = p_person_id;
2069:
2070: RETURN l_resource_id;
2071: EXCEPTION

Line 2867: FROM pa_resource_txn_attributes

2863: IF p_person_id IS NOT NULL then
2864:
2865: SELECT 'Y'
2866: INTO x_valid
2867: FROM pa_resource_txn_attributes
2868: WHERE person_id = p_person_id
2869: AND rownum = 1;
2870:
2871: ELSIF p_party_id IS NOT NULL then

Line 2875: FROM pa_resource_txn_attributes

2871: ELSIF p_party_id IS NOT NULL then
2872:
2873: SELECT 'Y'
2874: INTO x_valid
2875: FROM pa_resource_txn_attributes
2876: WHERE party_id = p_party_id
2877: AND rownum = 1;
2878:
2879: END IF;

Line 3700: FROM pa_resource_txn_attributes

3696: BEGIN
3697:
3698: SELECT person_id
3699: INTO l_person_id
3700: FROM pa_resource_txn_attributes
3701: WHERE resource_id = p_resource_id;
3702:
3703: RETURN l_person_id;
3704: EXCEPTION

Line 4024: FROM pa_resource_txn_attributes

4020: BEGIN
4021:
4022: SELECT party_id
4023: INTO l_party_id
4024: FROM pa_resource_txn_attributes
4025: WHERE resource_id = p_resource_id;
4026:
4027: RETURN l_party_id;
4028: EXCEPTION

Line 4244: FROM pa_resource_txn_attributes

4240: RETURN get_resource_id(p_person_id => l_emp_id);
4241: ELSIF l_cust_id IS NOT NULL THEN
4242: SELECT resource_id
4243: INTO l_res_id
4244: FROM pa_resource_txn_attributes
4245: WHERE party_id = l_cust_id;
4246:
4247: RETURN l_res_id;
4248: END IF;