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 3041: pa_draft_revenues dr

3037: pa_expenditures_all pe,
3038: pa_expenditure_types et,
3039: pa_expenditure_items_all ei,
3040: pa_cust_rev_dist_lines rdl,
3041: pa_draft_revenues dr
3042: WHERE
3043: dr.project_id = x_start_project_id -- BETWEEN x_start_project_id AND x_end_project_id Commented for Bug # 3736097
3044: AND NVL(dr.resource_accumulated_flag,'S') =
3045: DECODE(x_mode,'I','S',

Line 3069: pa_draft_revenues dr,

3065: pa_expenditures_all pe,
3066: pa_expenditure_types et,
3067: pa_expenditure_items_all ei,
3068: pa_cust_rev_dist_lines rdl,
3069: pa_draft_revenues dr,
3070: pa_implementations pi,
3071: gl_sets_of_books sob
3072: WHERE
3073: dr.project_id = x_start_project_id -- BETWEEN x_start_project_id AND x_end_project_id Commented for Bug # 3736097

Line 3181: pa_draft_revenues

3177:
3178: --- Update the DR.Resource_accumulated_flag = 'Y' Now
3179:
3180: UPDATE
3181: pa_draft_revenues
3182: SET
3183: resource_accumulated_flag = 'S'
3184: WHERE
3185: ROWID = rdlrec.drrowid;

Line 3261: pa_draft_revenues dr

3257: FROM
3258: pa_events ev,
3259: pa_event_types evt,
3260: pa_cust_event_rev_dist_lines erdl,
3261: pa_draft_revenues dr
3262: WHERE
3263: dr.project_id = x_start_project_id -- BETWEEN x_start_project_id AND x_end_project_id commented for Bug # 3736097
3264: AND NVL(dr.resource_accumulated_flag,'S') =
3265: DECODE(x_mode,'I','S',

Line 3287: pa_draft_revenues dr,

3283: gl_date_period_map g,
3284: pa_events ev,
3285: pa_event_types evt,
3286: pa_cust_event_rev_dist_lines erdl,
3287: pa_draft_revenues dr,
3288: pa_implementations pi,
3289: gl_sets_of_books sob
3290: WHERE
3291: dr.project_id = x_start_project_id -- BETWEEN x_start_project_id AND x_end_project_id commented for Bug # 3736097

Line 3399: pa_draft_revenues

3395:
3396: --- Update the DR.Resource_accumulated_flag = 'Y' Now
3397:
3398: UPDATE
3399: pa_draft_revenues
3400: SET
3401: resource_accumulated_flag = 'S'
3402: WHERE
3403: ROWID = eventrec.drrowid;

Line 3492: pa_draft_revenues dr

3488: pa_expenditures_all pe,
3489: pa_expenditure_types et,
3490: pa_expenditure_items_all ei,
3491: pa_cust_rev_dist_lines rdl,
3492: pa_draft_revenues dr
3493: WHERE
3494: dr.project_id = x_start_project_id ---- x_start_project_id and x_end_project_id
3495: AND NVL(dr.resource_accumulated_flag,'S') =
3496: DECODE(x_mode,'I','S',

Line 3539: pa_draft_revenues dr

3535: FROM
3536: pa_events ev,
3537: pa_event_types evt,
3538: pa_cust_event_rev_dist_lines erdl,
3539: pa_draft_revenues dr
3540: WHERE
3541: dr.project_id = x_start_project_id ---- x_start_project_id and x_end_project_id
3542: AND NVL(dr.resource_accumulated_flag,'S') =
3543: DECODE(x_mode,'I','S',

Line 3563: pa_draft_revenues dr,

3559: g.period_name gl_period1
3560: FROM
3561: gl_date_period_map p,
3562: gl_date_period_map g,
3563: pa_draft_revenues dr,
3564: pa_implementations pi,
3565: gl_sets_of_books sob
3566: WHERE
3567: dr.project_id = x_start_project_id

Line 3612: pa_draft_revenues

3608: -- pa_debug.debug('curr_rowid='||curr_rowid);
3609:
3610: --- Update the DR.Resource_accumulated_flag = 'Y' Now
3611: UPDATE
3612: pa_draft_revenues
3613: SET
3614: resource_accumulated_flag = 'Y',
3615: last_updated_by = x_last_updated_by,
3616: last_update_login = x_last_update_login,

Line 3703: pa_draft_revenues

3699: END LOOP;
3700:
3701: --- Update the DR.Resource_accumulated_flag = 'Y' Now
3702: UPDATE
3703: pa_draft_revenues
3704: SET
3705: resource_accumulated_flag = 'Y',
3706: last_updated_by = x_last_updated_by,
3707: last_update_login = x_last_update_login,