APPS.PYUDET dependencies on HR_SOFT_CODING_KEYFLEX

Line 264: hr_soft_coding_keyflex sck

260: sck.segment1 tax_ref
261: from per_all_assignments_f asg,
262: pay_all_payrolls_f pay,
263: per_assignment_status_types pat,
264: hr_soft_coding_keyflex sck
265: where asg.person_id = p_person_id
266: and ( -- no need to fetch payroll, but do check the tax ref
267: (p_aggr_flag = 'Y' and
268: ((g_payroll_id is not null and sck.segment1 = g_tax_ref)

Line 312: from hr_soft_coding_keyflex sck,

308: -- This cursor returns tax ref id based on the payroll --
309: ---------------------------------------------------------
310: cursor get_payroll_details IS
311: select sck.segment1, payroll_name
312: from hr_soft_coding_keyflex sck,
313: pay_all_payrolls_f pay
314: where sck.soft_coding_keyflex_id = pay.soft_coding_keyflex_id
315: and pay.payroll_id = g_payroll_id
316: and g_effective_date between pay.effective_start_date and pay.effective_end_date;

Line 326: hr_soft_coding_keyflex sck

322: select assignment_id
323: from per_all_assignments_f asg,
324: pay_all_payrolls_f pay,
325: per_assignment_status_types pat,
326: hr_soft_coding_keyflex sck
327: where asg.person_id = p_person_id
328: and sck.segment1 = p_paye_ref
329: and asg.payroll_id = pay.payroll_id
330: and sck.soft_coding_keyflex_id = pay.soft_coding_keyflex_id

Line 1859: hr_soft_coding_keyflex sck

1855: p_asg_no varchar2 default null) is
1856: select count(*)
1857: from per_all_assignments_f asg,
1858: pay_all_payrolls_f pay,
1859: hr_soft_coding_keyflex sck
1860: where asg.person_id = p_person_id
1861: and asg.payroll_id = pay.payroll_id
1862: and pay.soft_coding_keyflex_id = sck.soft_coding_keyflex_id
1863: and sck.segment1 = p_tax_district

Line 1877: hr_soft_coding_keyflex sck

1873: select count(*)
1874: from per_all_people_f peo,
1875: per_all_assignments_f asg,
1876: pay_all_payrolls_f pay,
1877: hr_soft_coding_keyflex sck
1878: where peo.person_id = p_person_id
1879: and asg.person_id = peo.person_id
1880: and asg.payroll_id = pay.payroll_id
1881: and pay.soft_coding_keyflex_id = sck.soft_coding_keyflex_id

Line 1890: hr_soft_coding_keyflex sck

1886: and asg.effective_start_date between peo.effective_start_date and peo.effective_end_date
1887: and asg.assignment_id not in (select assignment_id
1888: from per_all_assignments_f asg,
1889: pay_all_payrolls_f pay,
1890: hr_soft_coding_keyflex sck
1891: where asg.person_id = p_person_id
1892: and asg.payroll_id = pay.payroll_id
1893: and pay.soft_coding_keyflex_id = sck.soft_coding_keyflex_id
1894: and sck.segment1 = p_tax_district