APPS.JA_JP_TP_BAL_CTRL_RPT_PKG dependencies on GL_PERIOD_STATUSES

Line 427: FROM gl_period_statuses

423: SELECT effective_period_num
424: ,START_DATE
425: INTO l_start_period_num
426: ,l_start_date
427: FROM gl_period_statuses
428: WHERE application_id = 101
429: AND ledger_id = l_ledger_id
430: AND period_name = p_period_from;
431:

Line 436: FROM gl_period_statuses

432: SELECT effective_period_num
433: ,end_date
434: INTO l_end_period_num
435: ,l_end_date
436: FROM gl_period_statuses
437: WHERE application_id = 101
438: AND ledger_id = l_ledger_id
439: AND period_name = p_period_to;
440:

Line 1042: ,gl_period_statuses gls

1038: ,gcck.segment29 SEGMENT29
1039: ,gcck.segment30 SEGMENT30
1040: FROM gl_ledgers gll
1041: ,xla_control_balances xcb
1042: ,gl_period_statuses gls
1043: ,gl_code_combinations_kfv gcck
1044: ,hz_parties hzp
1045: ,hz_party_sites hps
1046: ,hz_locations hzl

Line 1058: ,gl_period_statuses inps

1054: AND gls.application_id = 101
1055: AND gls.effective_period_num =
1056: (SELECT min(inps.effective_period_num)
1057: FROM xla_control_balances incb
1058: ,gl_period_statuses inps
1059: WHERE incb.ledger_id=xcb.ledger_id
1060: AND incb.application_id= xcb.application_id
1061: AND incb.code_combination_id =xcb.code_combination_id
1062: AND incb.party_id = xcb.party_id