[Home] [Help]
55: transaction_amount,
56: cc.card_id,
57: nvl(cc.category, c_business)
58: FROM ap_credit_card_trxns cc,
59: ap_cards card
60: WHERE cc.validate_code = 'Y'
61: AND cc.payment_flag <> 'Y'
62: AND cc.billed_amount is not null
63: AND nvl(cc.expensed_amount,0) = 0
99: cp.card_program_name,
100: card.card_id,
101: trxn.payment_due_from_code
102: FROM ap_card_programs cp,
103: ap_cards card,
104: ap_credit_card_trxns trxn
105: WHERE card.employee_id = p_user_id
106: AND card.card_program_id = cp.card_program_id
107: AND cp.card_type_lookup_code = p_card_type
112: cp.card_program_name,
113: card.card_id,
114: cp.payment_due_from_code
115: FROM ap_card_programs cp,
116: ap_cards card
117: WHERE card.employee_id = p_user_id
118: AND card.card_program_id = cp.card_program_id
119: AND cp.card_type_lookup_code = p_card_type;
120:
149: cc.CARD_ID THE_CARD_ID,
150: emp.full_name,
151: emp.person_id
152: FROM AP_CREDIT_CARD_TRXNS cc,
153: AP_CARDS card,
154: per_people_x emp
155: WHERE cc.CARD_PROGRAM_ID = p_card_prog_id
156: AND cc.VALIDATE_CODE = 'Y'
157: AND cc.payment_flag <> 'Y'
194: OPEN p_disputed_cursor FOR
195: SELECT transaction_date, merchant_name1, billed_amount, billed_currency_code
196: FROM
197: ap_credit_card_trxns cct,
198: ap_cards_all ac
199: WHERE
200: cct.card_program_id = p_cardProgramId
201: and cct.validate_code = 'Y'
202: and cct.payment_flag <> 'Y'
249: erh.report_header_id), --2615448
250: cct.trx_id -- Bug 3241358
251: FROM
252: ap_credit_card_trxns cct,
253: ap_cards ac,
254: ap_expense_report_headers erh
255: WHERE
256: cct.card_program_id = p_cardProgramId
257: and cct.validate_code = 'Y'
282: 'UNUSED',
283: cct.trx_id -- Bug 3241358
284: FROM
285: ap_credit_card_trxns cct,
286: ap_cards ac
287: WHERE
288: cct.card_program_id = p_cardProgramId
289: and cct.validate_code = 'Y'
290: and cct.payment_flag <> 'Y'
311: erh.report_header_id), --2615448
312: cct.trx_id -- Bug 3241358
313: FROM
314: ap_credit_card_trxns cct,
315: ap_cards ac,
316: ap_expense_report_headers erh
317: WHERE
318: cct.card_program_id = p_cardProgramId
319: and cct.validate_code = 'Y'
374: erh.report_header_id), --2615448
375: cct.trx_id -- Bug 3241358
376: FROM
377: ap_credit_card_trxns cct,
378: ap_cards ac,
379: ap_expense_report_headers erh
380: WHERE
381: cct.card_program_id = p_cardProgramId
382: and cct.validate_code = 'Y'
405: 'UNUSED',
406: cct.trx_id -- Bug 3241358
407: FROM
408: ap_credit_card_trxns cct,
409: ap_cards ac
410: WHERE
411: cct.card_program_id = p_cardProgramId
412: and cct.validate_code = 'Y'
413: and cct.payment_flag <> 'Y'
433: erh.report_header_id), --2615448
434: cct.trx_id -- Bug 3241358
435: FROM
436: ap_credit_card_trxns cct,
437: ap_cards ac,
438: ap_expense_report_headers erh
439: WHERE
440: cct.card_program_id = p_cardProgramId
441: and cct.validate_code = 'Y'
500: AP_WEB_DB_CCARD_PKG.GETLOCATION(cct.merchant_city , cct.merchant_province_state), --Notification Esc
501: cct.trx_id -- Bug 3241358
502: FROM
503: ap_credit_card_trxns cct,
504: ap_cards ac,
505: ap_expense_report_headers erh
506: WHERE
507: cct.card_program_id = p_cardProgramId
508: and cct.validate_code = 'Y'
535: AP_WEB_DB_CCARD_PKG.GETLOCATION(cct.merchant_city , cct.merchant_province_state), --Notification Esc
536: cct.trx_id -- Bug 3241358
537: FROM
538: ap_credit_card_trxns cct,
539: ap_cards ac,
540: ap_expense_report_headers erh
541: WHERE
542: cct.card_program_id = p_cardProgramId
543: and cct.validate_code = 'Y'
567: AP_WEB_DB_CCARD_PKG.GETLOCATION(cct.merchant_city , cct.merchant_province_state), --Notification Esc
568: cct.trx_id -- Bug 3241358
569: FROM
570: ap_credit_card_trxns cct,
571: ap_cards ac
572: WHERE
573: cct.card_program_id = p_cardProgramId
574: and cct.validate_code = 'Y'
575: and cct.payment_flag <> 'Y'
620: nvl(cct.billed_date, cct.posted_date) billed_date,
621: cct.trx_id -- Bug 3241358
622: FROM
623: ap_credit_card_trxns cct,
624: ap_cards ac,
625: ap_expense_report_headers erh
626: WHERE
627: cct.card_program_id = p_cardProgramId
628: and cct.validate_code = 'Y'
651: nvl(cct.billed_date, cct.posted_date) billed_date,
652: cct.trx_id
653: FROM
654: ap_credit_card_trxns cct,
655: ap_cards ac,
656: ap_expense_report_headers erh
657: WHERE
658: cct.card_program_id = p_cardProgramId
659: and cct.validate_code = 'Y'
678: nvl(cct.billed_date, cct.posted_date) billed_date,
679: cct.trx_id -- Bug 3241358
680: FROM
681: ap_credit_card_trxns cct,
682: ap_cards ac
683: WHERE
684: cct.card_program_id = p_cardProgramId
685: and cct.validate_code = 'Y'
686: and cct.payment_flag <> 'Y'
966: -- Determine if the user has Credit Card
967: SELECT 'Y'
968: INTO p_userHasCreditCard
969: FROM AP_CARD_PROGRAMS_all CP ,
970: AP_CARDS_all CARD ,
971: AP_LOOKUP_CODES ALC,
972: ( SELECT CARD_PROGRAM_ID,CARD_ID, PAYMENT_DUE_FROM_CODE
973: FROM AP_CREDIT_CARD_TRXNS_all
974: WHERE VALIDATE_CODE = 'Y'
1611: -------------------------------------------
1612: select count(1)
1613: into p_num_old
1614: from ap_card_programs cp,
1615: ap_cards card,
1616: ap_credit_card_trxns trxns
1617: where card.employee_id = p_employee_id
1618: and card.card_program_id = cp.card_program_id
1619: and cp.card_type_lookup_code = 'TRAVEL'
1653: -------------------------------------------
1654: select count(1)
1655: into p_num_disputed
1656: from ap_card_programs cp,
1657: ap_cards card,
1658: ap_credit_card_trxns trxns
1659: where card.employee_id = p_employee_id
1660: and card.card_program_id = cp.card_program_id
1661: and cp.card_type_lookup_code = 'TRAVEL'
1692: -------------------------------------------
1693: select count(1)
1694: into p_num_credits
1695: from ap_card_programs cp,
1696: ap_cards card,
1697: ap_credit_card_trxns trxns
1698: where card.employee_id = p_employee_id
1699: and card.card_program_id = cp.card_program_id
1700: and cp.card_type_lookup_code = 'TRAVEL'
1876: cct.transaction_amount,--Notification Esc
1877: AP_WEB_DB_CCARD_PKG.GETLOCATION(cct.merchant_city , cct.merchant_province_state) --Notification Esc
1878: from
1879: ap_credit_card_trxns cct,
1880: ap_cards_all ac
1881: where
1882: cct.card_program_id = p_cardProgramId
1883: and cct.validate_code = 'Y'
1884: and cct.payment_flag <> 'Y'
1924: (
1925: SELECT DISTINCT cct.trx_id, cct.billed_amount amount
1926: FROM
1927: ap_credit_card_trxns_all cct,
1928: ap_cards_all ac,
1929: ap_expense_report_headers_all erh
1930: WHERE
1931: cct.card_program_id = p_cardProgramId
1932: and cct.validate_code = 'Y'
1945: UNION ALL
1946: SELECT DISTINCT cct.trx_id, cct.billed_amount amount
1947: FROM
1948: ap_credit_card_trxns_all cct,
1949: ap_cards_all ac
1950: WHERE
1951: cct.card_program_id = p_cardProgramId
1952: and cct.validate_code = 'Y'
1953: and cct.payment_flag <> 'Y'
1995: FROM
1996: ( SELECT DISTINCT trx_id, cct.billed_amount amount
1997: FROM
1998: ap_credit_card_trxns cct,
1999: ap_cards ac,
2000: ap_expense_report_headers erh
2001: WHERE
2002: cct.card_program_id = p_cardProgramId
2003: and cct.validate_code = 'Y'
2017: UNION ALL
2018: SELECT DISTINCT trx_id, cct.billed_amount amount
2019: FROM
2020: ap_credit_card_trxns cct,
2021: ap_cards ac
2022: WHERE
2023: cct.card_program_id = p_cardProgramId
2024: and cct.validate_code = 'Y'
2025: and cct.payment_flag <> 'Y'
2071: FROM
2072: ( SELECT DISTINCT trx_id, cct.billed_amount amount
2073: FROM
2074: ap_credit_card_trxns cct,
2075: ap_cards ac,
2076: ap_expense_report_headers erh
2077: WHERE
2078: cct.card_program_id = p_cardProgramId
2079: and cct.validate_code = 'Y'