APPS.PA_FP_GEN_FCST_RMAP_PKG dependencies on PA_BUDGET_LINES

Line 463: FROM pa_budget_lines bl

459: --AND ra.resource_assignment_id = tmp1.resource_assignment_id
460: AND ( ra.transaction_source_code IS NOT NULL
461: OR ( ra.transaction_source_code IS NULL
462: AND NOT EXISTS ( SELECT 1
463: FROM pa_budget_lines bl
464: WHERE bl.resource_assignment_id =
465: ra.resource_assignment_id
466: AND bl.start_date >= l_etc_start_date
467: AND rownum = 1 )))

Line 487: FROM pa_budget_lines bl

483: --AND ra.resource_assignment_id = tmp1.resource_assignment_id
484: AND ( ra.transaction_source_code IS NOT NULL
485: OR ( ra.transaction_source_code IS NULL
486: AND NOT EXISTS ( SELECT 1
487: FROM pa_budget_lines bl
488: WHERE bl.resource_assignment_id =
489: ra.resource_assignment_id
490: AND NVL(bl.quantity,0) <>
491: NVL(bl.init_quantity,0)

Line 590: FROM pa_budget_lines bl

586: AND ra.resource_assignment_id = tmp1.target_res_asg_id
587: AND ( ra.transaction_source_code IS NOT NULL
588: OR ( ra.transaction_source_code IS NULL
589: AND NOT EXISTS ( SELECT 1
590: FROM pa_budget_lines bl
591: WHERE bl.resource_assignment_id =
592: ra.resource_assignment_id
593: AND bl.start_date >= l_etc_start_date
594: AND rownum = 1 )));

Line 608: FROM pa_budget_lines bl

604: AND ra.resource_assignment_id = tmp1.target_res_asg_id
605: AND ( ra.transaction_source_code IS NOT NULL
606: OR ( ra.transaction_source_code IS NULL
607: AND NOT EXISTS ( SELECT 1
608: FROM pa_budget_lines bl
609: WHERE bl.resource_assignment_id =
610: ra.resource_assignment_id
611: AND NVL(bl.quantity,0) <>
612: NVL(bl.init_quantity,0)