APPS.PA_UTILS2 dependencies on GL_DATE_PERIOD_MAP

Line 1833: GL_DATE_PERIOD_MAP DPM,

1829: AND PERIOD1.adjustment_period_flag = 'N'
1830: AND PERIOD1.effective_period_num >=
1831: ( SELECT PERIOD2.effective_period_num
1832: FROM GL_PERIOD_STATUSES PERIOD2,
1833: GL_DATE_PERIOD_MAP DPM,
1834: GL_SETS_OF_BOOKS SOB
1835: WHERE SOB.set_of_books_id = p_set_of_books_id
1836: AND DPM.period_set_name = SOB.period_set_name
1837: AND DPM.period_type = SOB.accounted_period_type

Line 1898: GL_DATE_PERIOD_MAP DPM,

1894: AND PERIOD1.adjustment_period_flag = 'N'
1895: AND PERIOD1.effective_period_num >=
1896: ( SELECT PERIOD2.effective_period_num
1897: FROM GL_PERIOD_STATUSES PERIOD2,
1898: GL_DATE_PERIOD_MAP DPM,
1899: GL_SETS_OF_BOOKS SOB
1900: WHERE SOB.set_of_books_id = p_set_of_books_id
1901: AND DPM.period_set_name = SOB.period_set_name
1902: AND DPM.period_type = SOB.accounted_period_type

Line 5140: GL_DATE_PERIOD_MAP DPM,

5136: AND PERIOD1.adjustment_period_flag = 'N'
5137: AND PERIOD1.effective_period_num >=
5138: (SELECT PERIOD2.effective_period_num
5139: FROM GL_PERIOD_STATUSES PERIOD2,
5140: GL_DATE_PERIOD_MAP DPM,
5141: GL_SETS_OF_BOOKS SOB
5142: WHERE SOB.set_of_books_id = l_set_of_books_id
5143: AND DPM.period_set_name = SOB.period_set_name
5144: AND DPM.period_type = SOB.accounted_period_type

Line 5179: GL_DATE_PERIOD_MAP DPM,

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