DBA Data[Home] [Help]

APPS.JG_RX_FAREG dependencies on FA_CALENDAR_TYPES

Line 400: FROM fa_calendar_types

396:
397: BEGIN
398: SELECT number_per_fiscal_year
399: INTO X_number_per_fiscal_year
400: FROM fa_calendar_types
401: WHERE calendar_type = X_deprn_calendar;
402: JG_RX_FAREG.var.life_in_years :=
403: JG_RX_FAREG.var.life_in_months / X_number_per_fiscal_year;
404: EXCEPTION

Line 703: FROM fa_calendar_types

699: -- concatenated segment value
700: BEGIN
701: SELECT number_per_fiscal_year
702: INTO X_number_per_fiscal_year
703: FROM fa_calendar_types
704: WHERE calendar_type = X_deprn_calendar;
705:
706: JG_RX_FAREG.var.life_in_years :=
707: JG_RX_FAREG.var.life_in_months / X_number_per_fiscal_year;

Line 1056: FROM fa_calendar_types

1052: -- CALCULATED
1053: IF JG_RX_FAREG.var.rate_source_rule IN ('CALCULATED','TABLE','FORMULA') THEN
1054: SELECT number_per_fiscal_year
1055: INTO X_number_per_fiscal_year
1056: FROM fa_calendar_types
1057: WHERE calendar_type = X_deprn_calendar; -- X_deprn_calendar is retrieved in Get_fiscal_year_date()
1058: IF JG_RX_FAREG.var.rate_source_rule = 'CALCULATED' THEN
1059: X_life_in_years := JG_RX_FAREG.var.life_in_months / 12; -- Bug 4066022
1060: FA_RX_UTIL_PKG.debug('Life in years ='||to_char(X_life_in_years));

Line 2364: FROM fa_calendar_types

2360: -- Added for ECE Project
2361: BEGIN
2362: SELECT number_per_fiscal_year
2363: INTO X_number_per_fiscal_year
2364: FROM fa_calendar_types
2365: WHERE calendar_type = X_deprn_calendar;
2366:
2367: JG_RX_FAREG.var.life_in_years := JG_RX_FAREG.var.life_in_months / X_number_per_fiscal_year;
2368: