APPS.FA_MASS_REINS_PKG dependencies on FA_FISCAL_YEAR

Line 30: l_FY_Start_Date fa_fiscal_year.start_date%TYPE;

26: l_Asset_Id num_tbl;
27: l_Asset_Number v30_tbl;
28: l_Retirement_Status v30_tbl;
29: l_Retirement_Id num_tbl;
30: l_FY_Start_Date fa_fiscal_year.start_date%TYPE;
31: l_FY_End_Date fa_fiscal_year.end_date%TYPE;
32:
33: -- Control Variables
34: l_Varchar2_Dummy VARCHAR2(80);

Line 31: l_FY_End_Date fa_fiscal_year.end_date%TYPE;

27: l_Asset_Number v30_tbl;
28: l_Retirement_Status v30_tbl;
29: l_Retirement_Id num_tbl;
30: l_FY_Start_Date fa_fiscal_year.start_date%TYPE;
31: l_FY_End_Date fa_fiscal_year.end_date%TYPE;
32:
33: -- Control Variables
34: l_Varchar2_Dummy VARCHAR2(80);
35: l_Number_Dummy NUMBER(15);

Line 73: fa_fiscal_year ffy

69: ffy.start_date,
70: ffy.end_date
71: FROM fa_mass_retirements fmr,
72: fa_book_controls fbc,
73: fa_fiscal_year ffy
74: WHERE fmr.mass_retirement_id = p_Mass_Retirement_Id
75: AND fmr.book_type_code = fbc.book_type_code
76: AND ffy.fiscal_year_name = fbc.fiscal_year_name
77: AND ffy.fiscal_year = fbc.current_fiscal_year ;