DBA Data[Home] [Help]

APPS.PA_FP_COPY_ACTUALS_PUB dependencies on PA_PERIOD_PROCESS_PKG

Line 259: AND gd.application_id = PA_PERIOD_PROCESS_PKG.Application_id

255: (NVL(pji_tmp.pou_revenue, 0) <> 0) OR --Bug 9666017
256: (NVL(pji_tmp.quantity,0) <> 0)
257: )
258: AND gd.SET_OF_BOOKS_ID = c_set_of_books_id
259: AND gd.application_id = PA_PERIOD_PROCESS_PKG.Application_id
260: AND gd.ADJUSTMENT_PERIOD_FLAG = 'N'
261: AND gd.period_name = pji_tmp.period_name
262: AND pji_tmp.source_id = c_res_asg_id
263: AND DECODE(c_multi_currency_flag,'Y',

Line 313: AND gd.application_id = PA_PERIOD_PROCESS_PKG.Application_id

309: (NVL(pji_tmp.pou_brdn_cost, 0) <> 0) OR --Bug 9666017
310: (NVL(pji_tmp.quantity,0) <> 0)
311: )
312: AND gd.SET_OF_BOOKS_ID = c_set_of_books_id
313: AND gd.application_id = PA_PERIOD_PROCESS_PKG.Application_id
314: AND gd.ADJUSTMENT_PERIOD_FLAG = 'N'
315: AND gd.period_name = pji_tmp.period_name
316: AND pji_tmp.source_id = c_res_asg_id
317: AND DECODE(c_multi_currency_flag,'Y',

Line 364: AND gd.application_id = PA_PERIOD_PROCESS_PKG.Application_id

360: (NVL(pji_tmp.pou_revenue, 0) <> 0) OR --Bug 9666017
361: (NVL(pji_tmp.quantity,0) <> 0)
362: )
363: AND gd.SET_OF_BOOKS_ID = c_set_of_books_id
364: AND gd.application_id = PA_PERIOD_PROCESS_PKG.Application_id
365: AND gd.ADJUSTMENT_PERIOD_FLAG = 'N'
366: AND gd.period_name = pji_tmp.period_name
367: AND pji_tmp.source_id = c_res_asg_id
368: AND DECODE(c_multi_currency_flag,'Y',

Line 2283: AND gd.application_id = PA_PERIOD_PROCESS_PKG.Application_id

2279: (NVL(pji_tmp.txn_revenue, 0) <> 0) OR
2280: (NVL(pji_tmp.quantity,0) <> 0)
2281: )
2282: AND gd.SET_OF_BOOKS_ID = c_set_of_books_id
2283: AND gd.application_id = PA_PERIOD_PROCESS_PKG.Application_id
2284: AND gd.ADJUSTMENT_PERIOD_FLAG = 'N'
2285: AND gd.period_name = pji_tmp.period_name
2286: GROUP BY pji_tmp.source_id,
2287: DECODE(c_multi_currency_flag,

Line 2340: AND gd.application_id = PA_PERIOD_PROCESS_PKG.Application_id

2336: (NVL(pji_tmp.txn_brdn_cost, 0) <> 0) OR
2337: (NVL(pji_tmp.quantity,0) <> 0)
2338: )
2339: AND gd.SET_OF_BOOKS_ID = c_set_of_books_id
2340: AND gd.application_id = PA_PERIOD_PROCESS_PKG.Application_id
2341: AND gd.ADJUSTMENT_PERIOD_FLAG = 'N'
2342: AND gd.period_name = pji_tmp.period_name
2343: GROUP BY pji_tmp.source_id,
2344: DECODE(c_multi_currency_flag,