eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_TRX_IMPORT dependencies on PER_ALL_ASSIGNMENTS_F

Line 2287: from PER_ALL_ASSIGNMENTS_F paa,

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

Line 2389: from PER_ALL_ASSIGNMENTS_F paa,

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

Line 6804: ,per_all_assignments_f a

6800:
6801: SELECT decode(a.assignment_type,'E','EMP','C','CWK')
6802: INTO p_person_type
6803: FROM per_assignment_status_types s
6804: ,per_all_assignments_f a
6805: WHERE a.job_id IS NOT NULL
6806: AND a.primary_flag = 'Y'
6807: AND p_date BETWEEN trunc(a.effective_start_date) AND trunc(a.effective_end_date)
6808: AND a.person_id = p_person_id