APPS.PA_CI_SUPPLIER_PKG dependencies on PA_CONTROL_ITEMS

Line 77: from pa_control_items

73: prac.resource_assignment_id = pra.resource_assignment_id;
74:
75: cursor get_ciTypeId is
76: select ci_type_id
77: from pa_control_items
78: where ci_id = p_ci_id;
79:
80: cursor get_res_asgn_id is
81: select pa_resource_assignments_s.nextval

Line 105: from pa_control_items

101: budget_version_id in (select fin_plan_version_id from pa_proj_fp_options where project_id = proj_id and fin_plan_preference_code = 'REVENUE_ONLY');
102:
103: cursor get_project_id is
104: select project_id
105: from pa_control_items
106: where ci_id = p_ci_id;
107:
108: cursor get_elem_ver_id (proj_id number) is
109: select pev.element_version_id,parent_structure_version_id

Line 166: pa_control_items pci

162: ppfo.COST_RES_CLASS_RATE_SCH_ID,
163: ppfo.RES_CLASS_BILL_RATE_SCH_ID,
164: ppfo.REV_RES_CLASS_RATE_SCH_ID
165: FROM pa_proj_fp_options ppfo,
166: pa_control_items pci
167: WHERE pci.ci_id = p_ci_id and
168: pci.project_id = ppfo.project_id and
169: NVL(ppfo.Approved_Cost_Plan_Type_Flag ,'N') = 'Y' and
170: ppfo.Fin_Plan_Option_Level_Code = 'PLAN_TYPE';

Line 1009: from pa_control_items

1005: where ci_id = p_ci_id;
1006:
1007: cursor get_project_id is
1008: select project_id
1009: from pa_control_items
1010: where ci_id = p_ci_id;
1011:
1012: cursor get_resource_assignment_id(bv_Id number) is
1013: select resource_assignment_id

Line 1039: pa_control_items pci

1035: ppfo.COST_RES_CLASS_RATE_SCH_ID,
1036: ppfo.RES_CLASS_BILL_RATE_SCH_ID,
1037: ppfo.REV_RES_CLASS_RATE_SCH_ID
1038: FROM pa_proj_fp_options ppfo,
1039: pa_control_items pci
1040: WHERE pci.ci_id = p_ci_id and
1041: pci.project_id = ppfo.project_id and
1042: NVL(ppfo.Approved_Cost_Plan_Type_Flag ,'N') = 'Y' and
1043: ppfo.Fin_Plan_Option_Level_Code = 'PLAN_TYPE';