DBA Data[Home] [Help]

APPS.PA_TRX_IMPORT dependencies on PSP_SUMMARY_LINES

Line 2288: psp_summary_lines psl

2284: begin
2285: select paa.job_id
2286: into G_job_id
2287: from PER_ALL_ASSIGNMENTS_F paa,
2288: psp_summary_lines psl
2289: where paa.assignment_id = psl.assignment_id
2290: and psl.effective_date between paa.effective_start_date and paa.effective_end_date
2291: and psl.SUMMARY_LINE_ID = X_trx_ref;
2292: exception

Line 2390: psp_summary_lines psl

2386: begin
2387: select paa.job_id
2388: into G_job_id
2389: from PER_ALL_ASSIGNMENTS_F paa,
2390: psp_summary_lines psl
2391: where paa.assignment_id = psl.assignment_id
2392: and psl.effective_date between paa.effective_start_date and paa.effective_end_date
2393: and psl.SUMMARY_LINE_ID = X_trx_ref;
2394: exception