DBA Data[Home] [Help]

APPS.PA_PROGRESS_UTILS dependencies on PA_RESOURCE_LIST_MEMBERS

Line 6840: FROM pa_resource_list_members

6836: FUNCTION get_resource_list_id ( p_resource_list_member_id NUMBER) RETURN NUMBER IS
6837: CURSOR cur_res_list_id
6838: IS
6839: SELECT resource_list_id
6840: FROM pa_resource_list_members
6841: WHERE resource_list_member_id = p_resource_list_member_id ;
6842:
6843: l_resource_list_id NUMBER;
6844: BEGIN

Line 8412: l_person_id pa_resource_list_members.person_id%TYPE;

8408: l_mfc_cost_type_id pa_resource_assignments.mfc_cost_type_id%TYPE;
8409: l_mfc_cost_source CONSTANT NUMBER := 2;
8410: l_item_category_id pa_resource_assignments.item_category_id%TYPE;
8411: l_job_id pa_resource_assignments.job_id%TYPE;
8412: l_person_id pa_resource_list_members.person_id%TYPE;
8413:
8414: --Out variables
8415: l_trxn_curr_code varchar2(100);
8416: l_txn_raw_cost number;

Line 8532: pa_resource_list_members rlm

8528: pra.resource_assignment_id,
8529: rlm.alias
8530: FROM pa_resource_assignments pra, ----pa_task_assignments_v 4871809
8531: pa_budget_versions pbv,
8532: pa_resource_list_members rlm
8533: WHERE pbv.project_structure_version_id = c_structure_version_id
8534: AND pbv.budget_version_id = pra.budget_version_id
8535: AND pra.task_id = c_task_id
8536: AND pra.resource_list_member_id = c_resource_list_member_id

Line 10073: pa_resource_list_members rlm,

10069: FROM
10070: pa_proj_element_versions pev,
10071: pa_proj_elements pe,
10072: pa_resource_assignments ra,
10073: pa_resource_list_members rlm,
10074: pa_budget_lines bl,
10075: pa_progress_rollup pr
10076: WHERE
10077: pev.parent_structure_version_id = p_struct_ver_id AND