APPS.PSP_ER_AME dependencies on PER_ALL_ASSIGNMENTS_F

Line 944: per_all_assignments_f asg

940: p_approver_display_name,
941: 1
942: from psp_eff_report_details erd,
943: psp_eff_reports er,
944: per_all_assignments_f asg
945: where erd.effort_report_id = er.effort_report_id
946: and er.request_id = p_request_id
947: and er.person_id between p_start_person and p_end_person
948: and er.status_code = 'N'

Line 1505: per_all_assignments_f asg

1501: set erd.ame_transaction_id = l_ame_txn_id
1502: where erd.effort_report_id in
1503: (select er.effort_report_id
1504: from psp_eff_reports er,
1505: per_all_assignments_f asg
1506: where er.request_id = p_request_id
1507: and er.person_id between p_start_person and p_end_person
1508: and er.status_code = 'N'
1509: and asg.person_id = er.person_id