APPS.FA_MASS_REINS_PKG dependencies on FA_MASS_RETIREMENTS

Line 18: l_Mass_Retirement_Id fa_mass_retirements.Mass_Retirement_Id%TYPE;

14: x_return_status OUT NOCOPY NUMBER) IS
15:
16: -- Local Variables holding Mass Retirements Information
17: l_Retirement_Rowid VARCHAR2(30);
18: l_Mass_Retirement_Id fa_mass_retirements.Mass_Retirement_Id%TYPE;
19: l_Reinstate_Request_Id fa_mass_retirements.Reinstate_Request_Id%TYPE;
20: l_Retire_Request_Id fa_mass_retirements.Retire_Request_Id%TYPE;
21: l_Book_Type_Code fa_mass_retirements.Book_Type_Code%TYPE;
22:

Line 19: l_Reinstate_Request_Id fa_mass_retirements.Reinstate_Request_Id%TYPE;

15:
16: -- Local Variables holding Mass Retirements Information
17: l_Retirement_Rowid VARCHAR2(30);
18: l_Mass_Retirement_Id fa_mass_retirements.Mass_Retirement_Id%TYPE;
19: l_Reinstate_Request_Id fa_mass_retirements.Reinstate_Request_Id%TYPE;
20: l_Retire_Request_Id fa_mass_retirements.Retire_Request_Id%TYPE;
21: l_Book_Type_Code fa_mass_retirements.Book_Type_Code%TYPE;
22:
23: TYPE v30_tbl IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;

Line 20: l_Retire_Request_Id fa_mass_retirements.Retire_Request_Id%TYPE;

16: -- Local Variables holding Mass Retirements Information
17: l_Retirement_Rowid VARCHAR2(30);
18: l_Mass_Retirement_Id fa_mass_retirements.Mass_Retirement_Id%TYPE;
19: l_Reinstate_Request_Id fa_mass_retirements.Reinstate_Request_Id%TYPE;
20: l_Retire_Request_Id fa_mass_retirements.Retire_Request_Id%TYPE;
21: l_Book_Type_Code fa_mass_retirements.Book_Type_Code%TYPE;
22:
23: TYPE v30_tbl IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
24: TYPE num_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 21: l_Book_Type_Code fa_mass_retirements.Book_Type_Code%TYPE;

17: l_Retirement_Rowid VARCHAR2(30);
18: l_Mass_Retirement_Id fa_mass_retirements.Mass_Retirement_Id%TYPE;
19: l_Reinstate_Request_Id fa_mass_retirements.Reinstate_Request_Id%TYPE;
20: l_Retire_Request_Id fa_mass_retirements.Retire_Request_Id%TYPE;
21: l_Book_Type_Code fa_mass_retirements.Book_Type_Code%TYPE;
22:
23: TYPE v30_tbl IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
24: TYPE num_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
25:

Line 71: FROM fa_mass_retirements fmr,

67: fmr.retire_request_id,
68: fmr.book_type_code,
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