APPS.AP_APXCCOUT_XMLP_PKG dependencies on PER_PEOPLE_F

Line 105: LP_EMPLOYEE_FROM := ', per_people_f perf

101: END IF;
102: IF (P_STATUS = 'C') THEN
103: LP_EMPLOYEE_FROM := ', per_employees_current_x emp';
104: ELSIF (P_STATUS = 'B') THEN
105: LP_EMPLOYEE_FROM := ', per_people_f perf
106: , per_assignments_f pera';
107: ELSIF (P_STATUS = 'T') THEN
108: LP_EMPLOYEE_FROM := ', per_people_f perf
109: , per_assignments_f pera

Line 108: LP_EMPLOYEE_FROM := ', per_people_f perf

104: ELSIF (P_STATUS = 'B') THEN
105: LP_EMPLOYEE_FROM := ', per_people_f perf
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 := ' ';

Line 1101: V_EMPLOYEE_ID PER_PEOPLE_F.PERSON_ID%TYPE;

1097: ,P_IN_DUNNING_NUMBER IN NUMBER
1098: ,P_IN_SEND_NOTIFICATIONS IN VARCHAR2
1099: ,P_IN_ESC_LEVEL IN NUMBER
1100: ,P_IN_GRACE_DAYS IN NUMBER) IS
1101: V_EMPLOYEE_ID PER_PEOPLE_F.PERSON_ID%TYPE;
1102: V_CARD_PROGRAM_ID AP_CREDIT_CARD_TRXNS.CARD_PROGRAM_ID%TYPE;
1103: V_MIN_BUCKET NUMBER;
1104: V_MAX_BUCKET NUMBER;
1105: V_BILLED_AMOUNT AP_CREDIT_CARD_TRXNS.BILLED_AMOUNT%TYPE;

Line 1422: PER_PEOPLE_F PERF,

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
1426: AND CCT.PAYMENT_FLAG <> 'Y'

Line 1461: PER_PEOPLE_F PERF,

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
1465: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID

Line 1509: PER_PEOPLE_F PERF,

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
1513: AND CCT.PAYMENT_FLAG <> 'Y'

Line 1549: PER_PEOPLE_F PERF,

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
1553: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID