APPS.CSI_MASS_EDIT_PUB dependencies on CSI_LOOKUPS

Line 687: csi_lookups b

683: l_name,
684: l_batch_sch_date,
685: l_system_cascade
686: FROM csi_mass_edit_entries_vl a,
687: csi_lookups b
688: WHERE a.entry_id = p_entry_id
689: AND a.status_code = 'SCHEDULED'
690: AND a.schedule_date <= SYSDATE
691: AND b.lookup_type = 'CSI_IB_TXN_TYPE_CODE'

Line 2481: csi_lookups clkps

2477: BEGIN
2478: SELECT cmee.txn_line_id
2479: INTO l_txn_line_id
2480: FROM csi_mass_edit_entries_vl cmee,
2481: csi_lookups clkps
2482: WHERE cmee.entry_id = p_entry_id
2483: --AND cmee.status_code = 'SCHEDULED'
2484: AND cmee.schedule_date <= SYSDATE
2485: AND clkps.lookup_type = 'CSI_IB_TXN_TYPE_CODE'

Line 4914: CSI_LOOKUPS LK

4910: INTO l_cust_sys_id
4911: FROM
4912: ( SELECT sys.system_id
4913: FROM csi_systems_vl sys, HZ_PARTIES hzp, HZ_CUST_ACCOUNTS acct,
4914: CSI_LOOKUPS LK
4915: WHERE sys.CUSTOMER_ID = acct.CUST_ACCOUNT_ID
4916: and acct.PARTY_ID = hzp.PARTY_ID
4917: and acct.account_number = l_instance.OWNER_ACCOUNT_NUMBER
4918: and sys.SYSTEM_TYPE_CODE = LK.LOOKUP_CODE(+)

Line 4924: HZ_CUST_ACCT_RELATE_ALL acctall, CSI_LOOKUPS LK

4920: and sys.name = l_instance.SYSTEM_NAME
4921: UNION
4922: SELECT sys.system_id
4923: FROM csi_systems_vl sys, HZ_PARTIES hzp, HZ_CUST_ACCOUNTS acct,
4924: HZ_CUST_ACCT_RELATE_ALL acctall, CSI_LOOKUPS LK
4925: WHERE sys.CUSTOMER_ID = acctall.RELATED_CUST_ACCOUNT_ID
4926: and sys.CUSTOMER_ID = acct.CUST_ACCOUNT_ID
4927: and acct.PARTY_ID = hzp.PARTY_ID
4928: and acctall.CUST_ACCOUNT_ID = acct.CUST_ACCOUNT_ID

Line 6517: FROM CSI_LOOKUPS LK, csi_systems_v s

6513: BEGIN
6514: UPDATE csi_webadi_staging cws SET SYSTEM_ID =
6515: (
6516: select s.SYSTEM_ID
6517: FROM CSI_LOOKUPS LK, csi_systems_v s
6518: WHERE s.SYSTEM_TYPE_CODE = LK.LOOKUP_CODE(+)
6519: AND LK.LOOKUP_TYPE (+) = 'CSI_SYSTEM_TYPE'
6520: AND s.NAME = cws.SYSTEM_NAME
6521: )