[Home] [Help]
956: and p_effective_date between cont_start_date and cont_end_date
957: and p_effective_date between nvl(ADDRESS_START_DATE,p_effective_date) and nvl(ADDRESS_END_DATE, p_effective_date)
958: and p_effective_date between nvl(pkc.date_start, p_effective_date)
959: and decode(pkc.cont_information9, 'D', trunc(add_months(nvl(pkc.date_end, p_effective_date),12),'YYYY')-1, nvl(pkc.date_end, p_effective_date) )
960: and pay_kr_ff_functions_pkg.is_exempted_dependent( pkc.contact_type,
961: pkc.national_identifier,
962: pkc.cont_information2,
963: pkc.cont_information3,
964: pkc.cont_information4,
1224: and p_effective_date between cont_start_date and cont_end_date
1225: and p_effective_date between nvl(ADDRESS_START_DATE,p_effective_date) and nvl(ADDRESS_END_DATE, p_effective_date)
1226: and p_effective_date between nvl(pkc.date_start, p_effective_date)
1227: and decode(pkc.cont_information9, 'D', trunc(add_months(nvl(pkc.date_end, p_effective_date),12),'YYYY')-1, nvl(pkc.date_end, p_effective_date) )
1228: and pay_kr_ff_functions_pkg.is_exempted_dependent( pkc.contact_type,
1229: pkc.national_identifier,
1230: pkc.cont_information2,
1231: pkc.cont_information3,
1232: pkc.cont_information4,
1589: hr_utility.set_location('pay_kr_yea_pkg.yea_info.',15);
1590: end if;
1591: ------------------------------------------------------------------------
1592: -- Bug 3201332 Derive Nationality from national identifier
1593: -- Bug 3172960 Calling pay_kr_ff_functions_pkg for nationality
1594: -- Bug 6615356 Modified logic for Korean/Foreigner
1595: ------------------------------------------------------------------------
1596: if (pay_kr_ff_functions_pkg.ni_nationality(p_assignment_id, p_effective_date) = 'F' or p_yea_info.foreign_residency_flag = 'Y') then
1597: p_yea_info.nationality := 'F';
1592: -- Bug 3201332 Derive Nationality from national identifier
1593: -- Bug 3172960 Calling pay_kr_ff_functions_pkg for nationality
1594: -- Bug 6615356 Modified logic for Korean/Foreigner
1595: ------------------------------------------------------------------------
1596: if (pay_kr_ff_functions_pkg.ni_nationality(p_assignment_id, p_effective_date) = 'F' or p_yea_info.foreign_residency_flag = 'Y') then
1597: p_yea_info.nationality := 'F';
1598: else
1599: p_yea_info.nationality := 'K';
1600: end if;
1713: if g_debug then
1714: hr_utility.set_location('pay_kr_yea_pkg.yea_info.',40);
1715: end if;
1716: --
1717: l_dummy := pay_kr_ff_functions_pkg.get_dependent_info(
1718: p_assignment_id => p_assignment_id,
1719: p_date_earned => p_effective_date,
1720: p_non_resident_flag => p_yea_info.non_resident_flag,
1721: p_dpnt_spouse_flag => p_yea_info.dpnt_spouse_flag,
2276: and ppa.payroll_id = p_payroll_id -- Bug 5045110
2277: and paa.assignment_action_id <> p_bal_asg_action_id
2278: and paa.source_action_id is null
2279: and ppa.action_type = 'B'
2280: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_TYPE', null) = 'YEA'
2281: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_QUALIFIER', null) = 'KR'
2282: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_CATEGORY', null) IN ('N','I')
2283: and ppa.effective_date between trunc(p_effective_date, 'YYYY')
2284: and (trunc(add_months(p_effective_date, 12), 'YYYY') - 1) -- Bug 5045110
2277: and paa.assignment_action_id <> p_bal_asg_action_id
2278: and paa.source_action_id is null
2279: and ppa.action_type = 'B'
2280: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_TYPE', null) = 'YEA'
2281: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_QUALIFIER', null) = 'KR'
2282: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_CATEGORY', null) IN ('N','I')
2283: and ppa.effective_date between trunc(p_effective_date, 'YYYY')
2284: and (trunc(add_months(p_effective_date, 12), 'YYYY') - 1) -- Bug 5045110
2285: order by paa.action_sequence desc;
2278: and paa.source_action_id is null
2279: and ppa.action_type = 'B'
2280: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_TYPE', null) = 'YEA'
2281: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_QUALIFIER', null) = 'KR'
2282: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_CATEGORY', null) IN ('N','I')
2283: and ppa.effective_date between trunc(p_effective_date, 'YYYY')
2284: and (trunc(add_months(p_effective_date, 12), 'YYYY') - 1) -- Bug 5045110
2285: order by paa.action_sequence desc;
2286:
2672: l_return number;
2673: ------------------------------------------------------------------------------
2674: cursor csr_pact
2675: IS
2676: select pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_CATEGORY', null) report_category
2677: ,ppa.element_type_id element_type_id
2678: ,ppa.payroll_id payroll_id
2679: from pay_payroll_actions ppa
2680: where ppa.payroll_action_id = p_payroll_action_id;