eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_MANAGEMENT_REPORTS_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 131: FROM per_all_assignments_f

127:
128: -- Cursor to fetch supervisor
129: CURSOR C_Supervisor (P_StartDate DATE, P_EndDate DATE) IS
130: SELECT distinct supervisor_id
131: FROM per_all_assignments_f
132: WHERE person_id = P_PersonId
133: AND P_StartDate < effective_end_date
134: AND P_EndDate > effective_start_date
135: AND assignment_type in ('C','E');

Line 555: per_all_assignments_f paa

551: paa.supervisor_id,
552: greatest(paa.effective_start_date, P_StartDate) as Start_Date,
553: least(paa.effective_end_date, P_EndDate) as End_Date
554: FROM per_all_people_f pap,
555: per_all_assignments_f paa
556: WHERE pap.person_id = paa.person_id
557: AND pap.person_id = P_EmployeeId
558: AND P_StartDate < paa.effective_end_date
559: AND P_EndDate > paa.effective_start_date

Line 571: per_all_assignments_f paa

567: paa.supervisor_id,
568: greatest(paa.effective_start_date, P_StartDate) as Start_Date,
569: least(paa.effective_end_date, P_EndDate) as End_Date
570: FROM per_all_people_f pap,
571: per_all_assignments_f paa
572: WHERE pap.person_id = paa.person_id
573: AND paa.supervisor_id = P_EmployeeId
574: AND 'MANAGER' = P_QryType
575: AND P_StartDate < paa.effective_end_date

Line 595: from per_all_assignments_f

591: paa.supervisor_id,
592: paa.effective_start_date,
593: paa.effective_end_date,
594: ( select least( P_EndDate , max(effective_end_date) )
595: from per_all_assignments_f
596: where person_id = pap.person_id
597: and supervisor_id = paa.supervisor_id
598: and ( assignment_type = 'E' OR assignment_type = 'C')
599: start with effective_start_date = paa.effective_start_date

Line 606: per_all_assignments_f paa

602: AND ( assignment_type = 'E' OR assignment_type = 'C')
603: and prior effective_end_date = ( effective_start_date - 1 )
604: ) max_end_date
605: FROM per_all_people_f pap,
606: per_all_assignments_f paa
607: WHERE pap.person_id = paa.person_id
608: AND ( pap.person_id = P_EmployeeId or ( P_QryType = 'MANAGER' AND paa.supervisor_id = P_EmployeeId ) )
609: AND P_StartDate <= paa.effective_end_date
610: AND P_EndDate >= paa.effective_start_date

Line 936: FROM per_all_assignments_f paf,

932: sysdate,
933: P_ExchangeRateType,
934: aerl.amount
935: )) as expense_amount
936: FROM per_all_assignments_f paf,
937: ap_expense_report_lines_v aerl
938: WHERE paf.supervisor_id = P_EmployeeId
939: AND paf.effective_start_date < P_EndDate
940: AND paf.effective_end_date > P_StartDate

Line 987: per_all_assignments_f paf

983: P_ExchangeRateType,
984: aerl.amount
985: )) as line_amount
986: FROM ap_expense_report_lines_v aerl,
987: per_all_assignments_f paf
988: WHERE EXISTS ( SELECT 'X'
989: FROM ap_pol_violations_all apv
990: WHERE apv.report_header_id = aerl.report_header_id
991: AND apv.distribution_line_number = aerl.distribution_line_number

Line 1056: FROM per_all_assignments_f paf,

1052: P_ExchangeRateType,
1053: aerv.allowable_amount
1054: ))) as allowable_amount,
1055: count(aerv.report_header_id) as number_of_violations
1056: FROM per_all_assignments_f paf,
1057: ap_expense_report_violations_v aerv
1058: WHERE paf.supervisor_id = P_EmployeeId
1059: AND paf.effective_start_date < P_EndDate
1060: AND paf.effective_end_date > P_StartDate

Line 1119: per_all_assignments_f paf

1115: )) as allowable_amount,
1116: 1 as number_of_violations
1117: FROM ap_expense_report_headers_all aerh,
1118: ap_pol_violations_all apv,
1119: per_all_assignments_f paf
1120: WHERE aerh.report_header_id = apv.report_header_id
1121: AND aerh.org_id = apv.org_id
1122: AND apv.distribution_line_number = -1
1123: AND (aerh.source <> 'NonValidatedWebExpense' OR aerh.workflow_approved_flag IS NULL)

Line 1178: FROM per_all_assignments_f paf,

1174: P_ExchangeRateType,
1175: aerv.allowable_amount
1176: ))) as allowable_amount,
1177: count(aerv.report_header_id) as number_of_violations
1178: FROM per_all_assignments_f paf,
1179: ap_expense_report_violations_v aerv
1180: WHERE paf.supervisor_id = P_EmployeeId
1181: AND paf.effective_start_date < P_EndDate
1182: AND paf.effective_end_date > P_StartDate

Line 1509: per_all_assignments_f paf

1505: P_ExchangeRateType,
1506: aerl.amount
1507: )) as line_amount
1508: FROM ap_expense_report_lines_v aerl,
1509: per_all_assignments_f paf
1510: WHERE EXISTS ( SELECT 'X'
1511: FROM ap_pol_violations_all apv
1512: WHERE apv.report_header_id = aerl.report_header_id
1513: AND apv.distribution_line_number = aerl.distribution_line_number

Line 1579: FROM per_all_assignments_f paf,

1575: P_ExchangeRateType,
1576: aerv.allowable_amount
1577: ))) as allowable_amount,
1578: count(aerv.report_header_id) as number_of_violations
1579: FROM per_all_assignments_f paf,
1580: ap_expense_report_violations_v aerv
1581: WHERE paf.supervisor_id = P_EmployeeId
1582: AND paf.effective_start_date < P_EndDate
1583: AND paf.effective_end_date > P_StartDate

Line 1642: per_all_assignments_f paf

1638: )) as allowable_amount,
1639: 1 as number_of_violations
1640: FROM ap_expense_report_headers_all aerh,
1641: ap_pol_violations_all apv,
1642: per_all_assignments_f paf
1643: WHERE aerh.report_header_id = apv.report_header_id
1644: AND aerh.org_id = apv.org_id
1645: AND apv.distribution_line_number = -1
1646: AND (aerh.source <> 'NonValidatedWebExpense' OR aerh.workflow_approved_flag IS NULL)

Line 1701: FROM per_all_assignments_f paf,

1697: P_ExchangeRateType,
1698: aerv.allowable_amount
1699: ))) as allowable_amount,
1700: count(aerv.report_header_id) as number_of_violations
1701: FROM per_all_assignments_f paf,
1702: ap_expense_report_violations_v aerv
1703: WHERE paf.supervisor_id = P_EmployeeId
1704: AND paf.effective_start_date < P_EndDate
1705: AND paf.effective_end_date > P_StartDate