[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
th_select varchar2(200) := '';
Line: 50
td_select varchar2(200) := '';
Line: 75
SELECT to_char(ap_cCard_Notification_ID_s.nextval)
INTO l_itemKey
FROM sys.dual;
Line: 162
SELECT aerh2.invoice_num
INTO l_invoiceNum
FROM ap_expense_report_headers_all aerh1,
ap_expense_report_headers_all aerh2
WHERE aerh1.bothpay_parent_id = aerh2.report_header_id
AND aerh1.invoice_num = p_invoiceNumber
AND aerh1.source = 'Both Pay';
Line: 1782
select displayed_field
into l_displayed_status
from ap_lookup_codes
where lookup_type = AP_WEB_OA_ACTIVE_PKG.C_EXPENSE_REPORT_STATUS
and lookup_code = l_expense_report_status;
Line: 2062
select displayed_field
into l_displayed_status
from ap_lookup_codes
where lookup_type = AP_WEB_OA_ACTIVE_PKG.C_EXPENSE_REPORT_STATUS
and lookup_code = l_expense_report_status;
Line: 3052
SELECT emp.employee_id,emp.full_name
FROM per_employees_x emp
WHERE emp.supervisor_id = p_supervisor_id
AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y';
Line: 3192
SELECT employee_id,supervisor_id,level-1
FROM per_employees_x emp
WHERE NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'
CONNECT BY prior employee_id = supervisor_id
and level < 6
START WITH employee_id = p_supervisor_id order by 2;
Line: 3202
SELECT P.PERSON_ID, H.SUPERVISOR_ID, H.LVL
FROM PER_PEOPLE_F P,
( SELECT UNIQUE ass.PERSON_ID,ass.SUPERVISOR_ID, LEVEL -1 LVL
FROM PER_ALL_ASSIGNMENTS_F ASS,
PER_PERIODS_OF_SERVICE B2
WHERE ASS.PRIMARY_FLAG = 'Y' AND ASS.ASSIGNMENT_TYPE = 'E' AND
B2.period_of_service_id = Ass.period_of_service_id AND
B2.DATE_START <= TRUNC(SYSDATE) AND
greatest( NVL(B2.ACTUAL_TERMINATION_DATE, TRUNC(SYSDATE) ) ) between Ass.EFFECTIVE_START_DATE and Ass.EFFECTIVE_END_DATE
AND LEVEL <= ( p_level_id + 1 )
CONNECT BY
PRIOR ass.PERSON_ID = SUPERVISOR_ID AND
level <= (p_level_id + 1) and
greatest( NVL(B2.ACTUAL_TERMINATION_DATE, TRUNC(SYSDATE) ) ) between Ass.EFFECTIVE_START_DATE and Ass.EFFECTIVE_END_DATE
START WITH ass.pERSON_ID = p_supervisor_id
) H
WHERE H.PERSON_ID = P.PERSON_ID AND
TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE AND P.EFFECTIVE_END_DATE AND
NOT Ap_Web_Db_Hr_Int_Pkg.ispersoncwk(P.PERSON_ID)='Y' AND
P.EMPLOYEE_NUMBER IS NOT NULL
ORDER BY 2;
Line: 3228
SELECT P.PERSON_ID, H.SUPERVISOR_ID, H.LVL
FROM PER_PEOPLE_F P,
( SELECT UNIQUE ass.PERSON_ID,ass.SUPERVISOR_ID, LEVEL -1 LVL
FROM PER_ALL_ASSIGNMENTS_F ASS,
PER_PERIODS_OF_SERVICE B2
WHERE ASS.PRIMARY_FLAG = 'Y' AND ASS.ASSIGNMENT_TYPE = 'E' AND
B2.period_of_service_id = Ass.period_of_service_id AND
B2.DATE_START <= TRUNC(SYSDATE) AND
greatest( NVL(B2.ACTUAL_TERMINATION_DATE, TRUNC(SYSDATE) ) ) between Ass.EFFECTIVE_START_DATE and Ass.EFFECTIVE_END_DATE
CONNECT BY
PRIOR ass.PERSON_ID = SUPERVISOR_ID AND
level < 6 and
greatest( NVL(B2.ACTUAL_TERMINATION_DATE, TRUNC(SYSDATE) ) ) between Ass.EFFECTIVE_START_DATE and Ass.EFFECTIVE_END_DATE
START WITH ass.pERSON_ID = p_supervisor_id
) H
WHERE H.PERSON_ID = P.PERSON_ID AND
TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE AND P.EFFECTIVE_END_DATE AND
NOT Ap_Web_Db_Hr_Int_Pkg.ispersoncwk(P.PERSON_ID)='Y' AND
P.EMPLOYEE_NUMBER IS NOT NULL
ORDER BY 2;
Line: 3565
DELETE FROM ap_ccard_esc_next_gt;
Line: 3614
INSERT INTO ap_ccard_esc_next_gt
(aging_manager_id,
employee_display_name,
supervisor_display_name,
direct_report_name,
total_num_outstanding,
total_dispute,
total_amt_outstanding,
total_amount )
VALUES (l_final_manager_id,
l_employee_display_name,
l_supervisor_display_name,
l_direct_report_name,
l_total_num_outstanding,
l_total_dispute,
l_total_amt_outstanding,
l_total_amount
);
Line: 3742
DELETE FROM ap_ccard_esc_next_gt;
Line: 3784
INSERT INTO ap_ccard_esc_next_gt
(
aging_manager_id,
employee_display_name,
total_num_outstanding,
total_dispute,
total_amt_outstanding,
total_amount
)
VALUES (
l_supervisor_id,
l_employee_name,
l_total_num_outstanding,
l_total_dispute,
l_total_amt_outstanding,
l_total_amount
);
Line: 3955
select org_id into l_org_id
from ap_card_programs_all
where card_program_id = l_card_prog_id;