APPS.FA_RES_LDG_PKG dependencies on FA_DEPRN_PERIODS

Line 94: FROM fa_deprn_periods FDP

90: ,ld_period_POD
91: ,ld_period_PCD
92: ,lc_period_closed
93: ,ln_period_FY
94: FROM fa_deprn_periods FDP
95: WHERE FDP.book_type_code = P_BOOK
96: AND FDP.period_name = P_PERIOD1;
97:
98: gn_period1_pc := ln_period_PC;

Line 247: fa_deprn_periods_mrc_v DP

243: ,upc
244: ,tod
245: ,tpc
246: FROM
247: fa_deprn_periods_mrc_v DP
248: ,fa_deprn_periods_mrc_v DP_FY
249: ,fa_book_controls_mrc_v BC
250: WHERE
251: DP.book_type_code = book

Line 248: ,fa_deprn_periods_mrc_v DP_FY

244: ,tod
245: ,tpc
246: FROM
247: fa_deprn_periods_mrc_v DP
248: ,fa_deprn_periods_mrc_v DP_FY
249: ,fa_book_controls_mrc_v BC
250: WHERE
251: DP.book_type_code = book
252: AND DP.period_name = period

Line 274: fa_deprn_periods DP

270: ,upc
271: ,tod
272: ,tpc
273: FROM
274: fa_deprn_periods DP
275: ,fa_deprn_periods DP_FY
276: ,fa_book_controls BC
277: WHERE
278: DP.book_type_code = book

Line 275: ,fa_deprn_periods DP_FY

271: ,tod
272: ,tpc
273: FROM
274: fa_deprn_periods DP
275: ,fa_deprn_periods DP_FY
276: ,fa_book_controls BC
277: WHERE
278: DP.book_type_code = book
279: AND DP.period_name = period

Line 771: ,fa_deprn_periods_mrc_v DP

767: FROM
768: fa_deprn_summary_mrc_v DD
769: ,fa_group_asset_rules GAR
770: ,fa_group_asset_default GAD
771: ,fa_deprn_periods_mrc_v DP
772: WHERE
773: DD.book_type_code = book
774: AND DD.asset_id = GAR.group_asset_id
775: AND GAD.super_group_id IS NULL

Line 827: ,fa_deprn_periods DP

823: FROM
824: fa_deprn_summary DD
825: ,fa_group_asset_rules GAR
826: ,fa_group_asset_default GAD
827: ,fa_deprn_periods DP
828: WHERE
829: DD.book_type_code = book
830: AND DD.asset_id = GAR.group_asset_id
831: AND GAD.super_group_id IS NULL -- MPOWELL

Line 890: ,fa_deprn_periods_mrc_v DP

886: FROM fa_deprn_summary_mrc_v DD
887: ,fa_group_asset_rules GAR
888: ,fa_group_asset_default GAD
889: ,fa_super_group_rules SGR
890: ,fa_deprn_periods_mrc_v DP
891: WHERE DD.book_type_code = book
892: AND DD.asset_id = GAR.group_asset_id
893: AND GAR.book_type_code = DD.book_type_code
894: AND GAD.super_group_id = SGR.super_group_id

Line 949: ,fa_deprn_periods DP

945: FROM fa_deprn_summary DD
946: ,fa_group_asset_rules GAR
947: ,fa_group_asset_default GAD
948: ,fa_super_group_rules SGR
949: ,fa_deprn_periods DP
950: WHERE DD.book_type_code = book
951: AND DD.asset_id = GAR.group_asset_id
952: AND GAR.book_type_code = DD.book_type_code
953: AND GAD.super_group_id = SGR.super_group_id -- MPOWELL