DBA Data[Home] [Help]

APPS.FA_RETIREMENT_PUB dependencies on FA_MC_BOOK_CONTROLS

Line 1215: FROM fa_mc_book_controls

1211: -- associated with the set_of_books_id of given primary book_type_code
1212: CURSOR sob_cursor(p_book_type_code in varchar2
1213: ,p_sob_id in number) is
1214: SELECT set_of_books_id AS sob_id
1215: FROM fa_mc_book_controls
1216: WHERE book_type_code = p_book_type_code
1217: AND primary_set_of_books_id = p_sob_id
1218: AND enabled_flag = 'Y';
1219:

Line 3711: FROM fa_mc_book_controls

3707: -- associated with the set_of_books_id of given primary book_type_code
3708: CURSOR sob_cursor(p_book_type_code in varchar2
3709: ,p_sob_id in number) is
3710: SELECT set_of_books_id AS sob_id
3711: FROM fa_mc_book_controls
3712: WHERE book_type_code = p_book_type_code
3713: AND primary_set_of_books_id = p_sob_id
3714: AND enabled_flag = 'Y';
3715:

Line 4985: FROM fa_mc_book_controls

4981: -- associated with the set_of_books_id of given primary book_type_code
4982: CURSOR sob_cursor(p_book_type_code in varchar2
4983: ,p_sob_id in number) is
4984: SELECT set_of_books_id AS sob_id
4985: FROM fa_mc_book_controls
4986: WHERE book_type_code = p_book_type_code
4987: AND primary_set_of_books_id = p_sob_id
4988: AND enabled_flag = 'Y';
4989:

Line 6207: FROM fa_mc_book_controls

6203: -- associated with the set_of_books_id of given primary book_type_code
6204: CURSOR sob_cursor(p_book_type_code in varchar2
6205: ,p_sob_id in number) is
6206: SELECT set_of_books_id AS sob_id
6207: FROM fa_mc_book_controls
6208: WHERE book_type_code = p_book_type_code
6209: AND primary_set_of_books_id = p_sob_id
6210: AND enabled_flag = 'Y';
6211: