APPS.PA_REPORT_UTIL dependencies on PA_PERIOD_PROCESS_PKG

Line 415: AND glst.application_id = PA_Period_Process_PKG.Application_ID

411: AND gl.accounted_period_type = glper.period_type
412: AND glper.period_name = glst.period_name
413: AND glper.period_type = glst.period_type
414: AND glst.set_of_books_id=imp.set_of_books_id
415: AND glst.application_id = PA_Period_Process_PKG.Application_ID
416: AND gllkups.lookup_code = glst.closing_status
417: AND gllkups.lookup_type = 'CLOSING_STATUS'
418: /* Bug 2288460 - Start */
419: /* Added the following clause */

Line 526: AND glst.application_id = PA_Period_Process_PKG.Application_ID

522: AND gl.accounted_period_type = glper.period_type
523: AND glper.period_name = glst.period_name
524: AND glper.period_type = glst.period_type
525: AND glst.set_of_books_id=imp.set_of_books_id
526: AND glst.application_id = PA_Period_Process_PKG.Application_ID
527: /* Bug 2288460 - Start */
528: /* Added the following clause */
529: AND glper.adjustment_period_flag = 'N'
530: /* Bug 2288460 - End */

Line 1065: AND glst.application_id = PA_Period_Process_PKG.Application_ID

1061: AND glper.period_name = glst.period_name
1062: AND glper.period_type = glst.period_type
1063: AND glst.set_of_books_id=imp.set_of_books_id
1064: AND glst.closing_status ='O'
1065: AND glst.application_id = PA_Period_Process_PKG.Application_ID
1066: AND gllkups.lookup_code = glst.closing_status
1067: AND gllkups.lookup_type = 'CLOSING_STATUS'
1068: ORDER BY glper.period_year;
1069:

Line 1388: AND glst.application_id = PA_Period_Process_PKG.Application_ID

1384: AND gl.accounted_period_type = glper.period_type
1385: AND glper.period_name = glst.period_name
1386: AND glper.period_type = glst.period_type
1387: AND glst.set_of_books_id=imp.set_of_books_id
1388: AND glst.application_id = PA_Period_Process_PKG.Application_ID
1389: AND gllkups.lookup_code = glst.closing_status
1390: AND gllkups.lookup_type = 'CLOSING_STATUS'
1391: AND l_default_date BETWEEN glper.start_date AND glper.end_date
1392: /* Bug 2288460 - Start */

Line 1563: AND glst.application_id = PA_Period_Process_PKG.Application_ID

1559: AND glper.period_name = glst.period_name
1560: AND glper.period_name = x_def_period_name
1561: AND glper.period_type = glst.period_type
1562: AND glst.set_of_books_id=imp.set_of_books_id
1563: AND glst.application_id = PA_Period_Process_PKG.Application_ID
1564: AND gllkups.lookup_code = glst.closing_status
1565: AND gllkups.lookup_type = 'CLOSING_STATUS'
1566: /* Bug 2288460 - Start */
1567: /* Added the following clause */