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.IGC_UPGRADE_DATA_R12 dependencies on GL_PERIOD_STATUSES

Line 1576: gl_period_statuses per_f,

1572: gl_budget_assignments asg,
1573: GL_BUDORG_BC_OPTIONS boc,
1574: GL_BUDGET_VERSIONS BV ,
1575: gl_budgets bud,
1576: gl_period_statuses per_f,
1577: gl_period_statuses per_s
1578: WHERE asg.range_id = boc.range_id
1579: AND BV.BUDGET_VERSION_ID = BOC.FUNDING_BUDGET_VERSION_ID
1580: AND bud.budget_name = BV.budget_name

Line 1577: gl_period_statuses per_s

1573: GL_BUDORG_BC_OPTIONS boc,
1574: GL_BUDGET_VERSIONS BV ,
1575: gl_budgets bud,
1576: gl_period_statuses per_f,
1577: gl_period_statuses per_s
1578: WHERE asg.range_id = boc.range_id
1579: AND BV.BUDGET_VERSION_ID = BOC.FUNDING_BUDGET_VERSION_ID
1580: AND bud.budget_name = BV.budget_name
1581: AND asg.code_combination_id = igc.code_combination_id

Line 1630: gl_period_statuses per_f,

1626: FROM gl_budget_assignments asg,
1627: GL_BUDORG_BC_OPTIONS boc,
1628: GL_BUDGET_VERSIONS BV ,
1629: gl_budgets bud,
1630: gl_period_statuses per_f,
1631: gl_period_statuses per_s
1632: WHERE asg.range_id = boc.range_id
1633: AND BV.BUDGET_VERSION_ID = BOC.FUNDING_BUDGET_VERSION_ID
1634: AND bud.budget_name = BV.budget_name

Line 1631: gl_period_statuses per_s

1627: GL_BUDORG_BC_OPTIONS boc,
1628: GL_BUDGET_VERSIONS BV ,
1629: gl_budgets bud,
1630: gl_period_statuses per_f,
1631: gl_period_statuses per_s
1632: WHERE asg.range_id = boc.range_id
1633: AND BV.BUDGET_VERSION_ID = BOC.FUNDING_BUDGET_VERSION_ID
1634: AND bud.budget_name = BV.budget_name
1635: AND asg.code_combination_id = igc.code_combination_id

Line 1934: FROM gl_period_statuses

1930: l_open_count NUMBER := 0;
1931: BEGIN
1932: SELECT sum(decode(closing_status,'O',1,0)),sum(1)
1933: INTO l_open_count,l_tot_count
1934: FROM gl_period_statuses
1935: WHERE application_id = 101
1936: AND period_year = p_fin_year
1937: AND ledger_id = g_cbc_ledger_id
1938: AND adjustment_period_flag = 'N';

Line 1995: gl_period_statuses per_f,

1991: FROM gl_budget_assignments asg,
1992: GL_BUDORG_BC_OPTIONS boc,
1993: GL_BUDGET_VERSIONS BV ,
1994: gl_budgets bud,
1995: gl_period_statuses per_f,
1996: gl_period_statuses per_s
1997: WHERE asg.range_id = boc.range_id
1998: AND BV.BUDGET_VERSION_ID = BOC.FUNDING_BUDGET_VERSION_ID
1999: AND bud.budget_name = BV.budget_name

Line 1996: gl_period_statuses per_s

1992: GL_BUDORG_BC_OPTIONS boc,
1993: GL_BUDGET_VERSIONS BV ,
1994: gl_budgets bud,
1995: gl_period_statuses per_f,
1996: gl_period_statuses per_s
1997: WHERE asg.range_id = boc.range_id
1998: AND BV.BUDGET_VERSION_ID = BOC.FUNDING_BUDGET_VERSION_ID
1999: AND bud.budget_name = BV.budget_name
2000: AND asg.code_combination_id = igc.code_combination_id