APPS.PA_UBR_UER_SUMM_PKG dependencies on PA_UBR_UER_SUMM_ACCT_S

Line 205: from pa_ubr_uer_summ_acct sel1

201: (UBR_BAL_PREV_PERIOD_DR+UNBILLED_RECEIVABLE_DR) -
202: (UER_BAL_PREV_PERIOD_CR + UNEARNED_REVENUE_CR) )),
203: 0, decode(zero_balance_flag,'N','Y','X'),
204: decode(zero_balance_flag,'Y','N','X')) zero_bal_flag
205: from pa_ubr_uer_summ_acct sel1
206: where sel1.project_id in
207: ( select distinct temp1.project_id
208: from pa_draft_rev_inv_temp temp1 )
209: group by

Line 439: from pa_ubr_uer_summ_acct sel1

435: UPDATE pa_ubr_uer_summ_acct upd1
436: SET ( upd1.UBR_BAL_PREV_PERIOD_DR, upd1.UER_BAL_PREV_PERIOD_CR ) =
437: ( select nvl(sum(sel1.UNBILLED_RECEIVABLE_DR),0),
438: nvl(sum(sel1.UNEARNED_REVENUE_CR),0)
439: from pa_ubr_uer_summ_acct sel1
440: where sel1.project_id = upd1.project_id
441: and sel1.account_segment = upd1.account_segment
442: and sel1.cost_center_segment = upd1.cost_center_segment
443: and sel1.gl_period_start_date < upd1.gl_period_start_date )

Line 555: from pa_ubr_uer_summ_acct sel1

551: (UBR_BAL_PREV_PERIOD_DR+UNBILLED_RECEIVABLE_DR) -
552: (UER_BAL_PREV_PERIOD_CR + UNEARNED_REVENUE_CR) )),
553: 0, decode(zero_balance_flag,'N','Y','X'),
554: decode(zero_balance_flag,'Y','N','X')) zero_bal_flag
555: from pa_ubr_uer_summ_acct sel1
556: where sel1.project_id in
557: ( select distinct temp1.project_id
558: from pa_draft_rev_inv_temp temp1 )
559: group by

Line 792: from pa_ubr_uer_summ_acct sel1

788: FORALL j IN l_sum_project_id_arr.FIRST..l_sum_project_id_arr.LAST
789: UPDATE pa_ubr_uer_summ_acct upd1
790: SET ( upd1.UBR_BAL_PREV_PERIOD_DR, upd1.UER_BAL_PREV_PERIOD_CR ) =
791: ( select nvl(sum(sel1.UNBILLED_RECEIVABLE_DR),0),nvl(sum(sel1.UNEARNED_REVENUE_CR),0)
792: from pa_ubr_uer_summ_acct sel1
793: where sel1.project_id = upd1.project_id
794: and sel1.account_segment = upd1.account_segment
795: and sel1.cost_center_segment = upd1.cost_center_segment
796: and sel1.gl_period_start_date < upd1.gl_period_start_date )

Line 1043: select pa_ubr_uer_summ_acct_s.nextval

1039: l_ins_sum_amt_arr(ins_j) := l_sum_amt_arr(i);
1040: l_ins_process_ubr_uer_arr(ins_j) := l_process_ubr_uer_arr(i);
1041: l_ins_gl_per_stdt_arr(ins_j) := l_gl_period_start_date_arr(i);
1042:
1043: select pa_ubr_uer_summ_acct_s.nextval
1044: into l_ins_summary_id_arr(ins_j)
1045: from dual;
1046:
1047: l_ins_ins_upd_flag_arr(ins_j) := 'I';

Line 1182: from pa_ubr_uer_summ_acct sum2

1178: where project_id = l_ins_sum_project_id_arr(J)
1179: and gl_period_name = l_ins_gl_period_arr(J)
1180: and multi_cost_center_flag = 'N'
1181: and EXISTS ( select 'x'
1182: from pa_ubr_uer_summ_acct sum2
1183: where sum2.project_id = sum1.project_id
1184: and sum2.gl_period_name = sum1.gl_period_name
1185: and sum2.cost_center_segment <> l_ins_cost_seg_arr(J) );
1186: