DBA Data[Home] [Help]

APPS.IGR_I_PKG_ITEM_PKG dependencies on AMS_DELIVERABLES_ALL_B

Line 104: FROM ams_deliverables_all_b

100: DECLARE
101:
102: CURSOR c_ams_deliverables (p_package_item_id igr_i_pkg_item.package_item_id%TYPE) IS
103: SELECT deliverable_id
104: FROM ams_deliverables_all_b
105: WHERE deliverable_id = p_package_item_id;
106: l_deliverable_id AMS_DELIVERABLES_ALL_B.deliverable_id%TYPE;
107: BEGIN
108:

Line 106: l_deliverable_id AMS_DELIVERABLES_ALL_B.deliverable_id%TYPE;

102: CURSOR c_ams_deliverables (p_package_item_id igr_i_pkg_item.package_item_id%TYPE) IS
103: SELECT deliverable_id
104: FROM ams_deliverables_all_b
105: WHERE deliverable_id = p_package_item_id;
106: l_deliverable_id AMS_DELIVERABLES_ALL_B.deliverable_id%TYPE;
107: BEGIN
108:
109: IF (((old_references.package_item_id = new_references.package_item_id)) OR
110: ((new_references.package_item_id IS NULL))) THEN