[Home] [Help]
2791: pa_expenditures_all pe,
2792: pa_expenditure_types et,
2793: pa_expenditure_items_all ei,
2794: pa_cost_distribution_lines_all cdl,
2795: pa_implementations pi,
2796: gl_sets_of_books sob
2797: WHERE
2798: -- cdl.project_id BETWEEN x_start_project_id AND x_end_project_id -- Modified for bug 3736097
2799: cdl.project_id = x_start_project_id
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
3074: AND dr.ROWID = CHARTOROWID(rrowid)
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
3292: AND dr.ROWID = CHARTOROWID(rrowid)
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
3568: AND dr.ROWID = CHARTOROWID(rrowid)
3797: pct.receipt_exchange_rate
3798: FROM
3799: pa_commitment_txns pct
3800: -- Bug#2634995 - removed the reference to pa_implentations as it is not used in the SQL
3801: -- ,pa_implementations pi
3802: WHERE
3803: pct.project_id = x_start_project_id -- BETWEEN x_start_project_id AND x_end_project_id commented for bug 3736097
3804: AND pct.system_linkage_function||'' =
3805: NVL(x_system_linkage_function,pct.system_linkage_function);