APPS.PSP_ADJ_DRIVER dependencies on PSP_EFFORT_REPORT_TEMPLATES

Line 2616: from psp_effort_report_templates pert

2612: where per.person_id = p_per_id
2613: and per.business_group_id = p_business_group_id
2614: and per.set_of_books_id = p_set_of_books_id
2615: and per.template_id in (select pert.template_id
2616: from psp_effort_report_templates pert
2617: where pert.report_type = 'N'
2618: -- and pert.person_id = p_per_id
2619: and pert.business_group_id = p_business_group_id
2620: and pert.set_of_books_id = p_set_of_books_id);

Line 2624: from psp_effort_report_templates

2620: and pert.set_of_books_id = p_set_of_books_id);
2621:
2622: cursor effort_templates_c(p_template_id IN NUMBER) is
2623: select begin_date, end_date
2624: from psp_effort_report_templates
2625: where template_id = p_template_id and
2626: report_type='N'
2627: and business_group_id = p_business_group_id
2628: and set_of_books_id = p_set_of_books_id;

Line 2635: FROM psp_effort_report_templates pert

2631: / * Following cursor is modified for bug 2252881 * /
2632: CURSOR effort_reports_c(p_per_id NUMBER)
2633: IS
2634: SELECT pert.template_id, pert.begin_date, pert.end_date
2635: FROM psp_effort_report_templates pert
2636: WHERE pert.report_type ='N'
2637: AND pert.template_id IN(
2638: SELECT per.template_id
2639: FROM psp_effort_reports per

Line 2705: FROM psp_effort_report_templates pert,

2701: AND per.business_group_id = p_business_group_id
2702: AND per.set_of_books_id = p_set_of_books_id
2703: AND (per.person_id, per.template_id) IN
2704: (SELECT pal.person_id, pert.template_id
2705: FROM psp_effort_report_templates pert,
2706: psp_effort_reports per2,
2707: psp_adjustment_lines pal
2708: WHERE pal.batch_name = p_batch_name
2709: AND pal.business_group_id = p_business_group_id

Line 4261: psp_effort_report_templates template

4257: min(begin_date),
4258: max(end_date)
4259: FROM psp_effort_reports report,
4260: psp_adjustment_lines line,
4261: psp_effort_report_templates template
4262: WHERE line.batch_name = p_batch_name
4263: AND report.person_id = line.person_id
4264: AND template.template_id = report.template_id
4265: AND line.distribution_date BETWEEN template.begin_date AND template.end_date

Line 4275: psp_effort_report_templates template

4271: /**** Commented the following for bug fix 2724110
4272: SELECT distinct report.effort_report_id
4273: FROM psp_adjustment_lines line,
4274: psp_effort_reports report,
4275: psp_effort_report_templates template
4276: WHERE line.business_group_id = p_business_group_id
4277: and line.set_of_books_id = p_set_of_books_id
4278: and line.batch_name = p_batch_name
4279: AND line.person_id = report.person_id