APPS.AP_WEB_DB_CCARD_PKG dependencies on AP_CARD_PROGRAMS

Line 102: FROM ap_card_programs cp,

98: cp.card_program_id,
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

Line 115: FROM ap_card_programs cp,

111: SELECT cp.card_program_id,
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;

Line 719: FROM ap_card_programs

715: BEGIN
716:
717: SELECT card_program_currency_code
718: INTO p_curr_code
719: FROM ap_card_programs
720: WHERE card_program_id = p_card_prog_id;
721:
722: RETURN TRUE;
723:

Line 833: FROM AP_CARD_PROGRAMS

829: CARD_PROGRAM_CURRENCY_CODE
830: INTO p_vendor_id,
831: p_vendor_site_id,
832: p_invoice_curr_code
833: FROM AP_CARD_PROGRAMS
834: WHERE CARD_PROGRAM_ID = p_card_prog_id;
835:
836: RETURN TRUE;
837:

Line 861: ap_card_programs acp

857: acp.vendor_site_id
858: INTO p_vendor_id,
859: p_vendor_site_id
860: FROM ap_credit_card_trxns cc,
861: ap_card_programs acp
862: WHERE cc.report_header_id = p_report_header_id
863: AND cc.card_program_id = acp.card_program_id;
864:
865: RETURN TRUE;

Line 887: from ap_card_programs

883: -------------------------------------------------------------------
884: BEGIN
885: select card_program_name
886: into p_cardProgramName
887: from ap_card_programs
888: where card_program_id = p_cardProgramID;
889:
890: RETURN TRUE;
891:

Line 913: from ap_card_programs

909: -------------------------------------------------------------------
910: BEGIN
911: select card_program_id
912: into p_cardProgramID
913: from ap_card_programs
914: where card_program_name = p_cardProgramName;
915:
916: RETURN TRUE;
917:

Line 941: from ap_card_programs

937:
938: -- Determine if company has Card Program
939: select 'Y'
940: into p_companyHasCardProgram
941: from ap_card_programs
942: where card_type_lookup_code = 'TRAVEL';
943:
944: RETURN TRUE;
945:

Line 969: FROM AP_CARD_PROGRAMS_all CP ,

965:
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

Line 1614: from ap_card_programs cp,

1610: l_debug_info := 'Get number of Outstanding Trxns';
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

Line 1656: from ap_card_programs cp,

1652: l_debug_info := 'Get number of Disputed';
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

Line 1695: from ap_card_programs cp,

1691: l_debug_info := 'Get number of Credits';
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