DBA Data[Home] [Help]

APPS.PA_ALLOC_RUN dependencies on PA_BASE_FINPLAN_BY_GL_PERIOD_V

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

7103: from pa_alloc_run_resource_det parr,
7104: pa_alloc_run_targets part,
7105: /*** pa_base_budget_by_gl_period_v pbpg *** commented bug 2619977 */
7106: /* pa_base_finplan_by_pa_period_v pfpg added bug 2619977 commented bug 2757875 */
7107: pa_base_finplan_by_gl_period_v pfpg /* added bug 2757875 */
7108: where Decode (
7109: NVL(p_basis_resource_struct_Type,'RL') ,
7110: 'RL' , pfpg.resource_list_member_id ,
7111: 'RBS' , pfpg.RBS_ELEMENT_ID

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

8570: 0
8571: ))
8572: /*** from pa_base_budget_by_pa_period_v pbpp, *** commented bug 2619977 */
8573: /**** from pa_base_finplan_by_pa_period_v pfpp, added bug 2619977. **** Commented bug 2757875*/
8574: from pa_base_finplan_by_gl_period_v pfpp, /* Added bug 2757875 */
8575: pa_alloc_run_targets part
8576: where part.rule_id = p_rule_id
8577: and part.run_id = p_run_id
8578: and part.exclude_flag = 'N'

Line 8610: from pa_base_finplan_by_gl_period_v pfgp,

8606: 'BASE_QUANTITY', nvl(pfgp.quantity,0),
8607: 'BASE_LABOR_QUANTITY', nvl(pfgp.labor_quantity,0),
8608: 0
8609: ))
8610: from pa_base_finplan_by_gl_period_v pfgp,
8611: pa_alloc_run_targets part
8612: where part.rule_id = p_rule_id
8613: and part.run_id = p_run_id
8614: and part.exclude_flag = 'N'