DBA Data[Home] [Help]

APPS.CN_REASONS_PUB dependencies on FND_USER

Line 80: FROM cn_reasons r,fnd_user u,cn_lookups l

76: AND w.payment_worksheet_id = p_payment_worksheet_id;
77: --
78: CURSOR c2 IS
79: SELECT r.*, u.user_name,l.meaning
80: FROM cn_reasons r,fnd_user u,cn_lookups l
81: WHERE upd_table_id = p_payment_worksheet_id
82: AND r.lookup_type = p_lookup_type
83: AND updated_table = p_table_name
84: AND r.last_updated_by = u.user_id

Line 437: FROM cn_reasons r,fnd_user u,cn_lookups l

433: SELECT v.*
434: FROM
435: (
436: SELECT r.*, u.user_name,l.meaning
437: FROM cn_reasons r,fnd_user u,cn_lookups l
438: WHERE upd_table_id = p_payment_worksheet_id
439: AND r.lookup_type = p_lookup_type
440: AND updated_table = p_table_name
441: AND r.last_updated_by = u.user_id