DBA Data[Home] [Help]

APPS.PA_CONTROL_API_PVT dependencies on PA_OBJ_STATUS_LISTS

Line 1592: pa_obj_status_lists obj,

1588: cursor get_strtng_sts_frm_sts_nme(p_ci_type_id number, p_status varchar2)
1589: is
1590: select pstat.project_status_code, pstat.project_status_name, pstat.project_system_status_code
1591: from
1592: pa_obj_status_lists obj,
1593: pa_status_lists list,
1594: pa_status_list_items item,
1595: pa_project_statuses pstat
1596: where obj.object_id = p_ci_type_id

Line 1609: pa_obj_status_lists obj,

1605: cursor get_strtng_sts_frm_sts_cde(p_ci_type_id number, p_status_code varchar2)
1606: is
1607: select pstat.project_status_code, pstat.project_status_name, pstat.project_system_status_code
1608: from
1609: pa_obj_status_lists obj,
1610: pa_status_lists list,
1611: pa_status_list_items item,
1612: pa_project_statuses pstat
1613: where obj.object_id = p_ci_type_id