DBA Data[Home] [Help]

APPS.PA_TRX_IMPORT dependencies on PER_ALL_ASSIGNMENTS_F

Line 2101: from PER_ALL_ASSIGNMENTS_F paa,

2097: IF X_trx_src in ('OLD', 'GOLD', 'GOLDE') and p_po_number is null THEN
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;

Line 2164: from PER_ALL_ASSIGNMENTS_F paa,

2160: IF X_trx_src in ('OLD', 'GOLD', 'GOLDE') and p_po_number is null THEN
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;