APPS.PA_CONTROL_ITEMS_UTILS dependencies on PA_CI_TYPES_B

Line 113: from pa_ci_types_b where ci_type_id=p_ci_type_id;

109: where ci_id = p_ci_id;
110:
111: cursor budget_type_code is
112: SELECT impact_budget_type_code
113: from pa_ci_types_b where ci_type_id=p_ci_type_id;
114:
115: citypeimpact ci_type_impact%rowtype;
116: ciimpact ci_impact%rowtype;
117: impact_1 varchar2(1):= 'Y';

Line 130: from pa_control_items ci,pa_ci_types_b ci_type1 ,pa_ci_types_b ci_type2

126: if(impact_bud_type_code = 'DIRECT_COST_ENTRY') then
127: begin
128: select 'Y'
129: into temp
130: from pa_control_items ci,pa_ci_types_b ci_type1 ,pa_ci_types_b ci_type2
131: where ci.ci_type_id = ci_type2.ci_type_id
132: and ci_type2.impact_budget_type_code=impact_bud_type_code
133: and ci.ci_id = p_ci_id_2
134: and ci_type1.ci_type_id = p_ci_type_id_1

Line 146: from pa_control_items ci,pa_ci_types_b ci_type

142: begin
143: if(impact_bud_type_code = 'EDIT_PLANNED_AMOUNTS') then
144: select 'Y'
145: into temp
146: from pa_control_items ci,pa_ci_types_b ci_type
147: where ci.ci_type_id = ci_type.ci_type_id
148: and ci_type.impact_budget_type_code=impact_bud_type_code
149: and ci.ci_id = p_ci_id_2;
150: end if;

Line 317: ,pa_ci_types_b cit

313: ,ps.project_system_status_code system_status_code
314: ,cit.ci_type_class_code ci_type_class
315: ,cit.approval_required_flag approval_required_flag
316: from pa_control_items ci
317: ,pa_ci_types_b cit
318: ,pa_project_statuses ps
319: where ci.ci_id = p_ci_id
320: and ci.ci_type_id = cit.ci_type_id
321: and ci.status_code = ps.project_status_code;

Line 879: FROM pa_lookups pl, pa_control_items pci, pa_ci_types_b pcit

875:
876: CURSOR get_control_item_type
877: IS
878: SELECT pl.meaning,pl.lookup_code
879: FROM pa_lookups pl, pa_control_items pci, pa_ci_types_b pcit
880: WHERE
881: pl.lookup_type = 'PA_CI_TYPE_CLASSES'
882: and pci.ci_type_id = pcit.ci_type_id
883: and pl.lookup_code = pcit.ci_type_class_code

Line 1250: FROM pa_ci_types_b cit,

