APPS.PSP_ADJ_DRIVER dependencies on PSP_EFFORT_REPORT_ELEMENTS

Line 2587: and element_type_id in (select element_type_id from psp_effort_report_elements

2583: from psp_adjustment_lines
2584: where batch_name = p_batch_name
2585: and business_group_id = p_business_group_id
2586: and set_of_books_id = p_set_of_books_id
2587: and element_type_id in (select element_type_id from psp_effort_report_elements
2588: where use_in_effort_report='Y');
2589:
2590: / *****************************************************************
2591: Commenting the following cursor for Bug fix :2252881:

Line 2711: FROM psp_effort_report_elements pere

2707: AND pal.distribution_date BETWEEN pert.begin_date
2708: AND pert.end_date
2709: AND pal.element_type_id IN
2710: (SELECT pere.element_type_id
2711: FROM psp_effort_report_elements pere
2712: WHERE pere.use_in_effort_report = 'Y'));
2713: -- End of bug fix 2724110
2714: p_return_status := fnd_api.g_ret_sts_success;
2715:

Line 4289: FROM psp_effort_report_elements pere

4285: WHERE person_id = p_person_id
4286: AND batch_name <> p_batch_name
4287: AND distribution_date BETWEEN p_begin_date AND p_end_date
4288: AND EXISTS (SELECT 1
4289: FROM psp_effort_report_elements pere
4290: WHERE pere.element_type_id = pal.element_type_id
4291: AND pere.use_in_effort_report='Y')
4292: AND ROWNUM = 1;
4293: