APPS.PA_ASSIGNMENTS_PVT dependencies on PA_RES_FORMATS_B

Line 579: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;

575: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
576: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
577: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
578: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
579: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;
580:
581:
582: CURSOR get_linked_res_asgmts IS
583: SELECT resource_assignment_id, wbs_element_version_id, budget_version_id, project_structure_version_id

Line 625: FROM pa_res_formats_b rf,

621: ORDER BY budget_version_id, project_structure_version_id;
622:
623: CURSOR get_res_mand_attributes IS
624: SELECT rf.ROLE_ENABLED_FLAG
625: FROM pa_res_formats_b rf,
626: pa_resource_list_members rlm,
627: pa_project_assignments pa
628: WHERE pa.assignment_id = p_assignment_id
629: AND pa.resource_list_member_id IS NOT NULL