eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_CONTROL_ITEMS_PVT dependencies on PA_CI_STATUSES_V

Line 1045: SELECT distinct ps.project_status_code FROM pa_ci_statuses_v pc,pa_project_statuses ps where ps.project_status_code=pc.project_status_code

1041: where pcc1.class_code_id = p_reason);
1042: --Bug#13475251 start.
1043: cursor c_get_status(l_code PA_CONTROL_ITEMS.STATUS_CODE%type)
1044: is
1045: SELECT distinct ps.project_status_code FROM pa_ci_statuses_v pc,pa_project_statuses ps where ps.project_status_code=pc.project_status_code
1046: and ps.project_system_status_code =pc.project_system_status_code and ci_type_id = p_ci_type_id
1047: and ps.starting_status_flag = 'Y'
1048: and ci_type_id in (select ci_type_id from pa_ci_types_v ) and ps.project_system_status_code = l_code
1049: ;

Line 1131: -- select distinct count(*) into l_str from pa_ci_statuses_v pc,pa_project_statuses ps where ps.project_status_code=pc.project_status_code

1127:
1128: end if;
1129:
1130: -- Bug#13475251 Changes start.
1131: -- select distinct count(*) into l_str from pa_ci_statuses_v pc,pa_project_statuses ps where ps.project_status_code=pc.project_status_code
1132: -- and ps.project_system_status_code =pc.project_system_status_code and ci_type_id=p_ci_type_id
1133: -- and ps.starting_status_flag = 'Y'
1134: -- and ci_type_id in (select ci_type_id from pa_ci_types_v ) and ps.project_system_status_code ='CI_DRAFT';
1135: -- if l_str = 1 then

Line 1138: -- select distinct count(*) into l_str1 from pa_ci_statuses_v pc,pa_project_statuses ps where ps.project_status_code=pc.project_status_code

1134: -- and ci_type_id in (select ci_type_id from pa_ci_types_v ) and ps.project_system_status_code ='CI_DRAFT';
1135: -- if l_str = 1 then
1136: -- l_ci_system_status := 'CI_DRAFT';
1137: -- else
1138: -- select distinct count(*) into l_str1 from pa_ci_statuses_v pc,pa_project_statuses ps where ps.project_status_code=pc.project_status_code
1139: -- and ps.project_system_status_code =pc.project_system_status_code and ci_type_id=p_ci_type_id
1140: -- and ps.starting_status_flag = 'Y'
1141: -- and ci_type_id in (select ci_type_id from pa_ci_types_v ) and ps.project_system_status_code ='CI_WORKING';
1142: -- if l_str1 = 1 then