APPS.PSP_CREATE_EFF_REPORTS dependencies on PSP_REPORT_TEMPLATES_H

Line 81: /* insert record in psp_report_templates_h */

77: -- fnd_file.put_line(fnd_file.log, 'start date i s '||g_psp_effort_start);
78: -- fnd_file.put_line(fnd_file.log, 'end date is '||g_psp_effort_end);
79:
80:
81: /* insert record in psp_report_templates_h */
82:
83:
84:
85: END;

Line 225: FROM psp_report_templates_h

221: -- End of bug fix 4182358
222:
223: Cursor HUNDRED_PCENT_EFF_CSR (p_request_id varchar2) is
224: SELECT HUNDRED_PCENT_EFF_AT_PER_ASG, selection_match_level
225: FROM psp_report_templates_h
226: WHERE request_id = p_request_id;
227:
228: l_HUNDRED_PCENT_EFF_AT_PER_ASG varchar2(1);
229: l_proj_segment varchar2(30);

Line 255: Select nvl(max(request_id),p_request_id) into l_request_id from psp_report_templates_h prth where request_id < p_request_id

251:
252: if p_supercede_mode is null then --- supercede
253:
254:
255: Select nvl(max(request_id),p_request_id) into l_request_id from psp_report_templates_h prth where request_id < p_request_id
256: and payroll_action_id = p_pactid;
257:
258:
259: select min(object_id), max(object_id) into l_start_person, l_end_person from pay_temp_object_actions

Line 325: psp_report_templates_h where request_id = l_request_id;

321:
322:
323: -- fnd_file.put_line(fnd_file.log,' retry_Request_id = '||l_retry_request_id );
324: select parameter_value_2, parameter_value_3 into p_effort_start, p_effort_end from
325: psp_report_templates_h where request_id = l_request_id;
326:
327: select criteria_value1 into l_element_set_id from psp_report_template_details_h where
328: criteria_lookup_code='EST' and request_id = l_request_id;
329:

Line 1313: Select max(request_id) into l_old_request_id from psp_report_templates_h prth where request_id < p_request_id and payroll_action_id = p_pact_id;

1309:
1310:
1311: /*
1312:
1313: Select max(request_id) into l_old_request_id from psp_report_templates_h prth where request_id < p_request_id and payroll_action_id = p_pact_id;
1314:
1315:
1316:
1317: -- select request_id into l_retry_request_id from pay_payroll_actions where payroll_action_id = p_pact_id;

Line 1534: FROM psp_report_templates_h prth

1530: AND gl_sum_criteria_segment_name IS NULL;
1531:
1532: CURSOR layout_type_cur IS
1533: SELECT SUBSTR(report_template_code, 6, 3) layout_type
1534: FROM psp_report_templates_h prth
1535: WHERE prth.request_id = p_request_id;
1536:
1537: l_layout_type CHAR(3);
1538: l_award_number VARCHAR2(240);