[Home] [Help]
145: IS
146: SELECT org.org_information1 employers_ref_no, org.org_information2 tax_office_name,
147: org.org_information8 tax_office_phone_no, org.org_information3 employer_name,
148: org.org_information4 employer_address
149: FROM pay_payrolls_f ppf, hr_soft_coding_keyflex flex, hr_organization_information org
150: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
151: AND fnd_date.canonical_to_date(v_benefit_end_date)
152: BETWEEN NVL(flex.start_date_active, fnd_date.canonical_to_date(v_benefit_end_date) )
153: AND NVL(flex.end_date_active, fnd_date.canonical_to_date(v_benefit_end_date) )
211: cursor csr_check_asg is
212: select 1
213: from per_all_assignments_f asg,
214: pay_all_payrolls_f pay,
215: hr_soft_coding_keyflex flex
216: where asg.assignment_id = p_assignment_id
217: and asg.payroll_id = pay.payroll_id
218: and pay.soft_coding_keyflex_id + 0 = flex.soft_coding_keyflex_id
219: and (p_tax_ref is null
528: --bug 6278134 removed parameter l_tax_reference from cursor csr_flex_id
529: -- bug 7122883 removed the below cursor
530: /* cursor csr_flex_id is
531: select distinct flex.soft_coding_keyflex_id flex_id
532: from hr_soft_coding_keyflex flex,
533: --bug 6278134 added join conditions with ppf
534: pay_all_payrolls_f ppf
535: where flex.segment1 = nvl(l_tax_reference,flex.segment1)
536: AND ppf.soft_coding_keyflex_id + 0 = flex.soft_coding_keyflex_id
590: -- and ppf.soft_coding_keyflex_id + 0 = p_flex_id
591: --bug 7122883 added the below join so as to fetch all the records in that tax refernce
592: and (l_tax_reference is null or
593: ppf.soft_coding_keyflex_id + 0 in (select distinct flex.soft_coding_keyflex_id flex_id
594: from hr_soft_coding_keyflex flex where flex.segment1 = l_tax_reference))
595: and pec.legislation_code = 'GB'
596: and pec.classification_name like 'EXTERNAL REPORTING%'
597: and pet.classification_id = pec.classification_id
598: and pet.element_type_id = piv.element_type_id
658: -- and ppf.soft_coding_keyflex_id + 0 = p_flex_id
659: --bug 7122883 added the below join so as to fetch all the records in that tax refernce
660: and (l_tax_reference is null or
661: ppf.soft_coding_keyflex_id + 0 in (select distinct flex.soft_coding_keyflex_id flex_id
662: from hr_soft_coding_keyflex flex where flex.segment1 = l_tax_reference))
663: and pec.legislation_code = 'GB'
664: and pec.classification_name like 'EXTERNAL REPORTING%'
665: and pet.classification_id = pec.classification_id
666: and pet.element_type_id = piv.element_type_id
716: -- and ppf.soft_coding_keyflex_id + 0 = p_flex_id
717: --bug 7122883 added the below join so as to fetch all the records in that tax refernce
718: and (l_tax_reference is null or
719: ppf.soft_coding_keyflex_id + 0 in (select distinct flex.soft_coding_keyflex_id flex_id
720: from hr_soft_coding_keyflex flex where flex.segment1 = l_tax_reference))
721: and pec.legislation_code = 'GB'
722: and pec.classification_name like 'EXTERNAL REPORTING%'
723: and pet.classification_id = pec.classification_id
724: and pet.element_type_id = piv.element_type_id
997: FROM per_all_assignments_f paa,
998: per_all_people_f pap,
999: per_periods_of_service pps,
1000: pay_all_payrolls_f pay,
1001: hr_soft_coding_keyflex flex
1002: WHERE paa.person_id = pap.person_id
1003: AND pps.PERIOD_OF_SERVICE_ID(+) = paa.PERIOD_OF_SERVICE_ID
1004: AND least(nvl(pps.ACTUAL_TERMINATION_DATE,fnd_date.canonical_to_date(g_param_benefit_end_date)),
1005: fnd_date.canonical_to_date(g_param_benefit_end_date))