APPS.AP_WEB_MANAGEMENT_REPORTS_PKG dependencies on AP_LOOKUP_CODES

Line 331: most_violated_policy ap_lookup_codes.DISPLAYED_FIELD%TYPE,

327: violation_line_amount NUMBER,
328: violation_amount NUMBER,
329: percent_violation NUMBER,
330: number_of_violations NUMBER,
331: most_violated_policy ap_lookup_codes.DISPLAYED_FIELD%TYPE,
332: supervisor_id per_workforce_x.SUPERVISOR_ID%TYPE,
333: effective_start_date DATE, -- 4319234 the two date columns are added to the record
334: effective_end_date DATE
335: );

Line 506: FROM ap_lookup_codes alc,

502: from
503: (
504: SELECT 1 as number_of_violations,
505: alc.displayed_field as violation_type
506: FROM ap_lookup_codes alc,
507: ap_expense_report_violations_v aerv
508: WHERE alc.lookup_type = 'OIE_POL_VIOLATION_TYPES'
509: AND alc.lookup_code = aerv.violation_type
510: AND ( aerv.employee_id = P_EmployeeId OR aerv.paid_on_behalf_employee_id = P_EmployeeId)

Line 520: ap_lookup_codes alc

516: SELECT 1 as number_of_violations,
517: alc.displayed_field as violation_type
518: FROM ap_expense_report_headers_all aerh,
519: ap_pol_violations_all apv,
520: ap_lookup_codes alc
521: WHERE aerh.report_header_id = apv.report_header_id
522: AND apv.distribution_line_number = -1
523: AND (aerh.source <> 'NonValidatedWebExpense' OR aerh.workflow_approved_flag IS NULL)
524: AND aerh.source <> 'Both Pay'

Line 542: FROM ap_lookup_codes alc,

538: UNION ALL
539: /* Count all the violations for Receipts missing */
540: SELECT 1 as number_of_violations,
541: alc.displayed_field as violation_type
542: FROM ap_lookup_codes alc,
543: ap_expense_report_violations_v aerv
544: WHERE alc.lookup_type = 'OIE_POL_VIOLATION_TYPES'
545: AND alc.lookup_code = aerv.violation_type
546: AND ( aerv.employee_id = P_EmployeeId OR aerv.paid_on_behalf_employee_id = P_EmployeeId)

Line 881: expense_category ap_lookup_codes.LOOKUP_CODE%TYPE,

877: allowable_amount NUMBER,
878: percent_violation NUMBER,
879: percent_allowable NUMBER,
880: number_of_violations NUMBER,
881: expense_category ap_lookup_codes.LOOKUP_CODE%TYPE,
882: expense_category_desc ap_lookup_codes.DISPLAYED_FIELD%TYPE
883: );
884:
885:

Line 882: expense_category_desc ap_lookup_codes.DISPLAYED_FIELD%TYPE

878: percent_violation NUMBER,
879: percent_allowable NUMBER,
880: number_of_violations NUMBER,
881: expense_category ap_lookup_codes.LOOKUP_CODE%TYPE,
882: expense_category_desc ap_lookup_codes.DISPLAYED_FIELD%TYPE
883: );
884:
885:
886: TYPE ByExpenseCategoryTabType IS TABLE OF ByExpenseCategoryRecType

Line 896: L_ExpenseCategory ap_lookup_codes.LOOKUP_CODE%TYPE;

892: L_TabIndex BINARY_INTEGER := 0;
893: L_EmployeeId ap_expense_report_headers.EMPLOYEE_ID%TYPE;
894: L_BaseCurrencyCode ap_system_parameters.BASE_CURRENCY_CODE%TYPE;
895: L_ExchangeRateType ap_system_parameters.DEFAULT_EXCHANGE_RATE_TYPE%TYPE;
896: L_ExpenseCategory ap_lookup_codes.LOOKUP_CODE%TYPE;
897: L_ExpenseAmount NUMBER := 0;
898: L_ViolationLineAmount NUMBER;
899: L_ViolationAmount NUMBER;
900: L_AllowableAmount NUMBER;

Line 917: FROM ap_lookup_codes

913: --
914: CURSOR C_ExpenseCategories ( P_ExpenseCategory VARCHAR2 )IS
915: SELECT lookup_code,
916: displayed_field
917: FROM ap_lookup_codes
918: WHERE lookup_type = 'OIE_EXPENSE_CATEGORY'
919: AND lookup_code = decode (P_ExpenseCategory, 'ALL', lookup_code, P_ExpenseCategory);
920:
921: --

Line 1452: violation_type ap_lookup_codes.LOOKUP_CODE%TYPE,

1448: allowable_amount NUMBER,
1449: percent_violation NUMBER,
1450: percent_allowable NUMBER,
1451: number_of_violations NUMBER,
1452: violation_type ap_lookup_codes.LOOKUP_CODE%TYPE,
1453: violation_type_desc ap_lookup_codes.DISPLAYED_FIELD%TYPE
1454: );
1455:
1456:

Line 1453: violation_type_desc ap_lookup_codes.DISPLAYED_FIELD%TYPE

1449: percent_violation NUMBER,
1450: percent_allowable NUMBER,
1451: number_of_violations NUMBER,
1452: violation_type ap_lookup_codes.LOOKUP_CODE%TYPE,
1453: violation_type_desc ap_lookup_codes.DISPLAYED_FIELD%TYPE
1454: );
1455:
1456:
1457: TYPE ByViolationTypeTabType IS TABLE OF ByViolationTypeRecType

Line 1467: L_ViolationType ap_lookup_codes.LOOKUP_CODE%TYPE;

1463: L_TabIndex BINARY_INTEGER := 0;
1464: L_EmployeeId ap_expense_report_headers.EMPLOYEE_ID%TYPE;
1465: L_BaseCurrencyCode ap_system_parameters.BASE_CURRENCY_CODE%TYPE;
1466: L_ExchangeRateType ap_system_parameters.DEFAULT_EXCHANGE_RATE_TYPE%TYPE;
1467: L_ViolationType ap_lookup_codes.LOOKUP_CODE%TYPE;
1468: L_ViolationLineAmount NUMBER;
1469: L_ViolationAmount NUMBER;
1470: L_AllowableAmount NUMBER;
1471: L_Convert BOOLEAN := FALSE;

Line 1487: FROM ap_lookup_codes

1483: --
1484: CURSOR C_ViolationTypes ( P_ViolationType VARCHAR2 )IS
1485: SELECT lookup_code,
1486: displayed_field
1487: FROM ap_lookup_codes
1488: WHERE lookup_type = 'OIE_POL_VIOLATION_TYPES'
1489: AND lookup_code = decode (P_ViolationType, 'ALL', lookup_code, P_ViolationType);
1490:
1491: --