DBA Data[Home] [Help]

APPS.AP_APXCCOUT_XMLP_PKG dependencies on AP_CARD_PROGRAMS_ALL

Line 910: AP_CARD_PROGRAMS_ALL CP

906: SELECT
907: CARD_PROGRAM_NAME
908: INTO CP_CARD_PROGRAM_NAME
909: FROM
910: AP_CARD_PROGRAMS_ALL CP
911: WHERE CP.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID;
912: RETURN (TRUE);
913: RETURN NULL;
914: EXCEPTION

Line 1421: AP_CARD_PROGRAMS_ALL CP,

1417: CCT.TRX_ID
1418: FROM
1419: AP_CREDIT_CARD_TRXNS CCT,
1420: AP_CARDS_ALL AC,
1421: AP_CARD_PROGRAMS_ALL CP,
1422: PER_PEOPLE_F PERF,
1423: PER_ASSIGNMENTS_F PERA,
1424: PER_ASSIGNMENT_STATUS_TYPES PERAS
1425: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID

Line 1460: AP_CARD_PROGRAMS_ALL CP,

1456: CCT.TRX_ID
1457: FROM
1458: AP_CREDIT_CARD_TRXNS CCT,
1459: AP_CARDS_ALL AC,
1460: AP_CARD_PROGRAMS_ALL CP,
1461: PER_PEOPLE_F PERF,
1462: PER_ASSIGNMENTS_F PERA,
1463: PER_ASSIGNMENT_STATUS_TYPES PERAS,
1464: AP_EXPENSE_REPORT_HEADERS ERH

Line 1508: AP_CARD_PROGRAMS_ALL CP,

1504: CCT.TRX_ID
1505: FROM
1506: AP_CREDIT_CARD_TRXNS CCT,
1507: AP_CARDS_ALL AC,
1508: AP_CARD_PROGRAMS_ALL CP,
1509: PER_PEOPLE_F PERF,
1510: PER_ASSIGNMENTS_F PERA,
1511: PER_ASSIGNMENT_STATUS_TYPES PERAS
1512: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID

Line 1548: AP_CARD_PROGRAMS_ALL CP,

1544: CCT.TRX_ID
1545: FROM
1546: AP_CREDIT_CARD_TRXNS CCT,
1547: AP_CARDS_ALL AC,
1548: AP_CARD_PROGRAMS_ALL CP,
1549: PER_PEOPLE_F PERF,
1550: PER_ASSIGNMENTS_F PERA,
1551: PER_ASSIGNMENT_STATUS_TYPES PERAS,
1552: AP_EXPENSE_REPORT_HEADERS ERH