APPS.IGR_GEN_001 dependencies on AMS_P_DELIVERABLES_V

Line 1618: AMS_P_DELIVERABLES_V apd

1614:
1615: CURSOR c_eitpi IS
1616: SELECT akit.deliverable_kit_part_id
1617: FROM AMS_DELIV_KIT_ITEMS akit,
1618: AMS_P_DELIVERABLES_V apd
1619: WHERE apd.deliverable_name = p_enquiry_information_type
1620: AND apd.deliverable_id = akit.deliverable_kit_id;
1621:
1622:

Line 1629: AMS_P_DELIVERABLES_V apd

1625: CURSOR c_eapit_eitpi(
1626: cp_enquiry_package_item_id AMS_DELIV_KIT_ITEMS.deliverable_kit_part_id%TYPE) IS
1627: SELECT 'X' FROM IGR_I_A_ITYPE eapit,
1628: AMS_DELIV_KIT_ITEMS akit,
1629: AMS_P_DELIVERABLES_V apd
1630: WHERE eapit.person_id = p_person_id AND
1631: eapit.enquiry_appl_number = p_enquiry_appl_number AND
1632: apd.deliverable_name<> p_enquiry_information_type AND
1633: apd.deliverable_id = akit.deliverable_kit_id AND

Line 1735: FROM AMS_P_DELIVERABLES_V apd,

1731: v_dummy VARCHAR2(1);
1732: --(This cursor is changed as a part of the SQL tuning bug 4991561)
1733: CURSOR c_eitpi IS
1734: SELECT akit.deliverable_kit_part_id
1735: FROM AMS_P_DELIVERABLES_V apd,
1736: AMS_P_DELIVERABLES_V apd1,
1737: AMS_DELIV_KIT_ITEMS akit
1738: WHERE apd.deliverable_id = akit.deliverable_kit_part_id
1739: AND apd.actual_avail_from_date <= SYSDATE

Line 1736: AMS_P_DELIVERABLES_V apd1,

1732: --(This cursor is changed as a part of the SQL tuning bug 4991561)
1733: CURSOR c_eitpi IS
1734: SELECT akit.deliverable_kit_part_id
1735: FROM AMS_P_DELIVERABLES_V apd,
1736: AMS_P_DELIVERABLES_V apd1,
1737: AMS_DELIV_KIT_ITEMS akit
1738: WHERE apd.deliverable_id = akit.deliverable_kit_part_id
1739: AND apd.actual_avail_from_date <= SYSDATE
1740: AND apd.actual_avail_to_date >= SYSDATE