APPS.PA_DEDUCTIONS_PUB dependencies on PA_CONTROL_ITEMS

Line 60: FROM PA_CONTROL_ITEMS citem,

56: CURSOR C2 IS
57: SELECT ci_number,
58: DECODE(ci_type_class_code,'CHANGE_ORDER', 'Change Order',
59: 'CHANGE_REQUEST', 'Change Request') document_type
60: FROM PA_CONTROL_ITEMS citem,
61: PA_CI_TYPES_VL ctype
62: WHERE citem.ci_type_id = ctype.ci_type_id
63: AND citem.ci_id = p_ci_id;
64: