APPS.PAY_GB_RTI_P60 dependencies on PAY_ALL_PAYROLLS_F

Line 223: FROM pay_all_payrolls_f p,

219: flex.segment1 emp_paye_ref,
220: substr(org.org_information2 ,1,40) tax_district_name,
221: substr(ltrim(org.org_information3),1,36) employers_name,
222: substr(ltrim(org.org_information4),1,60) employers_address_line
223: FROM pay_all_payrolls_f p,
224: hr_soft_coding_keyflex flex,
225: hr_organization_information org
226: WHERE p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
227: AND org.org_information_context = 'Tax Details References'

Line 679: pay_all_payrolls_f papf,

675: SELECT min(paaf.effective_start_date) min_active,
676: max(paaf.effective_end_date) max_active
677: FROM per_all_assignments_f paaf,
678: per_assignment_status_types past,
679: pay_all_payrolls_f papf,
680: hr_soft_coding_keyflex flex
681: WHERE paaf.assignment_id = p_asg_id
682: AND paaf.assignment_status_type_id = past.assignment_status_type_id
683: AND past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')

Line 3086: FROM pay_all_payrolls_f p,

3082: substr(ltrim(org.org_information3),1,36) employers_name, -- 4011263: added ltrim
3083: substr(ltrim(org.org_information4),1,60) employers_address_line, -- 4011263: added ltrim
3084: substr(nvl(flex.segment14,org.org_information7),1,9) econ
3085:
3086: FROM pay_all_payrolls_f p,
3087: hr_soft_coding_keyflex flex,
3088: hr_organization_information org
3089: WHERE p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
3090: AND org.org_information_context = 'Tax Details References'

Line 3099: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;

3095: AND org.organization_id = p_bg_id
3096: AND p_end_year BETWEEN p.effective_start_date
3097: AND p.effective_end_date;
3098: --
3099: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
3100: --
3101: -- cursor to find a different PAYE Ref within a tax year on a given payroll
3102: CURSOR csr_another_paye_ref(p_payroll_id NUMBER,
3103: p_end_year DATE,

Line 3106: FROM pay_all_payrolls_f p,

3102: CURSOR csr_another_paye_ref(p_payroll_id NUMBER,
3103: p_end_year DATE,
3104: p_paye_ref VARCHAR2) IS
3105: SELECT flex.segment1
3106: FROM pay_all_payrolls_f p,
3107: hr_soft_coding_keyflex flex
3108: WHERE p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id(+)
3109: AND p.payroll_id = p_payroll_id
3110: AND p.effective_start_date <= hr_gbbal.span_end(p_end_year)

Line 3273: pay_all_payrolls_f papf,

3269: pap.person_id
3270: from per_all_people_f pap,
3271: per_all_assignments_f paaf,
3272: per_assignment_status_types past,
3273: pay_all_payrolls_f papf,
3274: hr_soft_coding_keyflex flex
3275: where pap.person_id between stperson and endperson
3276: and pap.person_id = paaf.person_id
3277: and paaf.assignment_type = 'E'