DBA Data[Home] [Help]

APPS.PAY_CN_RULES dependencies on HR_SOFT_CODING_KEYFLEX

Line 93: ,hr_soft_coding_keyflex hsck

89: CURSOR csr_tax_area (p_effective_date IN DATE) IS
90: SELECT hsck.segment20, pa.business_group_id
91: FROM pay_element_entries_f pee
92: ,per_assignments_f pa
93: ,hr_soft_coding_keyflex hsck
94: WHERE pee.assignment_id = pa.assignment_id
95: AND pa.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
96: AND pee.element_entry_id = p_ee_id
97: AND p_effective_date BETWEEN pa.effective_start_date

Line 113: l_tax_area hr_soft_coding_keyflex.segment20%TYPE;

109: AND TO_DATE(NVL(org_information4,'4712/12/31 00:00:00'),'YYYY/MM/DD HH24:MI:SS');
110:
111: l_retro_component_id pay_retro_components.retro_component_id%TYPE;
112: l_element_name pay_element_types_f.element_name%TYPE;
113: l_tax_area hr_soft_coding_keyflex.segment20%TYPE;
114: l_bg_id per_all_assignments_f.business_group_id%TYPE;
115: l_effective_date DATE;
116: l_creator_type pay_element_entries_f.creator_type%TYPE;
117: