DBA Data[Home] [Help]

APPS.PA_PROGRESS_UTILS dependencies on PA_RESOURCE_LIST_MEMBERS

Line 6880: FROM pa_resource_list_members

6876: FUNCTION get_resource_list_id ( p_resource_list_member_id NUMBER) RETURN NUMBER IS
6877: CURSOR cur_res_list_id
6878: IS
6879: SELECT resource_list_id
6880: FROM pa_resource_list_members
6881: WHERE resource_list_member_id = p_resource_list_member_id ;
6882:
6883: l_resource_list_id NUMBER;
6884: BEGIN

Line 8458: l_person_id pa_resource_list_members.person_id%TYPE;

8454: l_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE;
8455: l_mfc_cost_source CONSTANT NUMBER := 2;
8456: l_item_category_id pa_resource_assignments.item_category_id%TYPE;
8457: l_job_id pa_resource_assignments.job_id%TYPE;
8458: l_person_id pa_resource_list_members.person_id%TYPE;
8459:
8460: --Out variables
8461: l_trxn_curr_code varchar2(100);
8462: l_txn_raw_cost number;

Line 8578: pa_resource_list_members rlm

8574: pra.resource_assignment_id,
8575: rlm.alias
8576: FROM pa_resource_assignments pra, ----pa_task_assignments_v 4871809
8577: pa_budget_versions pbv,
8578: pa_resource_list_members rlm
8579: WHERE pbv.project_structure_version_id = c_structure_version_id
8580: AND pbv.budget_version_id = pra.budget_version_id
8581: AND pra.task_id = c_task_id
8582: AND pra.resource_list_member_id = c_resource_list_member_id

Line 10147: pa_resource_list_members rlm,

10143: FROM
10144: pa_proj_element_versions pev,
10145: pa_proj_elements pe,
10146: pa_resource_assignments ra,
10147: pa_resource_list_members rlm,
10148: pa_budget_lines bl,
10149: pa_progress_rollup pr
10150: WHERE
10151: pev.parent_structure_version_id = p_struct_ver_id AND