eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_REC_EXP_EXTR_FROM_GL_PKG dependencies on GL_PERIOD_STATUSES

Line 1510: From gl_period_statuses gps

1506: And gb.actual_flag = 'A'
1507: And gb.template_id IS NULL
1508: And gb.period_name IN
1509: (Select gps.period_name
1510: From gl_period_statuses gps
1511: Where application_id = 101
1512: And ledger_id = sob_id
1513: And gps.start_date >= start_dt
1514: And gps.end_date <= end_dt);

Line 1533: From gl_period_statuses gps

1529: And budget_version_id = bud_id
1530: And template_id IS NULL
1531: And period_name IN
1532: (Select gps.period_name
1533: From gl_period_statuses gps
1534: Where application_id = 101
1535: And ledger_id = sob_id
1536: And gps.start_date >= start_dt
1537: And gps.end_date <= end_dt);

Line 1786: p_period_start IN gl_period_statuses.period_name%TYPE,

1782: p_loc_acc_map_hdr_id IN VARCHAR2,
1783: p_location_id IN VARCHAR2,
1784: p_property_id IN VARCHAR2,
1785: p_set_of_books_id IN VARCHAR2,
1786: p_period_start IN gl_period_statuses.period_name%TYPE,
1787: p_period_end IN gl_period_statuses.period_name%TYPE,
1788: p_balance_type_code IN gl_lookups.lookup_code%TYPE,
1789: p_balance_type_code_hide IN gl_lookups.lookup_code%TYPE DEFAULT NULL,
1790: p_budget_name IN gl_budgets.budget_name%TYPE,

Line 1787: p_period_end IN gl_period_statuses.period_name%TYPE,

1783: p_location_id IN VARCHAR2,
1784: p_property_id IN VARCHAR2,
1785: p_set_of_books_id IN VARCHAR2,
1786: p_period_start IN gl_period_statuses.period_name%TYPE,
1787: p_period_end IN gl_period_statuses.period_name%TYPE,
1788: p_balance_type_code IN gl_lookups.lookup_code%TYPE,
1789: p_balance_type_code_hide IN gl_lookups.lookup_code%TYPE DEFAULT NULL,
1790: p_budget_name IN gl_budgets.budget_name%TYPE,
1791: p_populate_rec IN VARCHAR2,

Line 1823: From gl_period_statuses g,

1819: CURSOR period_dates_by_period_cur(period VARCHAR2) IS
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

Line 1836: From gl_period_statuses g,

1832: CURSOR period_dates_by_dates_cur(start_dt DATE, end_dt DATE) IS
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