[Home] [Help]
2904: pa_expenditures_all pe,
2905: pa_expenditure_types et,
2906: pa_expenditure_items_all ei,
2907: pa_cost_distribution_lines_all cdl,
2908: pa_implementations pi,
2909: gl_sets_of_books sob
2910: WHERE
2911: -- cdl.project_id BETWEEN x_start_project_id AND x_end_project_id -- Modified for bug 3736097
2912: cdl.project_id = x_start_project_id
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
3254: AND dr.ROWID = CHARTOROWID(rrowid)
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
3472: AND dr.ROWID = CHARTOROWID(rrowid)
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
3748: AND dr.ROWID = CHARTOROWID(rrowid)
3977: pct.receipt_exchange_rate
3978: FROM
3979: pa_commitment_txns pct
3980: -- Bug#2634995 - removed the reference to pa_implentations as it is not used in the SQL
3981: -- ,pa_implementations pi
3982: WHERE
3983: pct.project_id = x_start_project_id -- BETWEEN x_start_project_id AND x_end_project_id commented for bug 3736097
3984: AND pct.system_linkage_function||'' =
3985: NVL(x_system_linkage_function,pct.system_linkage_function);