DBA Data[Home] [Help]

APPS.AP_WEB_HOLDS_WF dependencies on AP_EXPENSE_REPORT_LINES

Line 1825: from ap_expense_report_lines aerl

1821: where aerh.report_header_id = p_report_header_id
1822: and
1823: exists
1824: (select 1
1825: from ap_expense_report_lines aerl
1826: where aerl.report_header_id = aerh.report_header_id
1827: and aerl.credit_card_trx_id is not null
1828: and nvl(aerl.receipt_required_flag, 'N') = 'Y'
1829: and rownum = 1

Line 1878: from ap_expense_report_lines aerl

1874: where aerh.report_header_id = p_report_header_id
1875: and
1876: exists
1877: (select 1
1878: from ap_expense_report_lines aerl
1879: where aerl.report_header_id = aerh.report_header_id
1880: and aerl.credit_card_trx_id is not null
1881: and nvl(aerl.image_receipt_required_flag, 'N') = 'Y'
1882: and rownum = 1

Line 2250: from ap_expense_report_lines aerl

2246: and aerh.bothpay_parent_id is null
2247: and
2248: not exists
2249: (select 1
2250: from ap_expense_report_lines aerl
2251: where aerl.report_header_id = aerh.report_header_id
2252: and aerl.credit_card_trx_id IS NULL
2253: and rownum = 1)
2254: and