APPS.PA_TXN_ACCUMS dependencies on PA_UTILS

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

3430: NVL(erdl.task_id,0) task_id,
3431: dr.PA_PERIOD_NAME pa_period,
3432: dr.GL_PERIOD_NAME gl_period,
3433: evt.event_type_classification,
3434: pa_utils.GetWeekEnding(ev.completion_date) week_ending_date,
3435: LAST_DAY(ev.completion_date) month_ending_date,
3436: NVL(erdl.amount,0) amount
3437: FROM
3438: pa_events ev,

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

3702: erdl.project_id project_id,
3703: NVL(erdl.task_id,0) task_id,
3704: dr.PA_PERIOD_NAME pa_period,
3705: dr.GL_PERIOD_NAME gl_period,
3706: pa_utils.GetWeekEnding(ev.completion_date) week_ending_date,
3707: LAST_DAY(ev.completion_date) month_ending_date,
3708: TO_NUMBER(NULL) rev_ind_compiled_set_id,
3709: TO_NUMBER(NULL) inv_ind_compiled_set_id,
3710: NVL(erdl.amount,0) amount,

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

3950: SELECT
3951: pct.cmt_line_id,
3952: pct.project_id,
3953: pct.task_id,
3954: pa_utils.GetWeekEnding(pct.expenditure_item_date) week_ending_date,
3955: LAST_DAY(pct.expenditure_item_date) month_ending_date,
3956: pct.pa_period,
3957: pct.gl_period,
3958: pct.organization_id,