APPS.PYUDET dependencies on PAY_ALL_PAYROLLS_F

Line 262: pay_all_payrolls_f pay,

258: assignment_number,
259: per_system_status asg_status,
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

Line 313: pay_all_payrolls_f pay

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;
317:

Line 324: pay_all_payrolls_f pay,

320: -----------------------------------------------------------------------------------------------
321: CURSOR get_cpe_flag(p_person_id number, p_paye_ref varchar2, p_date date ) IS
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

Line 1858: pay_all_payrolls_f pay,

1854: p_date date,
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

Line 1876: pay_all_payrolls_f pay,

1872: p_date date) is
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

Line 1889: pay_all_payrolls_f pay,

1885: and p_date between pay.effective_start_date and pay.effective_end_date
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