DBA Data[Home] [Help]

APPS.PA_ALLOC_RUN dependencies on PA_BASE_FINPLAN_BY_GL_PERIOD_V

Line 7084: pa_base_finplan_by_gl_period_v pfpg /* added bug 2757875 */

7080: from pa_alloc_run_resource_det parr,
7081: pa_alloc_run_targets part,
7082: /*** pa_base_budget_by_gl_period_v pbpg *** commented bug 2619977 */
7083: /* pa_base_finplan_by_pa_period_v pfpg added bug 2619977 commented bug 2757875 */
7084: pa_base_finplan_by_gl_period_v pfpg /* added bug 2757875 */
7085: where Decode (
7086: NVL(p_basis_resource_struct_Type,'RL') ,
7087: 'RL' , pfpg.resource_list_member_id ,
7088: 'RBS' , pfpg.RBS_ELEMENT_ID

Line 8469: from pa_base_finplan_by_gl_period_v pfpp, /* Added bug 2757875 */

8465: 0
8466: ))
8467: /*** from pa_base_budget_by_pa_period_v pbpp, *** commented bug 2619977 */
8468: /**** from pa_base_finplan_by_pa_period_v pfpp, added bug 2619977. **** Commented bug 2757875*/
8469: from pa_base_finplan_by_gl_period_v pfpp, /* Added bug 2757875 */
8470: pa_alloc_run_targets part
8471: where part.rule_id = p_rule_id
8472: and part.run_id = p_run_id
8473: and part.exclude_flag = 'N'

Line 8505: from pa_base_finplan_by_gl_period_v pfgp,

8501: 'BASE_QUANTITY', nvl(pfgp.quantity,0),
8502: 'BASE_LABOR_QUANTITY', nvl(pfgp.labor_quantity,0),
8503: 0
8504: ))
8505: from pa_base_finplan_by_gl_period_v pfgp,
8506: pa_alloc_run_targets part
8507: where part.rule_id = p_rule_id
8508: and part.run_id = p_run_id
8509: and part.exclude_flag = 'N'