DBA Data[Home] [Help]

APPS.PA_TRX_IMPORT dependencies on PSP_SUMMARY_LINES

Line 2102: psp_summary_lines psl

2098: begin
2099: select paa.job_id
2100: into G_job_id
2101: from PER_ALL_ASSIGNMENTS_F paa,
2102: psp_summary_lines psl
2103: where paa.assignment_id = psl.assignment_id
2104: and psl.effective_date between paa.effective_start_date and paa.effective_end_date
2105: and psl.SUMMARY_LINE_ID = X_trx_ref;
2106: exception

Line 2165: psp_summary_lines psl

2161: begin
2162: select paa.job_id
2163: into G_job_id
2164: from PER_ALL_ASSIGNMENTS_F paa,
2165: psp_summary_lines psl
2166: where paa.assignment_id = psl.assignment_id
2167: and psl.effective_date between paa.effective_start_date and paa.effective_end_date
2168: and psl.SUMMARY_LINE_ID = X_trx_ref;
2169: exception