DBA Data[Home] [Help]

APPS.PSB_HR_EXTRACT_DATA_PVT dependencies on PAY_COST_ALLOCATIONS_F

Line 2313: pay_cost_allocations_f pcaf,

2309: pcaf.cost_allocation_keyflex_id,
2310: pcaf.effective_start_date,
2311: pcaf.effective_end_date
2312: from fnd_sessions fs, per_all_assignments_f paf,
2313: pay_cost_allocations_f pcaf,
2314: pay_cost_allocation_keyflex pcak
2315: where fs.session_id = userenv('sessionid')
2316: and fs.effective_date between paf.effective_start_date and paf.effective_end_date
2317: and paf.business_group_id = p_business_group_id

Line 2347: from pay_cost_allocations_f pcax

2343: and fs.effective_date between paf.effective_start_date and paf.effective_end_date
2344: and paf.business_group_id = p_business_group_id
2345: and paf.payroll_id > l_restart_payroll_id
2346: and not exists (select 1
2347: from pay_cost_allocations_f pcax
2348: where pcax.assignment_id = paf.assignment_id
2349: and fs.session_id = userenv('sessionid')
2350: and fs.effective_date between pcax.effective_start_date and pcax.effective_end_date)
2351: AND (p_extract_by_org = l_no OR