DBA Data[Home] [Help]

APPS.PAY_NO_EMP_CONT_2007 dependencies on HR_SOFT_CODING_KEYFLEX

Line 115: ,hr_soft_coding_keyflex scl

111: SELECT scl.segment2 local_unit_id
112: ,rr.jurisdiction_code tax_mun_id
113: FROM pay_assignment_actions assact
114: ,per_all_assignments_f asg
115: ,hr_soft_coding_keyflex scl
116: ,pay_run_results rr
117: WHERE assact.assignment_action_id = l_assignment_action_id
118: AND assact.assignment_id = asg.assignment_id
119: AND asg.assignment_id = l_assignment_id

Line 137: ,hr_soft_coding_keyflex scl

133: SELECT scl.segment2 loc_unit , assact.tax_unit_id leg_emp
134: FROM pay_assignment_actions assact
135: ,pay_run_types_f prt
136: ,per_all_assignments_f asg
137: ,hr_soft_coding_keyflex scl
138: WHERE assact.PAYROLL_ACTION_ID = p_payroll_action_id
139: and prt.LEGISLATION_CODE = 'NO'
140: and prt.RUN_TYPE_NAME = 'Employer Contributions'
141: and nvl(assact.RUN_TYPE_ID,-99) <> prt.RUN_TYPE_ID