APPS.PA_ALLOC_RUN dependencies on PA_BASE_FINPLAN_BY_PA_PERIOD_V

Line 7017: pa_base_finplan_by_pa_period_v pfpp /* added bug 2619977 */

7013: ,G_last_update_login
7014: from pa_alloc_run_resource_det parr,
7015: pa_alloc_run_targets part,
7016: /*** pa_base_budget_by_pa_period_v pbpp *** commented bug 2619977 */
7017: pa_base_finplan_by_pa_period_v pfpp /* added bug 2619977 */
7018: where Decode (
7019: Nvl(p_basis_resource_struct_Type,'RL') ,
7020: 'RL' , pfpp.resource_list_member_id ,
7021: 'RBS' , pfpp.RBS_ELEMENT_ID

Line 7083: /* pa_base_finplan_by_pa_period_v pfpg added bug 2619977 commented bug 2757875 */

7079: ,G_last_update_login
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 ,

Line 8431: from pa_base_finplan_by_pa_period_v pfpp, /* added bug 2619977 */

8427: 'BASE_LABOR_QUANTITY', nvl(pfpp.labor_quantity,0),
8428: 0
8429: ))
8430: /*** from pa_base_budget_by_pa_period_v pbpp, *** commented bug 2619977 */
8431: from pa_base_finplan_by_pa_period_v pfpp, /* added bug 2619977 */
8432: pa_projects_all p ,
8433: pa_alloc_run_targets part
8434: where part.rule_id = p_rule_id
8435: and part.run_id = p_run_id

Line 8468: /**** from pa_base_finplan_by_pa_period_v pfpp, added bug 2619977. **** Commented bug 2757875*/

8464: 'BASE_LABOR_QUANTITY', nvl(pfpp.labor_quantity,0),
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

Line 8536: from pa_base_finplan_by_pa_period_v pfpp,

8532: 'BASE_QUANTITY', nvl(pfpp.quantity,0),
8533: 'BASE_LABOR_QUANTITY', nvl(pfpp.labor_quantity,0),
8534: 0
8535: ))
8536: from pa_base_finplan_by_pa_period_v pfpp,
8537: pa_alloc_run_targets part
8538: where part.rule_id = p_rule_id
8539: and part.run_id = p_run_id
8540: and part.exclude_flag = 'N'