DBA Data[Home] [Help]

APPS.PAY_NO_EMP_CONT dependencies on HR_SOFT_CODING_KEYFLEX

Line 146: ,hr_soft_coding_keyflex scl

142: ,p_date_earned DATE ) is
143: select scl.segment2 local_unit_id
144: ,rr.jurisdiction_code tax_mun_id
145: from per_all_assignments_f asg
146: ,hr_soft_coding_keyflex scl
147: ,pay_run_results rr
148: ,pay_element_types_f pet
149: where asg.assignment_id = l_assignment_id
150: and p_date_earned between asg.EFFECTIVE_START_DATE and asg.EFFECTIVE_END_DATE

Line 168: ,hr_soft_coding_keyflex scl

164: SELECT scl.segment2 local_unit_id
165: ,rr.jurisdiction_code tax_mun_id
166: FROM pay_assignment_actions assact
167: ,per_all_assignments_f asg
168: ,hr_soft_coding_keyflex scl
169: ,pay_run_results rr
170: WHERE assact.assignment_action_id = l_assignment_action_id
171: AND assact.assignment_id = asg.assignment_id
172: AND asg.assignment_id = l_assignment_id

Line 192: ,hr_soft_coding_keyflex scl

188: SELECT scl.segment2 loc_unit , assact.tax_unit_id leg_emp
189: FROM pay_assignment_actions assact
190: ,pay_run_types_f prt
191: ,per_all_assignments_f asg
192: ,hr_soft_coding_keyflex scl
193: WHERE assact.PAYROLL_ACTION_ID = p_payroll_action_id
194: and prt.LEGISLATION_CODE = 'NO'
195: and prt.RUN_TYPE_NAME = 'Employer Contributions'
196: and nvl(assact.RUN_TYPE_ID,-99) <> prt.RUN_TYPE_ID