DBA Data[Home] [Help]

APPS.GLF02220_PKG dependencies on GL_BALANCES

Line 535: FROM GL_BALANCES GB

531: X_old_period4_amount, X_old_period5_amount, X_old_period6_amount,
532: X_old_period7_amount, X_old_period8_amount, X_old_period9_amount,
533: X_old_period10_amount, X_old_period11_amount, X_old_period12_amount,
534: X_old_period13_amount
535: FROM GL_BALANCES GB
536: WHERE GB.ledger_id (+) = X_ledger_id
537: AND GB.code_combination_id (+) = X_code_combination_id
538: AND GB.currency_code (+) = X_currency_code
539: AND GB.actual_flag (+) = 'B'

Line 940: defined_currency GL_BALANCES.currency_code%TYPE;

936: X_period12_amount IN OUT NOCOPY NUMBER,
937: X_period13_amount IN OUT NOCOPY NUMBER ) IS
938:
939: -- hold defined currency
940: defined_currency GL_BALANCES.currency_code%TYPE;
941:
942: CURSOR gbi IS
943: SELECT
944: sum(decode(GB.period_num,

Line 999: GL_BALANCES GB,

995: max(nvl(BI.period13_amount,0)-nvl(BI.old_period13_amount,0)),
996: decode(max(nvl(GB.rowid, BI.rowid)), null, 0, 1)
997: FROM
998: GL_CODE_COMBINATIONS CC,
999: GL_BALANCES GB,
1000: GL_BUDGET_RANGE_INTERIM BI
1001: WHERE CC.code_combination_id = X_code_combination_id
1002: AND GB.ledger_id (+) = X_ledger_id
1003: AND GB.code_combination_id (+) = CC.code_combination_id

Line 1280: GL_BALANCES GB

1276: floor((X_start_period_num-1)/13) * 13 + 13,
1277: (nvl(GB.period_net_dr,0)-nvl(GB.period_net_cr,0)) * X_dr_sign,0)),
1278: decode(max(GB.rowid), null, 0, 1)
1279: FROM
1280: GL_BALANCES GB
1281: WHERE
1282: GB.ledger_id = X_ledger_id
1283: AND GB.code_combination_id = X_code_combination_id
1284: AND GB.currency_code = decode(X_budget_rule,