APPS.PSP_SUM_TRANS dependencies on PSP_REPORT_TEMPLATES

Line 5266: Psp_report_templates_h pth,

5262: cursor check_er_template_h is
5263: Select distinct pth.template_id,
5264: pth.request_id
5265: From psp_payroll_controls ppc,
5266: Psp_report_templates_h pth,
5267: Per_time_periods ptp
5268: Where ppc.run_id = p_run_id
5269: And ppc.time_period_id = ptp.time_period_id
5270: And fnd_date.canonical_to_date(fnd_date.date_to_canonical(pth.parameter_value_3)) >= ptp.start_date

Line 5276: from psp_report_templates

5272:
5273: cursor supercede_tolerance(p_template_id in integer) is
5274: select nvl(sprcd_tolerance_amt,-999),
5275: nvl(sprcd_tolerance_percent,-999)
5276: from psp_report_templates
5277: where template_id = p_template_id;
5278:
5279:
5280:

Line 5688: from psp_report_templates_h

5684:
5685: -- uva isue, supercede for matching asg option
5686: cursor check_emp_match_option is
5687: select count(*)
5688: from psp_report_templates_h
5689: where request_id in ( select -person_id from psp_supercede_persons_gt )
5690: and selection_match_level = 'EMP';
5691:
5692: l_count_emp_match integer;

Line 5737: from psp_report_templates

5733: l_time_period_name varchar2(100);
5734:
5735: cursor get_template_name is
5736: select template_name
5737: from psp_report_templates
5738: where template_id = p_template_id;
5739:
5740: cursor get_superceding_source is
5741: select description

Line 5755: psp_report_templates_h h,

5751: cursor get_frp_wf_names is
5752: select distinct wf.name,
5753: wf.orig_system_id
5754: from wf_roles wf,
5755: psp_report_templates_h h,
5756: psp_report_template_details_h dtl
5757: where wf.orig_system = 'PER'
5758: and to_char(wf.orig_system_id) = dtl.criteria_value1
5759: and dtl.criteria_lookup_type = 'PSP_SELECTION_CRITERIA'

Line 5771: psp_report_templates_h h

5767: cursor get_init_wf_names is
5768: select distinct wf.name,
5769: wf.orig_system_id
5770: from wf_roles wf,
5771: psp_report_templates_h h
5772: where wf.orig_system = 'PER'
5773: and wf.orig_system_id = h.initiator_person_id
5774: and h.request_id in ( select -person_id
5775: from psp_supercede_persons_gt

Line 5786: psp_report_templates_h h

5782: select distinct wf.name,
5783: er.person_id
5784: from wf_roles wf,
5785: psp_eff_reports er,
5786: psp_report_templates_h h
5787: where wf.orig_system = 'PER'
5788: and wf.orig_system_id = er.person_id
5789: and h.request_id = er.request_id
5790: and h.initiator_accept_flag = 'Y'

Line 5801: psp_report_templates_h h

5797: select distinct era.wf_role_name
5798: from psp_eff_report_approvals era,
5799: psp_eff_report_details erd,
5800: psp_eff_reports er,
5801: psp_report_templates_h h
5802: where erd.effort_report_detail_id = era.effort_report_detail_id
5803: and erd.effort_report_id = er.effort_report_id
5804: and er.request_id in ( select -person_id from psp_supercede_persons_gt where person_id < 0 )
5805: and er.superceding_request_id = p_SandT_reqid