DBA Data[Home] [Help]

APPS.PAY_US_RULES dependencies on HR_SOFT_CODING_KEYFLEX

Line 295: hr_soft_coding_keyflex hrsckf,

291: nvl(hrloc.loc_information19,hrloc.region_1),
292: nvl(hrloc.loc_information18,hrloc.town_or_city),
293: nvl(hrloc.loc_information20,hrloc.postal_code)
294: from hr_locations hrloc,
295: hr_soft_coding_keyflex hrsckf,
296: per_all_assignments_f assign,
297: pay_assignment_actions paa
298: where paa.assignment_id = assign.assignment_id
299: and paa.assignment_action_id = p_asg_act_id

Line 1957: hr_soft_coding_keyflex target,

1953: p_date_earned date,
1954: p_assignment_id number) IS
1955: SELECT target.SEGMENT4
1956: FROM /* route for SCL keyflex - assignment level */
1957: hr_soft_coding_keyflex target,
1958: per_all_assignments_f ASSIGN
1959: WHERE p_date_earned BETWEEN ASSIGN.effective_start_date
1960: AND ASSIGN.effective_end_date
1961: AND ASSIGN.assignment_id = p_assignment_id