APPS.PSP_XMLGEN dependencies on PSP_LAYOUT_OPTIONS

Line 155: psp_layout_options plo

151: FROM psp_report_template_details_h prtdh,
152: psp_report_templates_h prth,
153: fnd_lookup_values flv1,
154: fnd_lookup_values flv2,
155: psp_layout_options plo
156: WHERE prtdh.request_id = p_request_id
157: AND prth.request_id = p_request_id
158: AND plo.report_template_code = prth.report_template_code
159: AND flv1.lookup_code = prtdh.criteria_lookup_code

Line 177: psp_layout_options plo

173: FROM psp_report_template_details_h prtdh,
174: psp_report_templates_h prth,
175: fnd_lookup_values flv1,
176: fnd_lookup_values flv2,
177: psp_layout_options plo
178: WHERE prth.request_id = p_request_id
179: AND prtdh.request_id = p_request_id
180: AND plo.report_template_code = prth.report_template_code
181: AND flv1.lookup_code = prtdh.criteria_lookup_code

Line 589: psp_layout_options plo

585: plo.value1 || ' ' || DECODE(prtd.criteria_value2, 'A', 'ASC', 'DESC') sort_option
586: FROM psp_report_template_details prtd,
587: fnd_lookup_values flv1,
588: fnd_lookup_values flv2,
589: psp_layout_options plo
590: WHERE prtd.template_id = p_template_id
591: AND flv1.lookup_code = prtd.criteria_lookup_code
592: AND flv1.lookup_type = 'PSP_SORTING_CRITERIA'
593: AND prtd.criteria_lookup_type = 'PSP_SORTING_CRITERIA'

Line 607: ,psp_layout_options plo

603: decode (substr(prtdh.CRITERIA_LOOKUP_CODE,1,7),'SEGMENT','GL_'||prtdh.CRITERIA_LOOKUP_CODE,plo.VALUE1)
604: || ' ' || DECODE(criteria_value2, 'A', 'ASC', 'DESC') --decode plo.VALUE1
605: from psp_report_template_details_h prtdh ,
606: psp_report_templates_h prth
607: ,psp_layout_options plo
608: where prth.request_id= p_request_id-- 125338 --125188
609: and prth.request_id = prtdh.request_id
610: and prtdh.CRITERIA_LOOKUP_TYPE ='PSP_SORTING_CRITERIA'
611: and prtdh.CRITERIA_LOOKUP_TYPE = plo.LAYOUT_LOOKUP_TYPE

Line 639: psp_layout_options plo

635: /* Added for Hospital effort report */
636: CURSOR grouping_category_csr(p_assignment_id IN NUMBER) IS
637: SELECT distinct perd.grouping_category, plo.layout_option_order
638: FROM psp_eff_report_details perd,
639: psp_layout_options plo
640: WHERE effort_report_id = p_effort_report_id
641: AND NVL(assignment_id,-1) = NVL(p_assignment_id,-1)
642: AND plo.layout_lookup_type ='PSP_EFFORT_CATEGORY'
643: AND plo.LAYOUT_LOOKUP_CODE = perd.grouping_category

Line 815: || 'psp_layout_options plo, fnd_lookup_values_vl lookup, psp_report_templates_h prth '

811: || 'TRIM(TO_CHAR(SUM(NVL(pera.actual_cost_share, 0)), ''999G990D00'')) total_actual_cost_share, '
812: || 'TRIM(MAX(lookup.lookup_code)) category_code, '
813: || 'TRIM(MAX(lookup.meaning)) category_desc '
814: || 'FROM psp_eff_report_details perd, psp_eff_report_approvals pera, '
815: || 'psp_layout_options plo, fnd_lookup_values_vl lookup, psp_report_templates_h prth '
816: || 'WHERE perd.grouping_category = plo.layout_lookup_code '
817: || 'AND plo.layout_lookup_code = lookup.lookup_code '
818: || 'AND plo.layout_lookup_type =''PSP_EFFORT_CATEGORY'' '
819: || 'AND lookup.lookup_type = ''PSP_EFFORT_CATEGORY'' '

Line 1703: FROM psp_layout_options

1699: l_project_manager_role VARCHAR2(30);
1700:
1701: CURSOR project_manager_role_cur IS
1702: SELECT layout_lookup_code
1703: FROM psp_layout_options
1704: WHERE report_template_code = TRIM(l_report_template_code)
1705: AND layout_lookup_type = 'PSP_PROJECT_MANAGER_ROLE';
1706:
1707: