APPS.XLA_BALANCES_PKG dependencies on XLA_ANALYTICAL_HDRS_B

Line 935: ,xla_analytical_hdrs_b xbh

931: ,NVL(l_req_id, -1) --request_id
932: FROM xla_balance_statuses xbs
933: ,xla_ac_balances xba
934: ,xla_ac_balances xbanew
935: ,xla_analytical_hdrs_b xbh
936: WHERE xbs.application_id = p_application_id
937: AND xbs.ledger_id = p_ledger_id
938: AND xbs.balance_source_code = 'A'
939: AND xbs.balance_status_code = p_balance_status_code_selected

Line 2542: ,xla_analytical_hdrs_b xbh

2538: ,ctr.balance_status_eff_per_num
2539: ,xbh.year_end_carry_forward_code
2540: ,ctr.account_type
2541: FROM xla_bal_ac_ctrbs_gt ctr
2542: ,xla_analytical_hdrs_b xbh
2543: ,xla_ac_balances xba
2544: WHERE ctr.application_id = p_application_id
2545: AND ctr.ledger_id = p_ledger_id
2546: AND ctr.effective_period_num = p_effective_period_num

Line 3102: ,xla_analytical_hdrs_b xbh

3098: ,g_prog_appl_id
3099: ,g_prog_id
3100: ,g_req_id
3101: FROM xla_bal_period_stats_gt gps
3102: ,xla_analytical_hdrs_b xbh
3103: WHERE gps.ledger_id = la_ledger_id (i)
3104: AND gps.effective_period_num >= la_contribution_eff_per_num(i)
3105: AND gps.effective_period_num <= la_balance_stat_eff_per_num(i)
3106: -- bug 6117987

Line 3659: ,xla_analytical_hdrs_b xbh

3655: FROM xla_balance_statuses xbs
3656: ,gl_period_statuses gpsbs
3657: ,xla_ac_balances xba
3658: ,gl_period_statuses gpsnew
3659: ,xla_analytical_hdrs_b xbh
3660: WHERE xbs.application_id = p_application_id
3661: AND xbs.ledger_id = p_ledger_id
3662: AND xbs.balance_source_code = 'A'
3663: AND xbs.effective_period_num < p_dest_effective_period_num