APPS.FA_CREATE_GROUP_ASSET_PKG dependencies on FA_CATEGORY_BOOKS

Line 166: FROM fa_category_books cb

162: AND NVL (ak.segment10, '-1') =
163: NVL (l_group_akey_segment10, '-1')
164: AND EXISTS
165: (SELECT 'x'
166: FROM fa_category_books cb
167: WHERE cb.category_id = cat.category_id
168: AND cb.book_type_code = l_book)
169: AND EXISTS
170: (SELECT 'x'

Line 171: FROM fa_category_books cb1

167: WHERE cb.category_id = cat.category_id
168: AND cb.book_type_code = l_book)
169: AND EXISTS
170: (SELECT 'x'
171: FROM fa_category_books cb1
172: WHERE cb1.category_id = cat1.category_id
173: AND cb1.book_type_code = l_book);
174: BEGIN
175: IF (px_group_asset_rec.rec_mode = 'PREPARE') THEN

Line 975: FROM fa_category_books cb

971: AND cat1.category_id = l_category_id
972: AND cat1.segment1 = cat.segment1
973: AND EXISTS
974: (SELECT 'x'
975: FROM fa_category_books cb
976: WHERE cb.category_id = cat.category_id
977: AND cb.book_type_code =
978: l_mass_add_rec.book_type_code)
979: AND EXISTS

Line 981: FROM fa_category_books cb1

977: AND cb.book_type_code =
978: l_mass_add_rec.book_type_code)
979: AND EXISTS
980: (SELECT 'x'
981: FROM fa_category_books cb1
982: WHERE cb1.category_id = cat1.category_id
983: AND cb1.book_type_code =
984: l_mass_add_rec.book_type_code);
985: EXCEPTION

Line 1125: FROM fa_category_books cb

1121: AND cat1.category_id = l_category_id
1122: AND cat1.segment1 = cat.segment1
1123: AND EXISTS
1124: (SELECT 'x'
1125: FROM fa_category_books cb
1126: WHERE cb.category_id = cat.category_id
1127: AND cb.book_type_code =
1128: l_mass_add_rec.book_type_code)
1129: AND EXISTS

Line 1131: FROM fa_category_books cb1

1127: AND cb.book_type_code =
1128: l_mass_add_rec.book_type_code)
1129: AND EXISTS
1130: (SELECT 'x'
1131: FROM fa_category_books cb1
1132: WHERE cb1.category_id = cat1.category_id
1133: AND cb1.book_type_code =
1134: l_mass_add_rec.book_type_code);
1135: END;