DBA Data[Home] [Help]

APPS.PAY_US_RULES dependencies on HR_SOFT_CODING_KEYFLEX

Line 240: hr_soft_coding_keyflex hrsckf,

236: nvl(hrloc.loc_information19,hrloc.region_1),
237: nvl(hrloc.loc_information18,hrloc.town_or_city),
238: nvl(hrloc.loc_information20,hrloc.postal_code)
239: from hr_locations hrloc,
240: hr_soft_coding_keyflex hrsckf,
241: per_all_assignments_f assign,
242: pay_assignment_actions paa
243: where paa.assignment_id = assign.assignment_id
244: and paa.assignment_action_id = p_asg_act_id

Line 1901: hr_soft_coding_keyflex target,

1897: p_date_earned date,
1898: p_assignment_id number) IS
1899: SELECT target.SEGMENT4
1900: FROM /* route for SCL keyflex - assignment level */
1901: hr_soft_coding_keyflex target,
1902: per_all_assignments_f ASSIGN
1903: WHERE p_date_earned BETWEEN ASSIGN.effective_start_date
1904: AND ASSIGN.effective_end_date
1905: AND ASSIGN.assignment_id = p_assignment_id