APPS.AP_APXCCOUT_XMLP_PKG dependencies on PER_ASSIGNMENTS_F

Line 106: , per_assignments_f pera';

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
110: , per_assignment_status_types peras';

Line 109: , per_assignments_f pera

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 := ' ';
113: END IF;

Line 149: from per_assignments_f pera1

145: from per_employees_x emp1 -- Bug 3176205: Changed HR view to include all employees(inactive also) and exclude contingent workers.
146: where emp1.supervisor_id = ' || P_EMPLOYEE || ')
147: OR ac.employee_id = ' || P_EMPLOYEE || ') ';
148: LP_EMP_MGR1 := ' and (ac.employee_id in (select distinct person_id
149: from per_assignments_f pera1
150: where pera1.supervisor_id = ' || P_EMPLOYEE || ' and pera1.assignment_type in (''E'',''C'') )
151: OR ac.employee_id = ' || P_EMPLOYEE || ') ';
152: ELSIF (P_INCLUDE_DIRECTS = 'N') THEN
153: LP_EMP_MGR := ' and ac.employee_id = ' || P_EMPLOYEE || ' ';

Line 1423: PER_ASSIGNMENTS_F PERA,

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'
1427: AND NVL(CCT.CATEGORY

Line 1462: PER_ASSIGNMENTS_F PERA,

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

Line 1510: PER_ASSIGNMENTS_F PERA,

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'
1514: AND NVL(CCT.EXPENSED_AMOUNT

Line 1550: PER_ASSIGNMENTS_F PERA,

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