APPS.AP_WEB_UTILITIES_PKG dependencies on AP_EXPENSE_REPORT_LINES_ALL

Line 3506: FROM ap_expense_report_lines_all

3502: last_updated_by = Decode(Nvl(fnd_global.user_id,-1),-1,last_updated_by,fnd_global.user_id)
3503: WHERE report_header_id = to_number(p_report_header_id);
3504: BEGIN
3505: SELECT count(*) INTO l_org_count
3506: FROM ap_expense_report_lines_all
3507: WHERE report_header_id = to_number(p_report_header_id)
3508: AND NVL(receipt_required_flag, 'N') = 'Y';
3509:
3510: IF (l_org_count = 0) THEN

Line 3591: FROM ap_expense_report_lines_all where report_header_id = p_report_header_id

3587:
3588: FUNCTION GetImageAttachmentStatus(p_report_header_id IN NUMBER) RETURN VARCHAR2 IS
3589:
3590: CURSOR line_cursor IS select report_line_id, NVL(image_receipt_required_flag,'N') image_receipt_required_flag
3591: FROM ap_expense_report_lines_all where report_header_id = p_report_header_id
3592: AND (itemization_parent_id is null or itemization_parent_id = -1);
3593:
3594: line_rec line_cursor%ROWTYPE;
3595: l_header_attach VARCHAR2(2);

Line 3780: from ap_expense_report_lines_all aerl

3776: l_non_cc_line_count NUMBER;
3777: BEGIN
3778:
3779: select count(1) INTO l_non_cc_line_count
3780: from ap_expense_report_lines_all aerl
3781: where aerl.report_header_id = p_report_header_id
3782: and ( CREDIT_CARD_TRX_ID is null
3783: OR ( CREDIT_CARD_TRX_ID is not null
3784: AND (NVL(receipt_required_flag,'N') = 'Y' OR NVL(image_receipt_required_flag,'N') = 'Y')

Line 3806: from ap_expense_report_lines_all aerl

3802: l_rr_line_count NUMBER;
3803: BEGIN
3804:
3805: select count(1) INTO l_non_pdm_line_count
3806: from ap_expense_report_lines_all aerl
3807: where aerl.report_header_id = p_report_header_id
3808: and NVL(aerl.category_code,'NONE') not in ('PER_DIEM','MILEAGE');
3809:
3810: IF (l_non_pdm_line_count = 0) THEN

Line 3815: from ap_expense_report_lines_all aerl

3811: RETURN TRUE;
3812: ELSE
3813:
3814: select count(1) INTO l_rr_line_count
3815: from ap_expense_report_lines_all aerl
3816: where aerl.report_header_id = p_report_header_id
3817: and (nvl(aerl.receipt_required_flag, 'N') = 'Y' OR nvl(aerl.image_receipt_required_flag, 'N') = 'Y');
3818:
3819: IF (l_rr_line_count = 0) THEN