1246: --start: 23-July-2009 cklee Bug: 8580992 ENC enhancement
1247: /***
1248: SELECT ci_type_class_code, approval_required_flag
1249: INTO l_type, l_approval_required
1250: FROM pa_ci_types_b cit,
1251: pa_control_items ci
1252: WHERE ci.ci_id = p_ci_id
1253: and cit.ci_type_id = ci.ci_type_id;
1254:

Line 1272: FROM pa_ci_types_b cit,

1268: when 'AUTOMATIC_APPROVAL' THEN 'A'
1269: else 'A'
1270: end ) l_approval_required
1271: INTO l_approval_required
1272: FROM pa_ci_types_b cit,
1273: pa_control_items ci
1274: WHERE ci.ci_id = p_ci_id
1275: and cit.ci_type_id = ci.ci_type_id
1276: and cit.ci_type_class_code IN ('CHANGE_ORDER', 'CHANGE_REQUEST', 'ISSUE'); --9882753

Line 1301: from pa_ci_types_b cit

1297: end if;
1298:
1299: select
1300: resolution_required_flag into l_resolution_required
1301: from pa_ci_types_b cit
1302: ,pa_control_items ci
1303: where ci.ci_id = p_ci_id
1304: and cit.ci_type_id = ci.ci_type_id;
1305:

Line 1320: from pa_ci_types_b cit

1316: is
1317: cursor get_resolution_info is
1318: select
1319: resolution_required_flag, resolution_code_id, resolution
1320: from pa_ci_types_b cit
1321: ,pa_control_items ci
1322: where ci.ci_id = p_ci_id
1323: and cit.ci_type_id = ci.ci_type_id;
1324:

Line 1359: from pa_ci_types_b cit

1355: end if;
1356:
1357: select
1358: ci_type_class_code into l_type_class_code
1359: from pa_ci_types_b cit
1360: ,pa_control_items ci
1361: where ci.ci_id = p_ci_id
1362: and cit.ci_type_id = ci.ci_type_id;
1363:

Line 1607: FROM pa_ci_types_b

1603: tmp NUMBER;
1604: BEGIN
1605: SELECT 1
1606: INTO tmp
1607: FROM pa_ci_types_b
1608: WHERE ( classification_category = p_class_category
1609: OR reason_category = p_class_category
1610: OR resolution_category = p_class_category)
1611: AND ROWNUM = 1;

Line 1651: FROM pa_ci_types_b cit,

1647: tmp NUMBER;
1648: BEGIN
1649: SELECT 1
1650: INTO tmp
1651: FROM pa_ci_types_b cit,
1652: pa_object_dist_lists odl,
1653: pa_dist_list_items dli
1654: WHERE odl.object_type = 'PA_CI_TYPES'
1655: AND odl.object_id = cit.ci_type_id

Line 1813: from pa_control_items pci, pa_ci_types_b pctb

1809: merged the similar select for change order/request/issue using the bind variable p_item_type*/
1810: if (p_item_type = 'ISSUE' or p_item_type = 'CHANGE_ORDER' or p_item_type = 'CHANGE_REQUEST') then
1811: select count(*)
1812: into tot_num
1813: from pa_control_items pci, pa_ci_types_b pctb
1814: where pci.project_id = p_project_id
1815: and pci.object_type = p_object_type
1816: and pci.object_id = p_object_id
1817: and pci.ci_type_id = pctb.ci_type_id

Line 1828: from pa_control_items pci, pa_ci_types_b pctb

1824:
1825: elsif (p_item_type = 'CHANGE') then
1826: select count(*)
1827: into tot_num
1828: from pa_control_items pci, pa_ci_types_b pctb
1829: where pci.project_id = p_project_id
1830: and pci.object_type = p_object_type
1831: and pci.object_id = p_object_id
1832: and pci.ci_type_id = pctb.ci_type_id

Line 1843: -- from pa_control_items pci, pa_ci_types_b pctb

1839:
1840: -- elsif (p_item_type = 'CHANGE_ORDER') then
1841: -- select count(*)
1842: -- into tot_num
1843: -- from pa_control_items pci, pa_ci_types_b pctb
1844: -- where pci.project_id = p_project_id
1845: -- and pci.object_type = p_object_type
1846: -- and pci.object_id = p_object_id
1847: -- and pci.ci_type_id = pctb.ci_type_id

Line 1858: -- from pa_control_items pci, pa_ci_types_b pctb

1854:
1855: -- elsif (p_item_type = 'CHANGE_REQUEST') then
1856: -- select count(*)
1857: -- into tot_num
1858: -- from pa_control_items pci, pa_ci_types_b pctb
1859: -- where pci.project_id = p_project_id
1860: -- and pci.object_type = p_object_type
1861: -- and pci.object_id = p_object_id
1862: -- and pci.ci_type_id = pctb.ci_type_id

Line 2219: FROM pa_lookups pl, pa_control_items pci, pa_ci_types_b pcit

2215:
2216: CURSOR get_control_item_type
2217: IS
2218: SELECT pl.meaning,pl.lookup_code
2219: FROM pa_lookups pl, pa_control_items pci, pa_ci_types_b pcit
2220: WHERE
2221: pl.lookup_type = 'PA_CI_TYPE_CLASSES'
2222: and pci.ci_type_id = pcit.ci_type_id
2223: and pl.lookup_code = pcit.ci_type_class_code