DBA Data[Home] [Help]

APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on HR_SOFT_CODING_KEYFLEX

Line 11244: l_tax_unit_id hr_soft_coding_keyflex.segment1%type ;

11240: )
11241: is
11242: l_package VARCHAR2(80) := g_package || '.set_taxunit_context';
11243: --
11244: l_tax_unit_id hr_soft_coding_keyflex.segment1%type ;
11245: --
11246: cursor c_tax is
11247: select cfk.segment1
11248: from per_all_assignments_f asg, hr_soft_coding_keyflex cfk

Line 11248: from per_all_assignments_f asg, hr_soft_coding_keyflex cfk

11244: l_tax_unit_id hr_soft_coding_keyflex.segment1%type ;
11245: --
11246: cursor c_tax is
11247: select cfk.segment1
11248: from per_all_assignments_f asg, hr_soft_coding_keyflex cfk
11249: where asg.person_id = p_person_id
11250: and asg.assignment_type <> 'C'
11251: and asg.primary_flag = 'Y'
11252: AND p_effective_date BETWEEN asg.effective_start_date