APPS.FA_GAINLOSS_UPD_PKG dependencies on FA_FISCAL_YEAR

Line 2063: the lenght of FA_FISCAL_YEAR.FISCAL_YEAR_NAME varchar2(30) */

2059: dpy_begin integer;
2060: dpp_begin integer;
2061: --fy_name varchar2(20); -- bug 2719715
2062: /* the length of fy_name should be equal to
2063: the lenght of FA_FISCAL_YEAR.FISCAL_YEAR_NAME varchar2(30) */
2064: --fy_name varchar2(30); -- bug 2719715
2065: fy_name FA_FISCAL_YEAR.FISCAL_YEAR_NAME%TYPE;
2066:
2067: temp_start_pp number;

Line 2065: fy_name FA_FISCAL_YEAR.FISCAL_YEAR_NAME%TYPE;

2061: --fy_name varchar2(20); -- bug 2719715
2062: /* the length of fy_name should be equal to
2063: the lenght of FA_FISCAL_YEAR.FISCAL_YEAR_NAME varchar2(30) */
2064: --fy_name varchar2(30); -- bug 2719715
2065: fy_name FA_FISCAL_YEAR.FISCAL_YEAR_NAME%TYPE;
2066:
2067: temp_start_pp number;
2068: source_type_code varchar2(30);
2069: prev_dist_id number;

Line 3358: FROM FA_FISCAL_YEAR fy1,

3354: 'TABLE', 2,
3355: 'FLAT', 3)
3356: INTO h_same_fy, h_depr_first_year_ret,
3357: h_dwacq, h_rate_source_rule
3358: FROM FA_FISCAL_YEAR fy1,
3359: FA_FISCAL_YEAR fy2,
3360: FA_BOOKS bk,
3361: FA_RETIREMENTS rt,
3362: FA_CONVENTION_TYPES ctype,

Line 3359: FA_FISCAL_YEAR fy2,

3355: 'FLAT', 3)
3356: INTO h_same_fy, h_depr_first_year_ret,
3357: h_dwacq, h_rate_source_rule
3358: FROM FA_FISCAL_YEAR fy1,
3359: FA_FISCAL_YEAR fy2,
3360: FA_BOOKS bk,
3361: FA_RETIREMENTS rt,
3362: FA_CONVENTION_TYPES ctype,
3363: FA_METHODS mt,

Line 4090: fa_fiscal_year fy,

4086:
4087: SELECT to_number (to_char (dcp.start_date, 'J'))
4088: INTO h_cpp_jstartdate
4089: FROM fa_calendar_periods dcp,
4090: fa_fiscal_year fy,
4091: fa_book_controls bc
4092: WHERE bc.book_type_code = h_book
4093: AND bc.fiscal_year_name = fy.fiscal_year_name
4094: AND dcp.calendar_type = h_d_cal