APPS.PAY_GB_EAS_SCOTLAND_FUNCTIONS dependencies on PAY_PAYROLLS_F

Line 79: pay_payrolls_f ppf,

75: CURSOR get_asg_tax_ref IS
76: SELECT scl.segment1
77: FROM hr_soft_coding_keyflex scl,
78: fnd_sessions fs,
79: pay_payrolls_f ppf,
80: per_all_assignments_f paaf
81: WHERE paaf.assignment_id = p_assignment_id
82: AND fs.session_id = userenv('sessionid')
83: AND fs.effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date

Line 204: pay_payrolls_f ppf,

200: CURSOR get_asg_tax_ref IS
201: SELECT scl.segment1, ppf.payroll_id
202: FROM hr_soft_coding_keyflex scl,
203: fnd_sessions fs,
204: pay_payrolls_f ppf,
205: per_all_assignments_f paaf
206: WHERE paaf.assignment_id = p_assignment_id
207: AND fs.session_id = userenv('sessionid')
208: AND fs.effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date

Line 214: l_asg_payroll_id pay_payrolls_f.payroll_id%TYPE;

210: AND fs.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_Date
211: AND ppf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id;
212: --
213: l_asg_tax_ref hr_soft_coding_keyflex.segment1%TYPE;
214: l_asg_payroll_id pay_payrolls_f.payroll_id%TYPE;
215: l_asg_period_start_date per_time_periods.start_date%TYPE;
216: --
217: CURSOR get_asg_period_start_date IS
218: SELECT ptp.start_date

Line 358: pay_payrolls_f ppf,

354: CURSOR get_asg_tax_ref IS
355: SELECT scl.segment1
356: FROM hr_soft_coding_keyflex scl,
357: fnd_sessions fs,
358: pay_payrolls_f ppf,
359: per_all_assignments_f paaf
360: WHERE paaf.assignment_id = p_assignment_id
361: AND fs.session_id = userenv('sessionid')
362: AND fs.effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date

Line 503: pay_payrolls_f ppf,

499: CURSOR get_asg_tax_ref IS
500: SELECT scl.segment1
501: FROM hr_soft_coding_keyflex scl,
502: fnd_sessions fs,
503: pay_payrolls_f ppf,
504: per_all_assignments_f paaf
505: WHERE paaf.assignment_id = p_assignment_id
506: AND fs.session_id = userenv('sessionid')
507: AND fs.effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date