APPS.PA_GENERATE_FORECAST_PUB dependencies on PA_RESOURCE_TXN_ATTRIBUTES

Line 9: PA_RESOURCE_TXN_ATTRIBUTES WHERE

5: RETURN NUMBER IS
6: x_person_id NUMBER;
7: BEGIN
8: SELECT person_id INTO x_person_id FROM
9: PA_RESOURCE_TXN_ATTRIBUTES WHERE
10: RESOURCE_ID = p_res_id;
11: RETURN x_person_id;
12: EXCEPTION
13: WHEN NO_DATA_FOUND THEN

Line 937: PA_RESOURCE_LIST_MEMBERS RLM, PA_RESOURCES R, PA_RESOURCE_TXN_ATTRIBUTES RT

933: BEGIN
934: SELECT RLM.RESOURCE_LIST_MEMBER_ID INTO
935: l_resource_list_member_id
936: FROM
937: PA_RESOURCE_LIST_MEMBERS RLM, PA_RESOURCES R, PA_RESOURCE_TXN_ATTRIBUTES RT
938: WHERE
939: RLM.RESOURCE_LIST_ID = l_fcst_res_list AND
940: RLM.RESOURCE_ID = R.RESOURCE_ID AND
941: RT.RESOURCE_ID = R.RESOURCE_ID AND