DBA Data[Home] [Help]

APPS.PA_TXN_ACCUMS dependencies on PA_UTILS

Line 3254: pa_utils.GetWeekEnding(ev.completion_date) week_ending_date,

3250: NVL(erdl.task_id,0) task_id,
3251: dr.PA_PERIOD_NAME pa_period,
3252: dr.GL_PERIOD_NAME gl_period,
3253: evt.event_type_classification,
3254: pa_utils.GetWeekEnding(ev.completion_date) week_ending_date,
3255: LAST_DAY(ev.completion_date) month_ending_date,
3256: NVL(erdl.amount,0) amount
3257: FROM
3258: pa_events ev,

Line 3526: pa_utils.GetWeekEnding(ev.completion_date) week_ending_date,

3522: erdl.project_id project_id,
3523: NVL(erdl.task_id,0) task_id,
3524: dr.PA_PERIOD_NAME pa_period,
3525: dr.GL_PERIOD_NAME gl_period,
3526: pa_utils.GetWeekEnding(ev.completion_date) week_ending_date,
3527: LAST_DAY(ev.completion_date) month_ending_date,
3528: TO_NUMBER(NULL) rev_ind_compiled_set_id,
3529: TO_NUMBER(NULL) inv_ind_compiled_set_id,
3530: NVL(erdl.amount,0) amount,

Line 3774: pa_utils.GetWeekEnding(pct.expenditure_item_date) week_ending_date,

3770: SELECT
3771: pct.cmt_line_id,
3772: pct.project_id,
3773: pct.task_id,
3774: pa_utils.GetWeekEnding(pct.expenditure_item_date) week_ending_date,
3775: LAST_DAY(pct.expenditure_item_date) month_ending_date,
3776: pct.pa_period,
3777: pct.gl_period,
3778: pct.organization_id,