APPS.CN_ACC_PERIODS_PVT dependencies on CN_LOOKUPS

Line 14: FROM CN_lookups

10:
11: -- Changed cursor fix bug#2804029
12: CURSOR lookup_table IS
13: SELECT lookup_code, meaning
14: FROM CN_lookups
15: WHERE lookup_type = 'PERIOD_CLOSING_STATUS';
16:
17: FUNCTION get_closing_status(p_closing_status_meaning gl_lookups.meaning%TYPE) RETURN gl_lookups.lookup_code%TYPE IS
18: BEGIN

Line 61: cn_lookups cp

57: cp.meaning processing_status,
58: p_freeze_flag,
59: cn.object_version_number
60: FROM cn_period_statuses cn,
61: cn_lookups cp
62: WHERE cp.lookup_type = 'PERIOD_PROCESSING_STATUS'
63: AND cp.lookup_code = nvl(cn.processing_status_code, 'CLEAN')
64: AND cn.period_set_id = l_period_set_id
65: AND cn.period_type_id = l_period_type_id

Line 78: cn_lookups cp

74: p_freeze_flag,
75: cn.object_version_number
76: FROM gl_period_statuses gl,
77: cn_period_statuses cn,
78: cn_lookups cp
79: WHERE gl.set_of_books_id = l_set_of_books_id
80: AND gl.application_id = 283
81: AND gl.adjustment_period_flag = 'N'
82: AND gl.period_name = cn.period_name(+)

Line 643: x_system_status OUT NOCOPY cn_lookups.meaning%TYPE,

639:
640: -- populate the accumulation periods screen
641: PROCEDURE get_acc_periods
642: (p_year IN NUMBER,
643: x_system_status OUT NOCOPY cn_lookups.meaning%TYPE,
644: x_calendar OUT NOCOPY cn_period_sets.period_set_name%TYPE,
645: x_period_type OUT NOCOPY cn_period_types.period_type%TYPE,
646: x_acc_period_tbl OUT NOCOPY acc_period_tbl_type)
647: IS

Line 706: cn_lookups gp,

702: cp.meaning processing_status,
703: cn.freeze_flag,
704: cn.object_version_number
705: FROM cn_period_statuses cn,
706: cn_lookups gp,
707: cn_lookups cp
708: WHERE
709: gp.lookup_type = 'PERIOD_CLOSING_STATUS'
710: AND gp.lookup_code = cn.PERIOD_STATUS

Line 707: cn_lookups cp

703: cn.freeze_flag,
704: cn.object_version_number
705: FROM cn_period_statuses cn,
706: cn_lookups gp,
707: cn_lookups cp
708: WHERE
709: gp.lookup_type = 'PERIOD_CLOSING_STATUS'
710: AND gp.lookup_code = cn.PERIOD_STATUS
711: AND cp.lookup_type = 'PERIOD_PROCESSING_STATUS'

Line 727: cn_lookups gp,

723: cn.freeze_flag,
724: cn.object_version_number
725: FROM gl_period_statuses gl,
726: cn_period_statuses cn,
727: cn_lookups gp,
728: cn_lookups cp
729: WHERE gl.set_of_books_id = l_set_of_books_id
730: AND gl.application_id = 283
731: AND gl.adjustment_period_flag = 'N'

Line 728: cn_lookups cp

724: cn.object_version_number
725: FROM gl_period_statuses gl,
726: cn_period_statuses cn,
727: cn_lookups gp,
728: cn_lookups cp
729: WHERE gl.set_of_books_id = l_set_of_books_id
730: AND gl.application_id = 283
731: AND gl.adjustment_period_flag = 'N'
732: AND gl.period_name = cn.period_name(+)