APPS.PSP_ADJ_DRIVER dependencies on PSP_EFFORT_REPORT_ELEMENTS

Line 2596: and element_type_id in (select element_type_id from psp_effort_report_elements

2592: from psp_adjustment_lines
2593: where batch_name = p_batch_name
2594: and business_group_id = p_business_group_id
2595: and set_of_books_id = p_set_of_books_id
2596: and element_type_id in (select element_type_id from psp_effort_report_elements
2597: where use_in_effort_report='Y');
2598:
2599: / *****************************************************************
2600: Commenting the following cursor for Bug fix :2252881:

Line 2720: FROM psp_effort_report_elements pere

2716: AND pal.distribution_date BETWEEN pert.begin_date
2717: AND pert.end_date
2718: AND pal.element_type_id IN
2719: (SELECT pere.element_type_id
2720: FROM psp_effort_report_elements pere
2721: WHERE pere.use_in_effort_report = 'Y'));
2722: -- End of bug fix 2724110
2723: p_return_status := fnd_api.g_ret_sts_success;
2724:

Line 4298: FROM psp_effort_report_elements pere

4294: WHERE person_id = p_person_id
4295: AND batch_name <> p_batch_name
4296: AND distribution_date BETWEEN p_begin_date AND p_end_date
4297: AND EXISTS (SELECT 1
4298: FROM psp_effort_report_elements pere
4299: WHERE pere.element_type_id = pal.element_type_id
4300: AND pere.use_in_effort_report='Y')
4301: AND ROWNUM = 1;
4302: