DBA Data[Home] [Help]

APPS.PSP_ARCHIVE_RETRIEVE dependencies on PER_ASSIGNMENTS_F

Line 62: -- PER_ASSIGNMENTS_F PAF,

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,
65: -- PSP_EFFORT_REPORT_PERIODS PERP,
66: -- PSP_EFFORT_REPORT_TEMPLATES PERT

Line 95: PER_ASSIGNMENTS_F PAF,

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
98: WHERE PER.status_code <> 'C'
99: and PER.effort_Report_id = PERD.effort_report_id