APPS.PA_REPORT_UTIL dependencies on PA_PERIOD_PROCESS_PKG

Line 382: AND glst.application_id = PA_Period_Process_PKG.Application_ID

378: AND gl.accounted_period_type = glper.period_type
379: AND glper.period_name = glst.period_name
380: AND glper.period_type = glst.period_type
381: AND glst.set_of_books_id=imp.set_of_books_id
382: AND glst.application_id = PA_Period_Process_PKG.Application_ID
383: AND gllkups.lookup_code = glst.closing_status
384: AND gllkups.lookup_type = 'CLOSING_STATUS'
385: /* Bug 2288460 - Start */
386: /* Added the following clause */

Line 493: AND glst.application_id = PA_Period_Process_PKG.Application_ID

489: AND gl.accounted_period_type = glper.period_type
490: AND glper.period_name = glst.period_name
491: AND glper.period_type = glst.period_type
492: AND glst.set_of_books_id=imp.set_of_books_id
493: AND glst.application_id = PA_Period_Process_PKG.Application_ID
494: /* Bug 2288460 - Start */
495: /* Added the following clause */
496: AND glper.adjustment_period_flag = 'N'
497: /* Bug 2288460 - End */

Line 1029: AND glst.application_id = PA_Period_Process_PKG.Application_ID

1025: AND glper.period_name = glst.period_name
1026: AND glper.period_type = glst.period_type
1027: AND glst.set_of_books_id=imp.set_of_books_id
1028: AND glst.closing_status ='O'
1029: AND glst.application_id = PA_Period_Process_PKG.Application_ID
1030: AND gllkups.lookup_code = glst.closing_status
1031: AND gllkups.lookup_type = 'CLOSING_STATUS'
1032: ORDER BY glper.period_year;
1033:

Line 1340: AND glst.application_id = PA_Period_Process_PKG.Application_ID

1336: AND gl.accounted_period_type = glper.period_type
1337: AND glper.period_name = glst.period_name
1338: AND glper.period_type = glst.period_type
1339: AND glst.set_of_books_id=imp.set_of_books_id
1340: AND glst.application_id = PA_Period_Process_PKG.Application_ID
1341: AND gllkups.lookup_code = glst.closing_status
1342: AND gllkups.lookup_type = 'CLOSING_STATUS'
1343: AND l_default_date BETWEEN glper.start_date AND glper.end_date
1344: /* Bug 2288460 - Start */

Line 1500: AND glst.application_id = PA_Period_Process_PKG.Application_ID

1496: AND glper.period_name = glst.period_name
1497: AND glper.period_name = x_def_period_name
1498: AND glper.period_type = glst.period_type
1499: AND glst.set_of_books_id=imp.set_of_books_id
1500: AND glst.application_id = PA_Period_Process_PKG.Application_ID
1501: AND gllkups.lookup_code = glst.closing_status
1502: AND gllkups.lookup_type = 'CLOSING_STATUS'
1503: /* Bug 2288460 - Start */
1504: /* Added the following clause */