APPS.PA_FP_GEN_FCST_RMAP_PKG dependencies on PA_BUDGET_LINES

Line 466: FROM pa_budget_lines bl

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

Line 491: FROM pa_budget_lines bl

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

Line 601: FROM pa_budget_lines bl

597: AND ra.resource_assignment_id = tmp1.target_res_asg_id
598: AND ( ra.transaction_source_code IS NOT NULL
599: OR ( ra.transaction_source_code IS NULL
600: AND NOT EXISTS ( SELECT 1
601: FROM pa_budget_lines bl
602: WHERE bl.resource_assignment_id =
603: ra.resource_assignment_id
604: AND bl.start_date >= l_etc_start_date
605: AND rownum = 1 )));

Line 619: FROM pa_budget_lines bl

615: AND ra.resource_assignment_id = tmp1.target_res_asg_id
616: AND ( ra.transaction_source_code IS NOT NULL
617: OR ( ra.transaction_source_code IS NULL
618: AND NOT EXISTS ( SELECT 1
619: FROM pa_budget_lines bl
620: WHERE bl.resource_assignment_id =
621: ra.resource_assignment_id
622: AND NVL(bl.quantity,0) <>
623: NVL(bl.init_quantity,0)