APPS.AP_APXCCOUT_XMLP_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 110: , per_assignment_status_types peras';

106: , per_assignments_f pera';
107: ELSIF (P_STATUS = 'T') THEN
108: LP_EMPLOYEE_FROM := ', per_people_f perf
109: , per_assignments_f pera
110: , per_assignment_status_types peras';
111: ELSE
112: LP_EMPLOYEE_FROM := ' ';
113: END IF;
114: IF (P_STATUS = 'C') THEN

Line 1424: PER_ASSIGNMENT_STATUS_TYPES PERAS

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
1426: AND CCT.PAYMENT_FLAG <> 'Y'
1427: AND NVL(CCT.CATEGORY
1428: ,'BUSINESS') <> 'DEACTIVATED'

Line 1463: PER_ASSIGNMENT_STATUS_TYPES PERAS,

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
1465: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
1466: AND CCT.PAYMENT_FLAG <> 'Y'
1467: AND CCT.EXPENSED_AMOUNT <> 0

Line 1511: PER_ASSIGNMENT_STATUS_TYPES PERAS

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
1513: AND CCT.PAYMENT_FLAG <> 'Y'
1514: AND NVL(CCT.EXPENSED_AMOUNT
1515: ,0) = 0

Line 1551: PER_ASSIGNMENT_STATUS_TYPES PERAS,

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
1553: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
1554: AND CCT.PAYMENT_FLAG <> 'Y'
1555: AND CCT.EXPENSED_AMOUNT <> 0