APPS.POR_HISTORY_FEED_PKG dependencies on IBY_CREDITCARD

Line 1068: TYPE tab_cardno IS TABLE OF iby_creditcard.masked_cc_number%TYPE;

1064: TYPE tab_po_num IS TABLE OF po_headers.segment1%TYPE;
1065: TYPE tab_rel_num IS TABLE OF po_releases.release_num%TYPE;
1066: TYPE tab_po_header_id IS TABLE OF po_headers.po_header_id%TYPE;
1067: TYPE tab_po_release_id IS TABLE OF po_releases.po_release_id%TYPE;
1068: TYPE tab_cardno IS TABLE OF iby_creditcard.masked_cc_number%TYPE;
1069: TYPE tab_cardmember IS TABLE OF ap_cards.cardmember_name%TYPE;
1070: TYPE tab_card_type IS TABLE OF ap_card_programs.card_type_lookup_code%TYPE;
1071: TYPE tab_card_brand IS TABLE OF ap_card_programs.card_brand_lookup_code%TYPE;
1072: TYPE tab_requester_id IS TABLE OF ap_cards.employee_id%TYPE;

Line 1184: iby_creditcard ibycc

1180: AP_CARD_PROGRAMS ACP,
1181: MTL_SYSTEM_ITEMS_KFV MSI,
1182: GL_SETS_OF_BOOKS GSB,
1183: FINANCIALS_SYSTEM_PARAMETERS FSP,
1184: iby_creditcard ibycc
1185:
1186: WHERE
1187:
1188: PH.PO_HEADER_ID = PL.PO_HEADER_ID

Line 1259: iby_creditcard ibycc

1255: AP_CARDS AC,
1256: AP_CARD_PROGRAMS ACP,
1257: GL_SETS_OF_BOOKS GSB,
1258: FINANCIALS_SYSTEM_PARAMETERS FSP,
1259: iby_creditcard ibycc
1260:
1261: WHERE
1262: PH.PO_HEADER_ID = PL.PO_HEADER_ID
1263: AND PH.TYPE_LOOKUP_CODE = 'STANDARD'

Line 1333: iby_creditcard ibycc

1329: AP_CARDS AC,
1330: AP_CARD_PROGRAMS ACP,
1331: GL_SETS_OF_BOOKS GSB,
1332: FINANCIALS_SYSTEM_PARAMETERS FSP,
1333: iby_creditcard ibycc
1334:
1335: WHERE
1336: PH.PO_HEADER_ID = PR.PO_HEADER_ID
1337: AND PH.PO_HEADER_ID = PL.PO_HEADER_ID

Line 1410: iby_creditcard ibycc

1406: AP_CARD_PROGRAMS ACP,
1407: MTL_SYSTEM_ITEMS_KFV MSI,
1408: GL_SETS_OF_BOOKS GSB,
1409: FINANCIALS_SYSTEM_PARAMETERS FSP,
1410: iby_creditcard ibycc
1411:
1412: WHERE
1413: PH.PO_HEADER_ID = PR.PO_HEADER_ID
1414: AND PH.PO_HEADER_ID = PL.PO_HEADER_ID

Line 1480: iby_creditcard ibycc

1476: AP_CARDS AC,
1477: AP_CARD_PROGRAMS ACP,
1478: GL_SETS_OF_BOOKS GSB,
1479: FINANCIALS_SYSTEM_PARAMETERS FSP,
1480: iby_creditcard ibycc
1481:
1482: WHERE
1483: PH.TYPE_LOOKUP_CODE = 'STANDARD'
1484: AND PH.PCARD_ID IS NOT NULL --p-card is used

Line 1538: iby_creditcard ibycc

1534: AP_CARDS AC,
1535: AP_CARD_PROGRAMS ACP,
1536: GL_SETS_OF_BOOKS GSB,
1537: FINANCIALS_SYSTEM_PARAMETERS FSP,
1538: iby_creditcard ibycc
1539:
1540: WHERE
1541: PH.PO_HEADER_ID = PR.PO_HEADER_ID
1542: AND PH.TYPE_LOOKUP_CODE = 'BLANKET'