APPS.AP_WEB_INACTIVE_EMP_WF_PKG dependencies on AP_CREDIT_CARD_TRXNS

Line 483: ap_credit_card_trxns cct,

479: billed_amount,
480: billed_currency_code,
481: null invoice_num
482: FROM
483: ap_credit_card_trxns cct,
484: ap_cards ac
485: WHERE cct.card_program_id = p_cardProgramId
486: and cct.validate_code = 'Y'
487: and cct.payment_flag <> 'Y'

Line 506: ap_credit_card_trxns cct,

502: billed_amount,
503: billed_currency_code,
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

Line 1795: ap_credit_card_trxns cct

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
1799: and ac.card_id = cct.card_id

Line 1808: ap_credit_card_trxns cct,

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
1812: and ac.card_id = cct.card_id

Line 1941: from ap_credit_card_trxns cct,

1937: IS
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

Line 2426: ap_credit_card_trxns cct,

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'
2430: and cct.inactive_emp_wf_item_key is not null

Line 2582: from ap_credit_card_trxns cct,

2578: p_inact_employee_id in number,
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

Line 2630: update ap_credit_card_trxns

2626: fetch cc_trx_cur into l_trx_id;
2627: exit when cc_trx_cur%notfound;
2628:
2629: -- if l_expense_status_code in( 'WITHDRAWN', 'RETURNED', 'REJECTED', 'ERROR') then
2630: update ap_credit_card_trxns
2631: set inactive_emp_wf_item_key = NULL
2632: where trx_id = l_trx_id;
2633: -- end if;
2634: