APPS.CN_CALC_SUBMISSION_PVT dependencies on CN_INTERVAL_TYPES

Line 36: TYPE name_tbl_type IS TABLE OF cn_interval_types_all_tl.name%TYPE INDEX BY BINARY_INTEGER;

32: calc_sub_quota_id cn_calc_sub_quotas.calc_sub_quota_id%TYPE);
33:
34: TYPE rep_entry_tbl_type IS TABLE OF rep_entry_rec_type INDEX BY BINARY_INTEGER;
35: TYPE quota_entry_tbl_type IS TABLE OF quota_entry_rec_type INDEX BY BINARY_INTEGER;
36: TYPE name_tbl_type IS TABLE OF cn_interval_types_all_tl.name%TYPE INDEX BY BINARY_INTEGER;
37:
38: --
39: -- Name
40: -- check_end_of_interval

Line 757: FROM cn_interval_types

753: AND a.quota_id = b.quota_id;
754:
755: CURSOR interval_types IS
756: SELECT name
757: FROM cn_interval_types
758: WHERE interval_type_id IN (-1000, -1001, -1002, -1003)
759: ORDER BY interval_type_id desc;
760:
761: -- Added to retrieve concurrent request id for enhancment#2651798