DBA Data[Home] [Help]

APPS.CSI_MASS_EDIT_PUB dependencies on CSI_LOOKUPS

Line 586: csi_lookups b

582: l_name,
583: l_batch_sch_date,
584: l_system_cascade
585: FROM csi_mass_edit_entries_vl a,
586: csi_lookups b
587: WHERE a.entry_id = p_entry_id
588: AND a.status_code = 'SCHEDULED'
589: AND a.schedule_date <= SYSDATE
590: AND b.lookup_type = 'CSI_IB_TXN_TYPE_CODE'

Line 2366: csi_lookups clkps

2362: BEGIN
2363: SELECT cmee.txn_line_id
2364: INTO l_txn_line_id
2365: FROM csi_mass_edit_entries_vl cmee,
2366: csi_lookups clkps
2367: WHERE cmee.entry_id = p_entry_id
2368: --AND cmee.status_code = 'SCHEDULED'
2369: AND cmee.schedule_date <= SYSDATE
2370: AND clkps.lookup_type = 'CSI_IB_TXN_TYPE_CODE'