APPS.PAY_ZA_EOY_VAL dependencies on HR_SOFT_CODING_KEYFLEX

Line 377: hr_soft_coding_keyflex scl

373:
374: select count(*)
375: into v_count
376: from pay_all_payrolls_f pap,
377: hr_soft_coding_keyflex scl
378: where pap.business_group_id = (select pap2.business_group_id from pay_all_payrolls_f pap2 where pap2.payroll_id=p_payroll_id and rownum=1)
379: and pap.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
380: and scl.segment8 = p_irp5no
381: and to_date(v_tax_end_date,'DD-MM-YYYY') between pap.effective_start_date and pap.effective_end_date;