DBA Data[Home] [Help]

APPS.CSTPOMLD dependencies on GL_PERIODS

Line 1867: gl_periods gp,

1863: update CST_BIS_MARGIN_SUMMARY cmt
1864: set (PERIOD_NAME_YEAR, PERIOD_NUM_YEAR) =
1865: (select gp.period_name, gp.PERIOD_YEAR
1866: from
1867: gl_periods gp,
1868: gl_sets_of_books gsob,
1869: hr_organization_information hoi
1870: where
1871: hoi.org_information1 = gsob.SET_OF_BOOKS_ID

Line 1893: gl_periods gp,

1889: set (PERIOD_NAME_QTR, PERIOD_NUM_QTR, PERIOD_SEQ_QTR) =
1890: (select gp.period_name, gp.period_num,
1891: gp.PERIOD_YEAR * 10 + gp.period_num
1892: from
1893: gl_periods gp,
1894: gl_sets_of_books gsob,
1895: hr_organization_information hoi
1896: where
1897: hoi.org_information1 = gsob.SET_OF_BOOKS_ID

Line 1918: gl_periods gp,

1914: set (PERIOD_NAME_MONTH, PERIOD_NUM_MONTH, PERIOD_SEQ_MONTH) =
1915: (select gp.period_name, gp.period_num,
1916: gp.PERIOD_YEAR * 100 + gp.period_num
1917: from
1918: gl_periods gp,
1919: gl_sets_of_books gsob,
1920: hr_organization_information hoi
1921: where
1922: hoi.org_information1 = gsob.SET_OF_BOOKS_ID