APPS.PA_UBR_UER_SUMM_PKG dependencies on PA_UBR_UER_SUMM_ACCT_S

Line 207: from pa_ubr_uer_summ_acct sel1

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

Line 441: from pa_ubr_uer_summ_acct sel1

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

Line 557: from pa_ubr_uer_summ_acct sel1

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

Line 794: from pa_ubr_uer_summ_acct sel1

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

Line 1045: select pa_ubr_uer_summ_acct_s.nextval

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

Line 1184: from pa_ubr_uer_summ_acct sum2

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