APPS.CN_GENERAL_UTILS dependencies on CN_REPOSITORIES

Line 14: when no sob in cn_repositories.

10: procedures and functions from cn_utils.
11: 17-JUL-95 P Cook No longer raise app_exception when no rows found
12: in from period packages
13: 06-NOV-95 P Cook Bug:320828. get_currency. Return an error message
14: when no sob in cn_repositories.
15: 04-APR-96 A Saxena Added function get_set_of_books_id
16: 03-JUN-96 A Saxena Added function get_currency_CODE
17: */
18:

Line 24: -- Assumes always will be exactly 1 record in CN_REPOSITORIES

20: -- Function Name
21: -- get_set_of_books_id
22: -- Purpose
23: -- Get set of books id for current instance of CN
24: -- Assumes always will be exactly 1 record in CN_REPOSITORIES
25:
26: FUNCTION get_set_of_books_id RETURN NUMBER is
27: SOB_ID number;
28: begin

Line 31: from CN_REPOSITORIES;

27: SOB_ID number;
28: begin
29: select SET_OF_BOOKS_ID
30: into SOB_ID
31: from CN_REPOSITORIES;
32: return(SOB_ID);
33: end;
34:
35:

Line 49: ,cn_repositories_all r

45: BEGIN
46: SELECT s.currency_code
47: INTO x_currency_code
48: FROM gl_sets_of_books s
49: ,cn_repositories_all r
50: WHERE r.set_of_books_id = s.set_of_books_id
51: AND r.application_id = 283
52: AND r.org_id = p_org_id
53: ;

Line 80: ,cn_repositories r

76: BEGIN
77: SELECT s.currency_code
78: INTO x_currency_code
79: FROM gl_sets_of_books s
80: ,cn_repositories r
81: WHERE r.set_of_books_id = s.set_of_books_id
82: AND r.application_id = 283
83: ;
84: