APPS.HR_NL_EXTRA_ASG_RULES dependencies on HR_SOFT_CODING_KEYFLEX

Line 80: ,hr_soft_coding_keyflex scl

76: ,scl.segment4 tax_red
77: ,scl.segment7 labour_tax
78: ,scl.segment9 add_sr_tax
79: FROM per_all_assignments_f asg
80: ,hr_soft_coding_keyflex scl
81: WHERE asg.assignment_id = p_assignment_id
82: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
83: AND p_effective_date
84: BETWEEN asg.effective_start_date AND asg.effective_end_date;

Line 320: ,hr_soft_coding_keyflex scl

316: CURSOR csr_get_spl_indicator_details (p_assignment_id NUMBER
317: ,p_effective_date DATE) IS
318: SELECT scl.segment10 special_indicator
319: FROM per_all_assignments_f asg
320: ,hr_soft_coding_keyflex scl
321: WHERE asg.assignment_id = p_assignment_id
322: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
323: AND p_effective_date
324: BETWEEN asg.effective_start_date AND asg.effective_end_date;

Line 456: ,hr_soft_coding_keyflex scl

452: ,scl.segment3 emp_sub_type
453: ,scl.segment21 commencing_from
454: ,scl.segment23 date_ending
455: FROM per_all_assignments_f asg
456: ,hr_soft_coding_keyflex scl
457: WHERE asg.assignment_id = p_assignment_id
458: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
459: AND p_effective_date
460: BETWEEN asg.effective_start_date AND asg.effective_end_date;

Line 835: ,hr_soft_coding_keyflex scl

831: ,p_effective_date DATE) IS
832: SELECT scl.segment21 commencing_date
833: ,scl.segment23 date_ending
834: FROM per_all_assignments_f asg
835: ,hr_soft_coding_keyflex scl
836: WHERE asg.assignment_id = p_assignment_id
837: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
838: AND p_effective_date
839: BETWEEN asg.effective_start_date AND asg.effective_end_date;