DBA Data[Home] [Help]

APPS.PAY_ZA_BANK_DDF_UPD dependencies on PER_ALL_ASSIGNMENTS_F

Line 12: from per_all_assignments_f paaf

8: --Check if the assignment is either active or terminated after tax year start of 2010 year
9: cursor csr_assignments
10: is
11: select 1
12: from per_all_assignments_f paaf
13: where paaf.effective_end_date >= to_date('01/03/2009','dd/mm/yyyy')
14: and paaf.assignment_id = p_assignment_id
15: and paaf.business_group_id in (select business_group_id
16: from per_business_groups