APPS.PA_TXN_ACCUMS dependencies on PA_DRAFT_REVENUES

Line 221: UPDATE pa_draft_revenues SET

217: END IF;
218: END LOOP;
219:
220: LOOP
221: UPDATE pa_draft_revenues SET
222: resource_accumulated_flag = 'S'
223: WHERE project_id = x_start_project_id AND
224: released_date IS NOT NULL AND
225: resource_accumulated_flag <> 'S' AND

Line 3221: pa_draft_revenues dr

3217: pa_expenditures_all pe,
3218: pa_expenditure_types et,
3219: pa_expenditure_items_all ei,
3220: pa_cust_rev_dist_lines rdl,
3221: pa_draft_revenues dr
3222: WHERE
3223: dr.project_id = x_start_project_id -- BETWEEN x_start_project_id AND x_end_project_id Commented for Bug # 3736097
3224: AND NVL(dr.resource_accumulated_flag,'S') =
3225: DECODE(x_mode,'I','S',

Line 3249: pa_draft_revenues dr,

3245: pa_expenditures_all pe,
3246: pa_expenditure_types et,
3247: pa_expenditure_items_all ei,
3248: pa_cust_rev_dist_lines rdl,
3249: pa_draft_revenues dr,
3250: pa_implementations pi,
3251: gl_sets_of_books sob
3252: WHERE
3253: dr.project_id = x_start_project_id -- BETWEEN x_start_project_id AND x_end_project_id Commented for Bug # 3736097

Line 3361: pa_draft_revenues

3357:
3358: --- Update the DR.Resource_accumulated_flag = 'Y' Now
3359:
3360: UPDATE
3361: pa_draft_revenues
3362: SET
3363: resource_accumulated_flag = 'S'
3364: WHERE
3365: ROWID = rdlrec.drrowid;

Line 3441: pa_draft_revenues dr

3437: FROM
3438: pa_events ev,
3439: pa_event_types evt,
3440: pa_cust_event_rev_dist_lines erdl,
3441: pa_draft_revenues dr
3442: WHERE
3443: dr.project_id = x_start_project_id -- BETWEEN x_start_project_id AND x_end_project_id commented for Bug # 3736097
3444: AND NVL(dr.resource_accumulated_flag,'S') =
3445: DECODE(x_mode,'I','S',

Line 3467: pa_draft_revenues dr,

3463: gl_date_period_map g,
3464: pa_events ev,
3465: pa_event_types evt,
3466: pa_cust_event_rev_dist_lines erdl,
3467: pa_draft_revenues dr,
3468: pa_implementations pi,
3469: gl_sets_of_books sob
3470: WHERE
3471: dr.project_id = x_start_project_id -- BETWEEN x_start_project_id AND x_end_project_id commented for Bug # 3736097

Line 3579: pa_draft_revenues

3575:
3576: --- Update the DR.Resource_accumulated_flag = 'Y' Now
3577:
3578: UPDATE
3579: pa_draft_revenues
3580: SET
3581: resource_accumulated_flag = 'S'
3582: WHERE
3583: ROWID = eventrec.drrowid;

Line 3672: pa_draft_revenues dr

3668: pa_expenditures_all pe,
3669: pa_expenditure_types et,
3670: pa_expenditure_items_all ei,
3671: pa_cust_rev_dist_lines rdl,
3672: pa_draft_revenues dr
3673: WHERE
3674: dr.project_id = x_start_project_id ---- x_start_project_id and x_end_project_id
3675: AND NVL(dr.resource_accumulated_flag,'S') =
3676: DECODE(x_mode,'I','S',

Line 3719: pa_draft_revenues dr

3715: FROM
3716: pa_events ev,
3717: pa_event_types evt,
3718: pa_cust_event_rev_dist_lines erdl,
3719: pa_draft_revenues dr
3720: WHERE
3721: dr.project_id = x_start_project_id ---- x_start_project_id and x_end_project_id
3722: AND NVL(dr.resource_accumulated_flag,'S') =
3723: DECODE(x_mode,'I','S',

Line 3743: pa_draft_revenues dr,

3739: g.period_name gl_period1
3740: FROM
3741: gl_date_period_map p,
3742: gl_date_period_map g,
3743: pa_draft_revenues dr,
3744: pa_implementations pi,
3745: gl_sets_of_books sob
3746: WHERE
3747: dr.project_id = x_start_project_id

Line 3792: pa_draft_revenues

3788: -- pa_debug.debug('curr_rowid='||curr_rowid);
3789:
3790: --- Update the DR.Resource_accumulated_flag = 'Y' Now
3791: UPDATE
3792: pa_draft_revenues
3793: SET
3794: resource_accumulated_flag = 'Y',
3795: last_updated_by = x_last_updated_by,
3796: last_update_login = x_last_update_login,

Line 3883: pa_draft_revenues

3879: END LOOP;
3880:
3881: --- Update the DR.Resource_accumulated_flag = 'Y' Now
3882: UPDATE
3883: pa_draft_revenues
3884: SET
3885: resource_accumulated_flag = 'Y',
3886: last_updated_by = x_last_updated_by,
3887: last_update_login = x_last_update_login,