[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
VEND.employee_id VENDOR_EMPLOYEE_ID,
EMP.employee_number VENDOR_EMPLOYEE_NUMBER,
VEND.vendor_type_lookup_code VENDOR_TYPE
INTO
x_vendor_employee_id,
x_vendor_employee_number,
x_vendor_type
FROM
po_vendors VEND,
per_people_f EMP
WHERE
VEND.vendor_id = p_vendor_id
AND VEND.employee_id = EMP.person_id (+)
AND l_person_effective_date
between EMP.effective_start_date(+)
and nvl(EMP.effective_end_date(+),sysdate); */
SELECT
VEND.employee_id VENDOR_EMPLOYEE_ID,
VEND.vendor_type_lookup_code VENDOR_TYPE
INTO
x_vendor_employee_id,
x_vendor_type
FROM
po_vendors VEND
WHERE
VEND.vendor_id = p_vendor_id;
SELECT
EMP.employee_number VENDOR_EMPLOYEE_NUMBER
INTO
x_vendor_employee_number
FROM
per_people_f EMP
WHERE x_vendor_employee_id = EMP.person_id
AND l_person_effective_date between EMP.effective_start_date
and NVL (EMP.effective_end_date, sysdate);
SELECT
VEND.vendor_type_lookup_code VENDOR_TYPE
INTO
x_vendor_type
FROM
po_vendors VEND
WHERE
VEND.vendor_id = p_vendor_id ;
/* SELECT
EMP.employee_num, EMP.default_code_combination_id
INTO
x_employee_number, l_employee_ccid
FROM
hr_employees_current_v EMP
WHERE
EMP.employee_id = p_employee_id; */
SELECT DECODE(p.current_npw_flag,'Y',p.npw_number, p.employee_number) employee_number, a.default_code_comb_id,
DECODE(p.current_npw_flag,'Y','CWK','EMP') person_type
INTO x_employee_number, l_employee_ccid, x_person_type
FROM per_people_f p,
per_assignments_f a,
per_assignment_status_types past
WHERE p.person_id = p_employee_id
AND p.business_group_id + 0 = (SELECT nvl(max(fsp.business_group_id),0)
FROM financials_system_parameters fsp)
AND a.person_id = p.person_id
AND a.primary_flag = 'Y'
AND TRUNC(l_person_effective_date) BETWEEN p.effective_start_date and p.effective_end_date
AND TRUNC(l_person_effective_date) BETWEEN a.effective_start_date and a.effective_end_date
AND ((p.current_employee_flag = 'Y')
OR (p.current_npw_flag = 'Y') )
AND a.assignment_type in ('E','C')
AND a.assignment_status_type_id = past.assignment_status_type_id
AND past.per_system_status IN ('ACTIVE_ASSIGN','SUSP_ASSIGN','ACTIVE_CWK');
SELECT
PTYPE.direct_flag DIRECT_FLAG,
PROJ.segment1 PROJECT_NUMBER,
ORG.Name PROJECT_ORGANIZATION_NAME,
ORG.Organization_ID PROJECT_ORGANIZATION_ID,
PROJ.project_type PROJECT_TYPE,
PROJ.public_sector_flag PUBLIC_SECTOR_FLAG
INTO
x_direct_flag,
x_project_number,
x_project_organization_name,
x_project_organization_id,
x_project_type,
x_public_sector_flag
FROM
HR_Organization_Units ORG,
PA_Project_Types_all PTYPE,
PA_Projects_all PROJ
WHERE
PROJ.project_id = p_project_id
AND ORG.organization_id = PROJ.carrying_out_organization_id
AND nvl(PTYPE.org_id,-99) = nvl(PROJ.org_id,-99)
AND PTYPE.Project_Type = PROJ.Project_Type;
SELECT
ETYPE.Expenditure_Category EXPENDITURE_CATEGORY,
ETYPE.revenue_category_code REVENUE_CATEGORY
INTO
x_expenditure_category,
x_revenue_category
FROM
PA_Expenditure_Types ETYPE
WHERE
ETYPE.expenditure_type = p_expenditure_type;
SELECT a.class_code
INTO x_class_code
FROM pa_project_classes a,
pa_class_categories b
WHERE a.project_id = p_project_id
AND a.class_category = b.class_category
AND b.autoaccounting_flag = 'Y'
AND sysdate BETWEEN b.start_date_active
AND nvl(b.end_date_active, sysdate);
SELECT ORG.name EXP_ORG_NAME
INTO x_expenditure_org_name
FROM hr_organization_units ORG
WHERE ORG.organization_id = p_expenditure_organization_id;
SELECT
TASK.task_number TASK_NUMBER,
ORG.Name TASK_ORGANIZATION_NAME,
ORG.Organization_id TASK_ORGANIZATION_ID,
TASK.Service_Type_Code TASK_SERVICE_TYPE,
TOP_TASK.Task_ID TOP_TASK_ID,
TOP_TASK.Task_Number TOP_TASK_NUMBER
INTO
x_task_number,
x_task_organization_name,
x_task_organization_id,
x_task_service_type,
x_top_task_id,
x_top_task_number
FROM
HR_Organization_Units ORG,
PA_Tasks TOP_TASK,
PA_Tasks TASK
WHERE
TASK.task_id = p_task_id
AND ORG.organization_id = TASK.carrying_out_organization_id
AND TASK.Top_Task_ID = TOP_TASK.Task_ID;
SELECT org_id
INTO l_org_id
FROM PA_IMPLEMENTATIONS;
SELECT org_id
INTO l_org_id
FROM PA_IMPLEMENTATIONS;
SELECT segment_value
INTO l_segment_value
FROM pa_segment_value_lookups valuex,
pa_segment_value_lookup_sets sets
WHERE sets.segment_value_lookup_set_id =
valuex.segment_value_lookup_set_id
AND sets.segment_value_lookup_set_name = l_seg_value_lookup_set_name
AND valuex.segment_value_lookup = l_intermediate_value;
Select function_transaction_code ft_code,
decode(function_transaction_code,'ALL',10,'CON',9,'CAP',8,'IND',7,5) ft_order
from pa_function_transactions
where function_transaction_code in
('ALL',p_ft_code,p_ptype_ft_code)
and application_id = 275
and function_code = 'BER'
and enabled_flag = 'Y'
order by 2;
select a.project_type_class_code
into l_ptype_class_code
from pa_project_types_all a,
pa_projects_all b
where a.project_type = b.project_type
and nvl(a.org_id,-99) = nvl(b.org_id, -99)
and b.project_id = l_project_id;
g_error_stack_history.DELETE(g_error_stack_history.LAST);