DBA Data[Home] [Help]

APPS.PA_ASSIGNMENT_APPROVAL_PUB dependencies on PA_RES_FORMATS_B

Line 1636: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;

1632: l_task_assignment_id_tbl system.pa_num_tbl_type;
1633: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1634: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1635: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1636: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;
1637:
1638:
1639: CURSOR check_record_version IS
1640: SELECT ROWID, project_id, calendar_id, start_date, end_date, source_assignment_id, project_party_id, resource_id

Line 1705: FROM pa_res_formats_b rf,

1701: ORDER BY budget_version_id, project_structure_version_id;
1702:
1703: CURSOR get_res_mand_attributes IS
1704: SELECT rf.ROLE_ENABLED_FLAG
1705: FROM pa_res_formats_b rf,
1706: pa_resource_list_members rlm,
1707: pa_project_assignments pa
1708: WHERE pa.assignment_id = p_assignment_id
1709: AND pa.resource_list_member_id IS NOT NULL