DBA Data[Home] [Help]

APPS.PA_CONTROL_API_PVT dependencies on PA_OBJ_STATUS_LISTS

Line 1609: pa_obj_status_lists obj,

1605: cursor get_strtng_sts_frm_sts_nme(p_ci_type_id number, p_status 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

Line 1626: pa_obj_status_lists obj,

1622: cursor get_strtng_sts_frm_sts_cde(p_ci_type_id number, p_status_code varchar2)
1623: is
1624: select pstat.project_status_code, pstat.project_status_name, pstat.project_system_status_code
1625: from
1626: pa_obj_status_lists obj,
1627: pa_status_lists list,
1628: pa_status_list_items item,
1629: pa_project_statuses pstat
1630: where obj.object_id = p_ci_type_id