[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT porh.preparer_id,
'REQUISITION',
porh.type_lookup_code,
podt.forwarding_mode_code,
nvl(podt.default_approval_path_id,0),
nvl(can_preparer_approve_flag,'N')
INTO p_req_info
FROM po_requisition_headers porh,
po_document_types podt
WHERE porh.requisition_header_id = p_requisition_header_id
AND podt.document_type_code = 'REQUISITION'
AND podt.document_subtype = porh.type_lookup_code;
SELECT nvl(poac.employee_id,porh.preparer_id)
INTO l_employee_id
FROM po_action_history poac,
po_requisition_headers porh
WHERE porh.requisition_header_id = p_requisition_header_id
AND porh.requisition_header_id = poac.object_id(+)
AND poac.object_type_code(+) = 'REQUISITION'
AND poac.action_code is null;
SELECT poeh.superior_id forward_to_id
FROM hr_employees_current_v hrec,
po_employee_hierarchies poeh
WHERE poeh.position_structure_id = b_approval_path_id
AND poeh.employee_id = b_employee_id
AND hrec.employee_id = poeh.superior_id
AND poeh.superior_level > 0
ORDER
BY poeh.superior_level, hrec.full_name;
SELECT pera.supervisor_id forward_to_id
FROM per_assignments_f pera
WHERE pera.business_group_id = fsp.business_group_id
AND TRUNC(sysdate) BETWEEN pera.effective_start_date
AND pera.effective_end_date
CONNECT
BY pera.person_id = prior pera.supervisor_id
START
WITH pera.person_id = b_employee_id;
SELECT poeh.superior_id
FROM po_employee_hierarchies poeh,
hr_employees_current_v hremp
WHERE poeh.employee_id = b_employee_id
AND poeh.position_structure_id = b_approval_path_id
AND poeh.superior_level = 1
AND hremp.employee_id = poeh.superior_id
ORDER
BY hremp.full_name;
SELECT hremp.supervisor_id
FROM hr_employees_current_v hremp
WHERE hremp.employee_id = b_employee_id;
SELECT pocf.control_function_id
INTO l_control_function_id
FROM po_control_functions pocf
WHERE pocf.document_type_code = 'REQUISITION'
AND pocf.document_subtype = l_reqinfo.sub_type
AND pocf.action_type_code = 'APPROVE'
AND pocf.enabled_flag = 'Y';
SELECT nvl(PAF.position_id,0)
INTO l_position_id
FROM per_assignments_f paf
WHERE paf.person_id = p_employee_id
AND paf.assignment_type = 'E'
AND paf.primary_flag = 'Y'
AND sysdate BETWEEN paf.effective_start_date AND paf.effective_end_date;
SELECT Min(pocr.amount_limit)
INTO l_doc_approval_limit
FROM po_control_rules pocr,
po_control_groups pocg,
po_position_controls popc
WHERE popc.position_id = l_position_id
AND sysdate BETWEEN NVL(popc.start_date, sysdate - 1 )
AND NVL(popc.end_date,sysdate + 1 )
AND popc.control_function_id = l_control_function_id
AND pocg.enabled_flag = 'Y'
AND pocg.control_group_id = popc.control_group_id
AND pocr.control_group_id = pocg.control_group_id
AND pocr.object_code = 'DOCUMENT_TOTAL'
AND NVL(pocr.inactive_date, sysdate+1) > sysdate;
SELECT nvl(paf.job_id, 0)
INTO l_job_id
FROM per_assignments_f PAF
WHERE paf.person_id = p_employee_id
AND paf.assignment_type = 'E'
AND paf.primary_flag = 'Y'
AND sysdate BETWEEN paf.effective_start_date AND paf.effective_end_date;
SELECT Min(pocr.amount_limit)
INTO l_doc_approval_limit
FROM po_control_rules pocr,
po_control_groups pocg,
po_position_controls popc
WHERE popc.job_id = l_job_id
AND sysdate BETWEEN NVL(popc.start_date, sysdate - 1 )
AND NVL(popc.end_date,sysdate + 1 )
AND popc.control_function_id = l_control_function_id
AND pocg.enabled_flag = 'Y'
AND pocg.control_group_id = popc.control_group_id
AND pocr.control_group_id = pocg.control_group_id
AND pocr.object_code = 'DOCUMENT_TOTAL'
AND NVL(pocr.inactive_date, sysdate+1) > sysdate;
select *
into fsp
from financials_system_parameters;
select currency_code
into poreq.functional_currency
from gl_sets_of_books
where set_of_books_id = fsp.set_of_books_id;