DBA Data[Home] [Help]

APPS.PA_BC_COSTING dependencies on GL_PERIOD_STATUSES

Line 196: ,gl_period_statuses glp

192: ,pa_projects_all p
193: ,pa_expenditures exp
194: ,pa_budget_versions bv
195: ,pa_budgetary_control_options pbct
196: ,gl_period_statuses glp
197: WHERE ei.cost_distributed_flag = 'S'
198: AND ei.request_id = g_request_id
199: AND ei.cost_dist_rejection_code IS NULL
200: AND (ei.system_linkage_function IN ('VI') OR

Line 457: ,gl_period_statuses glp

453: ,pa_project_types_all pt
454: ,pa_projects_all p
455: ,pa_budget_versions bv
456: ,pa_budgetary_control_options pbct
457: ,gl_period_statuses glp
458: WHERE
459: /*
460: * With I lines, this check is no longer valid.
461: * transfer_status_code check is not needed.

Line 2339: ,gl_period_statuses glp

2335: ,pa_projects_all p
2336: ,pa_expenditures exp
2337: ,pa_budget_versions bv
2338: ,pa_budgetary_control_options pbct
2339: ,gl_period_statuses glp
2340: ,po_distributions_all pod /* 6989758 */
2341: WHERE ei.cost_distributed_flag = 'S'
2342: AND ei.request_id = g_request_id
2343: AND ei.cost_dist_rejection_code IS NULL

Line 2592: ,gl_period_statuses glp

2588: ,pa_project_types_all pt
2589: ,pa_projects_all p
2590: ,pa_budget_versions bv
2591: ,pa_budgetary_control_options pbct
2592: ,gl_period_statuses glp
2593: WHERE cdl.line_num_reversed IS NULL
2594: AND cdl.reversed_flag IS NULL
2595: AND cdl.request_id = g_request_id
2596: AND cdl.line_type in ('R', 'I')