DBA Data[Home] [Help]

APPS.PA_ALLOC_RUN dependencies on PA_BASE_FINPLAN_BY_PA_PERIOD_V

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

7036: ,G_last_update_login
7037: from pa_alloc_run_resource_det parr,
7038: pa_alloc_run_targets part,
7039: /*** pa_base_budget_by_pa_period_v pbpp *** commented bug 2619977 */
7040: pa_base_finplan_by_pa_period_v pfpp /* added bug 2619977 */
7041: where Decode (
7042: Nvl(p_basis_resource_struct_Type,'RL') ,
7043: 'RL' , pfpp.resource_list_member_id ,
7044: 'RBS' , pfpp.RBS_ELEMENT_ID

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

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

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

8532: 'BASE_LABOR_QUANTITY', nvl(pfpp.labor_quantity,0),
8533: 0
8534: ))
8535: /*** from pa_base_budget_by_pa_period_v pbpp, *** commented bug 2619977 */
8536: from pa_base_finplan_by_pa_period_v pfpp, /* added bug 2619977 */
8537: pa_projects_all p ,
8538: pa_alloc_run_targets part
8539: where part.rule_id = p_rule_id
8540: and part.run_id = p_run_id

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

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

Line 8641: from pa_base_finplan_by_pa_period_v pfpp,

8637: 'BASE_QUANTITY', nvl(pfpp.quantity,0),
8638: 'BASE_LABOR_QUANTITY', nvl(pfpp.labor_quantity,0),
8639: 0
8640: ))
8641: from pa_base_finplan_by_pa_period_v pfpp,
8642: pa_alloc_run_targets part
8643: where part.rule_id = p_rule_id
8644: and part.run_id = p_run_id
8645: and part.exclude_flag = 'N'