DBA Data[Home] [Help]

APPS.PA_UTILS2 dependencies on GL_DATE_PERIOD_MAP

Line 1850: GL_DATE_PERIOD_MAP DPM,

1846: AND PERIOD1.adjustment_period_flag = 'N'
1847: AND PERIOD1.effective_period_num >=
1848: ( SELECT PERIOD2.effective_period_num
1849: FROM GL_PERIOD_STATUSES PERIOD2,
1850: GL_DATE_PERIOD_MAP DPM,
1851: GL_SETS_OF_BOOKS SOB
1852: WHERE SOB.set_of_books_id = p_set_of_books_id
1853: AND DPM.period_set_name = SOB.period_set_name
1854: AND DPM.period_type = SOB.accounted_period_type

Line 1915: GL_DATE_PERIOD_MAP DPM,

1911: AND PERIOD1.adjustment_period_flag = 'N'
1912: AND PERIOD1.effective_period_num >=
1913: ( SELECT PERIOD2.effective_period_num
1914: FROM GL_PERIOD_STATUSES PERIOD2,
1915: GL_DATE_PERIOD_MAP DPM,
1916: GL_SETS_OF_BOOKS SOB
1917: WHERE SOB.set_of_books_id = p_set_of_books_id
1918: AND DPM.period_set_name = SOB.period_set_name
1919: AND DPM.period_type = SOB.accounted_period_type

Line 5178: GL_DATE_PERIOD_MAP DPM,

5174: AND PERIOD1.adjustment_period_flag = 'N'
5175: AND PERIOD1.effective_period_num >=
5176: (SELECT PERIOD2.effective_period_num
5177: FROM GL_PERIOD_STATUSES PERIOD2,
5178: GL_DATE_PERIOD_MAP DPM,
5179: GL_SETS_OF_BOOKS SOB
5180: WHERE SOB.set_of_books_id = l_set_of_books_id
5181: AND DPM.period_set_name = SOB.period_set_name
5182: AND DPM.period_type = SOB.accounted_period_type

Line 5217: GL_DATE_PERIOD_MAP DPM,

5213: AND PERIOD1.adjustment_period_flag = 'N'
5214: AND PERIOD1.effective_period_num >=
5215: (SELECT PERIOD2.effective_period_num
5216: FROM GL_PERIOD_STATUSES PERIOD2,
5217: GL_DATE_PERIOD_MAP DPM,
5218: GL_SETS_OF_BOOKS SOB
5219: WHERE SOB.set_of_books_id = l_set_of_books_id
5220: AND DPM.period_set_name = SOB.period_set_name
5221: AND DPM.period_type = SOB.accounted_period_type