DBA Data[Home] [Help]

APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on HR_SOFT_CODING_KEYFLEX

Line 11171: l_tax_unit_id hr_soft_coding_keyflex.segment1%type ;

11167: )
11168: is
11169: l_package VARCHAR2(80) := g_package || '.set_taxunit_context';
11170: --
11171: l_tax_unit_id hr_soft_coding_keyflex.segment1%type ;
11172: --
11173: cursor c_tax is
11174: select cfk.segment1
11175: from per_all_assignments_f asg, hr_soft_coding_keyflex cfk

Line 11175: from per_all_assignments_f asg, hr_soft_coding_keyflex cfk

11171: l_tax_unit_id hr_soft_coding_keyflex.segment1%type ;
11172: --
11173: cursor c_tax is
11174: select cfk.segment1
11175: from per_all_assignments_f asg, hr_soft_coding_keyflex cfk
11176: where asg.person_id = p_person_id
11177: and asg.assignment_type <> 'C'
11178: and asg.primary_flag = 'Y'
11179: AND p_effective_date BETWEEN asg.effective_start_date