APPS.AP_WEB_DB_CCARD_PKG dependencies on AP_EXPENSE_REPORT_LINES

Line 15: AP_EXPENSE_REPORT_LINES AERL

11: BEGIN
12: OPEN p_category FOR
13: SELECT ACCT.CATEGORY
14: FROM AP_CREDIT_CARD_TRXNS ACCT,
15: AP_EXPENSE_REPORT_LINES AERL
16: WHERE AERL.REPORT_HEADER_ID = P_ReportHeaderID
17: AND ACCT.TRX_ID = AERL.CREDIT_CARD_TRX_ID;
18:
19: RETURN TRUE;

Line 239: -- 3130923 remove ap_expense_report_lines from the 1st select

235: p_unsubmitted_cursor OUT NOCOPY UnsubmittedCCTrxnCursor
236: ) RETURN BOOLEAN IS
237: ---------------------------------------------------------------------------
238: BEGIN
239: -- 3130923 remove ap_expense_report_lines from the 1st select
240: -- join erh.report_header_id = cct.report_header_id
241: OPEN p_unsubmitted_cursor FOR
242: SELECT distinct transaction_date,
243: merchant_name1,

Line 364: -- 3130923 remove ap_expense_report_lines from the 1st select

360: p_total_cursor OUT NOCOPY UnsubmittedCCTrxnCursor
361: ) RETURN BOOLEAN IS
362: ---------------------------------------------------------------------------
363: BEGIN
364: -- 3130923 remove ap_expense_report_lines from the 1st select
365: -- join erh.report_header_id = cct.report_header_id
366: OPEN p_total_cursor FOR
367: SELECT distinct transaction_date,
368: merchant_name1,

Line 765: p_prepaid_invoice_id OUT NOCOPY AP_EXPENSE_REPORT_LINES.company_prepaid_invoice_id%TYPE)

761:
762: -------------------------------------------------------------------
763: FUNCTION GetCompPrepaidInvID(
764: p_trx_id IN ccTrxn_trxID,
765: p_prepaid_invoice_id OUT NOCOPY AP_EXPENSE_REPORT_LINES.company_prepaid_invoice_id%TYPE)
766: RETURN BOOLEAN IS
767: -------------------------------------------------------------------
768: BEGIN
769: p_prepaid_invoice_id := NULL;

Line 1039: FROM ap_expense_report_lines

1035: BEGIN
1036: UPDATE ap_credit_card_trxns
1037: SET report_header_id = p_new_expense_report_id
1038: WHERE trx_id IN (SELECT credit_card_trx_id
1039: FROM ap_expense_report_lines
1040: WHERE report_header_id = p_new_expense_report_id
1041: AND nvl(policy_shortpay_flag,'N') = 'Y');
1042:
1043: RETURN TRUE;

Line 1066: FROM ap_expense_report_lines

1062: BEGIN
1063: UPDATE ap_credit_card_trxns
1064: SET report_header_id = p_new_expense_report_id
1065: WHERE trx_id IN (SELECT credit_card_trx_id
1066: FROM ap_expense_report_lines
1067: WHERE report_header_id = p_new_expense_report_id
1068: AND receipt_required_flag = 'Y'
1069: AND nvl(receipt_verified_flag,'N') = 'N'
1070: AND nvl(policy_shortpay_flag, 'N') = 'N');