APPS.AP_WEB_INACTIVE_EMP_WF_PKG dependencies on AP_EXPENSE_REPORT_HEADERS

Line 508: ap_expense_report_headers erh

504: erh.invoice_num
505: FROM
506: ap_credit_card_trxns cct,
507: ap_cards ac,
508: ap_expense_report_headers erh
509: WHERE
510: cct.card_program_id = p_cardProgramId
511: and cct.validate_code = 'Y'
512: and cct.payment_flag <> 'Y'

Line 1809: ap_expense_report_headers erh

1805: minus
1806: (select cct.trx_id
1807: from ap_cards_all ac,
1808: ap_credit_card_trxns cct,
1809: ap_expense_report_headers erh
1810: where ac.card_program_id = p_credit_card_program_id
1811: and ac.card_program_id = cct.card_program_id
1812: and ac.card_id = cct.card_id
1813: and cct.validate_code = 'Y'

Line 1945: ap_expense_report_headers erh

1941: from ap_credit_card_trxns cct,
1942: ap_cards_all ac,
1943: --ap_card_programs_all cp,
1944: ap_expense_report_lines erl,
1945: ap_expense_report_headers erh
1946: where ac.card_program_id = p_credit_card_program_id
1947: and cct.validate_code = 'Y'
1948: and cct.payment_flag <> 'Y'
1949: and cct.inactive_emp_wf_item_key is not null

Line 2425: from ap_expense_report_headers erh,

2421: p_inact_employee_id in number,
2422: p_itemkey in varchar2)
2423: IS
2424: select erh.source
2425: from ap_expense_report_headers erh,
2426: ap_credit_card_trxns cct,
2427: ap_cards_all ac
2428: where ac.card_program_id = p_credit_card_program_id
2429: and cct.validate_code = 'Y'