APPS.POS_VENDOR_REG_PKG dependencies on POS_ATTRPG_CONFIG

Line 2198: FROM pos_attrpg_config pac,

2194:
2195:
2196: CURSOR c_pages_list(p_supp_reg_id IN NUMBER, p_buyer_user IN VARCHAR2) IS
2197: SELECT pac.page_id
2198: FROM pos_attrpg_config pac,
2199: pos_supplier_registrations psr
2200: WHERE psr.supplier_reg_id = p_supp_reg_id
2201: AND pac.org_id IN (-999, psr.ou_id)
2202: AND DECODE(p_buyer_user, 'Y', pac.internal_update_flag,

Line 2206: FROM pos_attrpg_config pac2

2202: AND DECODE(p_buyer_user, 'Y', pac.internal_update_flag,
2203: 'N', pac.supplier_update_flag) = 'Y'
2204: AND pac.page_id NOT IN
2205: (SELECT pac2.page_id
2206: FROM pos_attrpg_config pac2
2207: WHERE pac2.org_id = psr.ou_id
2208: AND DECODE(p_buyer_user, 'Y', pac2.internal_update_flag,
2209: 'N', pac2.supplier_update_flag) = 'N'
2210: );