[Home] [Help]
1790: p_cc_billed_end_date in date) is
1791: select 1
1792: from dual
1793: where exists (select cct.trx_id
1794: from ap_cards_all ac,
1795: ap_credit_card_trxns cct
1796: where ac.card_program_id = p_credit_card_program_id
1797: and ac.employee_id = p_inact_employee_id
1798: and ac.card_program_id = cct.card_program_id
1803: and cct.inactive_emp_wf_item_key = p_itemkey
1804: -- group by cct.trx_id
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
1938: select 1
1939: from dual
1940: where exists (select cct.trx_id
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
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'
2430: and cct.inactive_emp_wf_item_key is not null
2431: and cct.inactive_emp_wf_item_key = p_itemkey
2579: p_itemkey in varchar2)
2580: IS
2581: select cct.trx_id
2582: from ap_credit_card_trxns cct,
2583: ap_cards_all ac
2584: where ac.card_program_id = p_credit_card_program_id
2585: and cct.validate_code = 'Y'
2586: and cct.inactive_emp_wf_item_key is not null
2587: and cct.inactive_emp_wf_item_key = p_itemkey