DBA Data[Home] [Help]

APPS.PSP_ARCHIVE_RETRIEVE dependencies on PSP_EFFORT_REPORTS

Line 60: -- FROM PSP_EFFORT_REPORTS PER,

56: --WHERE EXISTS
57: -- (
58: -- SELECT DISTINCT PER.effort_report_id,
59: -- PER.version_num
60: -- FROM PSP_EFFORT_REPORTS PER,
61: -- PSP_EFFORT_REPORT_DETAILS PERD,
62: -- PER_ASSIGNMENTS_F PAF,
63: -- PER_TIME_PERIODS PTP1,
64: -- PER_TIME_PERIODS PTP2,

Line 93: FROM PSP_EFFORT_REPORTS PER,

89: WHERE PTP.payroll_id = p_payroll_id
90: AND PTP.time_period_id >= p_begin_period
91: AND PTP.time_period_id <= p_end_period
92: AND EXISTS (SELECT 1
93: FROM PSP_EFFORT_REPORTS PER,
94: PSP_EFFORT_REPORT_DETAILS PERD,
95: PER_ASSIGNMENTS_F PAF,
96: PSP_EFFORT_REPORT_PERIODS PERP,
97: PSP_EFFORT_REPORT_TEMPLATES PERT