APPS.PSP_ADJ_DRIVER dependencies on PSP_EFFORT_REPORT_TEMPLATES

Line 2607: from psp_effort_report_templates pert

2603: where per.person_id = p_per_id
2604: and per.business_group_id = p_business_group_id
2605: and per.set_of_books_id = p_set_of_books_id
2606: and per.template_id in (select pert.template_id
2607: from psp_effort_report_templates pert
2608: where pert.report_type = 'N'
2609: -- and pert.person_id = p_per_id
2610: and pert.business_group_id = p_business_group_id
2611: and pert.set_of_books_id = p_set_of_books_id);

Line 2615: from psp_effort_report_templates

2611: and pert.set_of_books_id = p_set_of_books_id);
2612:
2613: cursor effort_templates_c(p_template_id IN NUMBER) is
2614: select begin_date, end_date
2615: from psp_effort_report_templates
2616: where template_id = p_template_id and
2617: report_type='N'
2618: and business_group_id = p_business_group_id
2619: and set_of_books_id = p_set_of_books_id;

Line 2626: FROM psp_effort_report_templates pert

2622: / * Following cursor is modified for bug 2252881 * /
2623: CURSOR effort_reports_c(p_per_id NUMBER)
2624: IS
2625: SELECT pert.template_id, pert.begin_date, pert.end_date
2626: FROM psp_effort_report_templates pert
2627: WHERE pert.report_type ='N'
2628: AND pert.template_id IN(
2629: SELECT per.template_id
2630: FROM psp_effort_reports per

Line 2696: FROM psp_effort_report_templates pert,

2692: AND per.business_group_id = p_business_group_id
2693: AND per.set_of_books_id = p_set_of_books_id
2694: AND (per.person_id, per.template_id) IN
2695: (SELECT pal.person_id, pert.template_id
2696: FROM psp_effort_report_templates pert,
2697: psp_effort_reports per2,
2698: psp_adjustment_lines pal
2699: WHERE pal.batch_name = p_batch_name
2700: AND pal.business_group_id = p_business_group_id

Line 4252: psp_effort_report_templates template

4248: min(begin_date),
4249: max(end_date)
4250: FROM psp_effort_reports report,
4251: psp_adjustment_lines line,
4252: psp_effort_report_templates template
4253: WHERE line.batch_name = p_batch_name
4254: AND report.person_id = line.person_id
4255: AND template.template_id = report.template_id
4256: AND line.distribution_date BETWEEN template.begin_date AND template.end_date

Line 4266: psp_effort_report_templates template

4262: /**** Commented the following for bug fix 2724110
4263: SELECT distinct report.effort_report_id
4264: FROM psp_adjustment_lines line,
4265: psp_effort_reports report,
4266: psp_effort_report_templates template
4267: WHERE line.business_group_id = p_business_group_id
4268: and line.set_of_books_id = p_set_of_books_id
4269: and line.batch_name = p_batch_name
4270: AND line.person_id = report.person_id