DBA Data[Home] [Help]

APPS.FA_RX_GROUP dependencies on FA_SYSTEM_CONTROLS

Line 29: l_application_id fa_system_controls.fa_application_id%TYPE;

25: x_errbuf OUT NOCOPY VARCHAR2)
26: IS
27: l_info_rec info_rec_type;
28:
29: l_application_id fa_system_controls.fa_application_id%TYPE;
30: l_category_flex_structure fa_system_controls.category_flex_structure%TYPE;
31:
32: l_param_where_stmt VARCHAR2(1000);
33: l_group_sql_stmt VARCHAR2(5000);

Line 30: l_category_flex_structure fa_system_controls.category_flex_structure%TYPE;

26: IS
27: l_info_rec info_rec_type;
28:
29: l_application_id fa_system_controls.fa_application_id%TYPE;
30: l_category_flex_structure fa_system_controls.category_flex_structure%TYPE;
31:
32: l_param_where_stmt VARCHAR2(1000);
33: l_group_sql_stmt VARCHAR2(5000);
34: l_sql_stmt VARCHAR2(5000);

Line 94: FROM fa_system_controls sc,

90: l_info_rec.organization_name,
91: l_info_rec.functional_currency_code,
92: l_info_rec.set_of_books_id,
93: l_info_rec.deprn_calendar
94: FROM fa_system_controls sc,
95: fa_book_controls bc,
96: gl_sets_of_books sob,
97: fnd_currencies cur
98: WHERE bc.book_type_code = p_book_type_code