DBA Data[Home] [Help]

APPS.FA_RETIREMENT_PUB dependencies on FA_MC_BOOK_CONTROLS

Line 1058: FROM fa_mc_book_controls

1054: -- associated with the set_of_books_id of given primary book_type_code
1055: CURSOR sob_cursor(p_book_type_code in varchar2
1056: ,p_sob_id in number) is
1057: SELECT set_of_books_id AS sob_id
1058: FROM fa_mc_book_controls
1059: WHERE book_type_code = p_book_type_code
1060: AND primary_set_of_books_id = p_sob_id
1061: AND enabled_flag = 'Y';
1062:

Line 3451: FROM fa_mc_book_controls

3447: -- associated with the set_of_books_id of given primary book_type_code
3448: CURSOR sob_cursor(p_book_type_code in varchar2
3449: ,p_sob_id in number) is
3450: SELECT set_of_books_id AS sob_id
3451: FROM fa_mc_book_controls
3452: WHERE book_type_code = p_book_type_code
3453: AND primary_set_of_books_id = p_sob_id
3454: AND enabled_flag = 'Y';
3455:

Line 4661: FROM fa_mc_book_controls

4657: -- associated with the set_of_books_id of given primary book_type_code
4658: CURSOR sob_cursor(p_book_type_code in varchar2
4659: ,p_sob_id in number) is
4660: SELECT set_of_books_id AS sob_id
4661: FROM fa_mc_book_controls
4662: WHERE book_type_code = p_book_type_code
4663: AND primary_set_of_books_id = p_sob_id
4664: AND enabled_flag = 'Y';
4665:

Line 5880: FROM fa_mc_book_controls

5876: -- associated with the set_of_books_id of given primary book_type_code
5877: CURSOR sob_cursor(p_book_type_code in varchar2
5878: ,p_sob_id in number) is
5879: SELECT set_of_books_id AS sob_id
5880: FROM fa_mc_book_controls
5881: WHERE book_type_code = p_book_type_code
5882: AND primary_set_of_books_id = p_sob_id
5883: AND enabled_flag = 'Y';
5884: