APPS.AP_WEB_DB_EXPLINE_PKG dependencies on DUAL

Line 640: WHERE aerl.report_header_id in (select p_report_header_id from dual

636: DECODE(aerl.itemization_parent_id,
637: null,AP_WEB_POLICY_UTILS.get_lookup_meaning('OIE_AUDIT_YES_NO','N'),
638: AP_WEB_POLICY_UTILS.get_lookup_meaning('OIE_AUDIT_YES_NO','Y')) itemized_expense_disp
639: FROM ap_expense_report_lines aerl
640: WHERE aerl.report_header_id in (select p_report_header_id from dual
641: union
642: select aerh1.report_header_id
643: from ap_expense_report_headers_all aerh1
644: where aerh1.SHORTPAY_PARENT_ID = p_report_header_id)

Line 2100: FROM DUAL;

2096:
2097: -- Get new ID from sequence
2098: SELECT AP_EXPENSE_REPORT_LINES_S.NEXTVAL
2099: INTO l_NewReportLineID
2100: FROM DUAL;
2101:
2102: InsertCCLine(p_new_report_header_id => p_target_report_header_id,
2103: p_report_line_id => i.report_line_id,
2104: p_itemization_parent_id => p_target_parent_report_line_id,

Line 2143: FROM DUAL;

2139:
2140: -- Get new ID from sequence
2141: SELECT AP_EXPENSE_REPORT_LINES_S.NEXTVAL
2142: INTO l_NewReportLineID
2143: FROM DUAL;
2144:
2145: InsertCCLine(p_new_report_header_id => p_new_report_id,
2146: p_report_line_id => i.report_line_id,
2147: p_itemization_parent_id => i.itemization_parent_id,

Line 2874: FROM DUAL;

2870: l_debug_info := 'start of AddMileageExpLine';
2871:
2872: SELECT AP_EXPENSE_REPORT_LINES_S.NEXTVAL
2873: INTO l_report_line_id
2874: FROM DUAL;
2875:
2876:
2877: INSERT INTO ap_expense_report_lines
2878: (REPORT_HEADER_ID,

Line 3424: FROM DUAL;

3420:
3421: -- Get new ID from sequence
3422: SELECT AP_EXPENSE_REPORT_LINES_S.NEXTVAL
3423: INTO l_NewReportLineID
3424: FROM DUAL;
3425:
3426: -- Bug 6689280 (sodash)
3427: AP_WEB_DB_AP_INT_PKG.GetDefaultExchange( l_exchange_rate_type);
3428:

Line 3820: FROM DUAL;

3816:
3817: -- Get new ID from sequence
3818: SELECT AP_EXPENSE_REPORT_LINES_S.NEXTVAL
3819: INTO l_NewReportLineID
3820: FROM DUAL;
3821:
3822: -- Bug 6689280 (sodash)
3823: AP_WEB_DB_AP_INT_PKG.GetDefaultExchange( l_exchange_rate_type);
3824:

Line 4670: ELSIF (p_payment_due_from = AP_WEB_EXPENSE_WF.C_IndividualPay) THEN

4666: */
4667: p_ccard_amt := l_ccard_amt;
4668: p_total_amt := l_total_amt;
4669:
4670: ELSIF (p_payment_due_from = AP_WEB_EXPENSE_WF.C_IndividualPay) THEN
4671:
4672: /**
4673: * For individual pay the employee is paying for all the expenses and receiving the reimbursement in cash.
4674: * So the amount due to the employee is the total of the expense report, amount due cc issuer is 0.

Line 4673: * For individual pay the employee is paying for all the expenses and receiving the reimbursement in cash.

4669:
4670: ELSIF (p_payment_due_from = AP_WEB_EXPENSE_WF.C_IndividualPay) THEN
4671:
4672: /**
4673: * For individual pay the employee is paying for all the expenses and receiving the reimbursement in cash.
4674: * So the amount due to the employee is the total of the expense report, amount due cc issuer is 0.
4675: */
4676: p_emp_amt := l_total_amt;
4677: p_ccard_amt := 0;