eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_APXCCPUT_XMLP_PKG dependencies on AP_CARDS

Line 249: v_employee_id ap_cards.employee_id%type;

245:
246: END;
247:
248: PROCEDURE SendDeactivated IS
249: v_employee_id ap_cards.employee_id%type;
250: v_card_program_id ap_cards.card_program_id%type;
251:
252: cursor cur_sendDeactivated is
253: select distinct card.employee_id, card.card_program_id

Line 250: v_card_program_id ap_cards.card_program_id%type;

246: END;
247:
248: PROCEDURE SendDeactivated IS
249: v_employee_id ap_cards.employee_id%type;
250: v_card_program_id ap_cards.card_program_id%type;
251:
252: cursor cur_sendDeactivated is
253: select distinct card.employee_id, card.card_program_id
254: from ap_credit_card_trxns txn,

Line 255: ap_cards card

251:
252: cursor cur_sendDeactivated is
253: select distinct card.employee_id, card.card_program_id
254: from ap_credit_card_trxns txn,
255: ap_cards card
256: where txn.report_header_id = -1
257: and txn.category = 'DEACTIVATED'
258: and txn.org_id = nvl(p_org_id, txn.org_id)
259: and txn.card_id = nvl(p_card_number, txn.card_id)