APPS.PA_RESOURCE_UTILS dependencies on PA_RESOURCE_TXN_ATTRIBUTES

Line 1670: FROM pa_resource_txn_attributes

1666: IF P_resourceid is NOT NULL then
1667: -- may raise too many rows exception
1668: SELECT Person_id
1669: INTO x_personId
1670: FROM pa_resource_txn_attributes
1671: WHERE resource_id = P_ResourceId;
1672:
1673: IF x_PersonId is NULL then
1674: raise PersonException;

Line 1950: FROM pa_resource_txn_attributes

1946: BEGIN
1947:
1948: SELECT resource_id
1949: INTO l_resource_id
1950: FROM pa_resource_txn_attributes
1951: WHERE person_id = p_person_id;
1952:
1953: RETURN l_resource_id;
1954: EXCEPTION

Line 2750: FROM pa_resource_txn_attributes

2746: IF p_person_id IS NOT NULL then
2747:
2748: SELECT 'Y'
2749: INTO x_valid
2750: FROM pa_resource_txn_attributes
2751: WHERE person_id = p_person_id
2752: AND rownum = 1;
2753:
2754: ELSIF p_party_id IS NOT NULL then

Line 2758: FROM pa_resource_txn_attributes

2754: ELSIF p_party_id IS NOT NULL then
2755:
2756: SELECT 'Y'
2757: INTO x_valid
2758: FROM pa_resource_txn_attributes
2759: WHERE party_id = p_party_id
2760: AND rownum = 1;
2761:
2762: END IF;

Line 3412: FROM pa_resource_txn_attributes

3408: BEGIN
3409:
3410: SELECT person_id
3411: INTO l_person_id
3412: FROM pa_resource_txn_attributes
3413: WHERE resource_id = p_resource_id;
3414:
3415: RETURN l_person_id;
3416: EXCEPTION

Line 3688: FROM pa_resource_txn_attributes

3684: BEGIN
3685:
3686: SELECT party_id
3687: INTO l_party_id
3688: FROM pa_resource_txn_attributes
3689: WHERE resource_id = p_resource_id;
3690:
3691: RETURN l_party_id;
3692: EXCEPTION

Line 3908: FROM pa_resource_txn_attributes

3904: RETURN get_resource_id(p_person_id => l_emp_id);
3905: ELSIF l_cust_id IS NOT NULL THEN
3906: SELECT resource_id
3907: INTO l_res_id
3908: FROM pa_resource_txn_attributes
3909: WHERE party_id = l_cust_id;
3910:
3911: RETURN l_res_id;
3912: END IF;