APPS.BIM_TARGET_SEGMENT_PKG dependencies on AMS_LIST_ENTRIES

Line 8: more than once in AMS_LIST_ENTRIES, we just want the

4: FUNCTION target_segment_fk(p_customer_id number,
5: p_source_code varchar2) RETURN NUMBER AS
6:
7: /* Since customer_id,p_source_code combinations could occur
8: more than once in AMS_LIST_ENTRIES, we just want the
9: latest
10: */
11:
12: CURSOR LC_CELL IS

Line 16: AMS_LIST_ENTRIES LIST

12: CURSOR LC_CELL IS
13: SELECT CELL_ID
14: FROM
15: AMS_CELLS_ALL_B CELL,
16: AMS_LIST_ENTRIES LIST
17: WHERE
18: LIST.CUSTOMER_ID = P_CUSTOMER_ID AND
19: LIST.SOURCE_CODE = P_SOURCE_CODE AND
20: CELL.CELL_CODE = LIST.CELL_CODE AND