APPS.PN_REC_EXP_EXTR_FROM_GL_PKG dependencies on GL_SETS_OF_BOOKS

Line 947: gl_sets_of_books gsob

943: x_summary_flag := l_summary_flag;
944: l_statement :=
945: 'Select gcc.code_combination_id
946: From gl_code_combinations gcc,
947: gl_sets_of_books gsob
948: Where gsob.set_of_books_id = :l_sob_id
949: And gcc.chart_of_accounts_id = gsob.chart_of_accounts_id
950: And gcc.summary_flag = :x_summary_flag
951: And gcc.template_id IS NULL '

Line 1478: from gl_sets_of_books gl_sob

1474:
1475: /* cursor for currency code */
1476: CURSOR curr_code(sob_id NUMBER) IS
1477: select gl_sob.currency_code as CURRENCY_CODE
1478: from gl_sets_of_books gl_sob
1479: where gl_sob.set_of_books_id = sob_id;
1480:
1481: l_currency_code VARCHAR2(15) := 'USD';
1482:

Line 1647: from gl_sets_of_books gl_sob

1643:
1644: /* cursor for currency code */
1645: CURSOR curr_code(sob_id NUMBER) IS
1646: select gl_sob.currency_code as CURRENCY_CODE
1647: from gl_sets_of_books gl_sob
1648: where gl_sob.set_of_books_id = sob_id;
1649:
1650: l_currency_code VARCHAR2(15) := 'USD';
1651:

Line 1824: gl_sets_of_books b

1820: Select g.period_name,
1821: g.start_date,
1822: g.end_date
1823: From gl_period_statuses g,
1824: gl_sets_of_books b
1825: Where g.application_id = 101
1826: And g.ledger_id = p_set_of_books_id
1827: And b.set_of_books_id = g.ledger_id
1828: And g.period_type = b.accounted_period_type

Line 1837: gl_sets_of_books b

1833: Select g.period_name,
1834: g.start_date,
1835: g.end_date
1836: From gl_period_statuses g,
1837: gl_sets_of_books b
1838: Where g.application_id = 101
1839: And g.ledger_id = p_set_of_books_id
1840: And b.set_of_books_id = g.set_of_books_id
1841: And g.period_type = b.accounted_period_type

Line 1908: from gl_sets_of_books gl_sob

1904:
1905: /* cursor for currency code */
1906: CURSOR curr_code(sob_id NUMBER) IS
1907: select gl_sob.currency_code as CURRENCY_CODE
1908: from gl_sets_of_books gl_sob
1909: where gl_sob.set_of_books_id = sob_id;
1910:
1911: l_currency_code VARCHAR2(15) := 'USD';
1912: