APPS.XLA_BALANCES_PKG dependencies on XLA_ANALYTICAL_HDRS_B

Line 939: ,xla_analytical_hdrs_b xbh

935: ,NVL(l_req_id, -1) --request_id
936: ,l_dest_effective_period_num
937: FROM xla_balance_statuses xbs
938: ,xla_ac_balances xba
939: ,xla_analytical_hdrs_b xbh
940: WHERE xbs.application_id = p_application_id
941: AND xbs.ledger_id = p_ledger_id
942: AND xbs.balance_source_code = 'A'
943: AND xbs.balance_status_code = p_balance_status_code_selected

Line 2533: ,xla_analytical_hdrs_b xbh

2529: ,ctr.balance_status_eff_per_num
2530: ,xbh.year_end_carry_forward_code
2531: ,ctr.account_type
2532: FROM xla_bal_ac_ctrbs_gt ctr
2533: ,xla_analytical_hdrs_b xbh
2534: ,xla_ac_balances xba
2535: WHERE ctr.application_id = p_application_id
2536: AND ctr.ledger_id = p_ledger_id
2537: AND ctr.effective_period_num = p_effective_period_num

Line 3096: ,xla_analytical_hdrs_b xbh

3092: ,g_prog_id
3093: ,g_req_id
3094: ,gps.effective_period_num
3095: FROM xla_bal_period_stats_gt gps
3096: ,xla_analytical_hdrs_b xbh
3097: WHERE gps.ledger_id = la_ledger_id (i)
3098: AND gps.effective_period_num >= la_contribution_eff_per_num(i)
3099: AND gps.effective_period_num <= la_balance_stat_eff_per_num(i)
3100: -- bug 6117987

Line 3665: ,xla_analytical_hdrs_b xbh

3661: FROM xla_balance_statuses xbs
3662: ,gl_period_statuses gpsbs
3663: ,xla_ac_balances xba
3664: ,gl_period_statuses gpsnew
3665: ,xla_analytical_hdrs_b xbh
3666: WHERE xbs.application_id = p_application_id
3667: AND xbs.ledger_id = p_ledger_id
3668: AND xbs.balance_source_code = 'A'
3669: AND xbs.effective_period_num < p_dest_effective_period_num