eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_KR_YEA_PKG dependencies on PAY_KR_FF_FUNCTIONS_PKG

Line 3096: and pay_kr_ff_functions_pkg.is_exempted_dependent( pkc.contact_type,

3092: and p_effective_date between cont_start_date and cont_end_date
3093: and p_effective_date between nvl(ADDRESS_START_DATE,p_effective_date) and nvl(ADDRESS_END_DATE, p_effective_date)
3094: and p_effective_date between nvl(pkc.date_start, p_effective_date)
3095: 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) )
3096: and pay_kr_ff_functions_pkg.is_exempted_dependent( pkc.contact_type,
3097: pkc.cont_information11, -- Bug 7661820
3098: pkc.national_identifier,
3099: pkc.cont_information2,
3100: pkc.cont_information3,

Line 3121: decode(pay_kr_ff_functions_pkg.aged_flag(aei_information8, fnd_date.canonical_to_date(to_char(p_effective_date, 'YYYY')||'/12/31')),'Y', (nvl(aei_information3,0) + nvl(aei_information11,0)),0

3117: -- Bug 9079450: The medical expense exemption for aged dependents
3118: -- will be given if age is 65 or older.
3119: ,nvl(sum(decode(aei_information7,0,0,decode(aei_information9,'B',
3120: decode(sign(to_char(p_effective_date, 'YYYY')-2008),1,
3121: decode(pay_kr_ff_functions_pkg.aged_flag(aei_information8, fnd_date.canonical_to_date(to_char(p_effective_date, 'YYYY')||'/12/31')),'Y', (nvl(aei_information3,0) + nvl(aei_information11,0)),0
3122: ),(nvl(aei_information3,0) + nvl(aei_information11,0))
3123: )
3124: )
3125: )

Line 3546: and pay_kr_ff_functions_pkg.is_exempted_dependent( pkc.contact_type,

3542: and p_effective_date between cont_start_date and cont_end_date
3543: and p_effective_date between nvl(ADDRESS_START_DATE,p_effective_date) and nvl(ADDRESS_END_DATE, p_effective_date)
3544: and p_effective_date between nvl(pkc.date_start, p_effective_date)
3545: 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) )
3546: and pay_kr_ff_functions_pkg.is_exempted_dependent( pkc.contact_type,
3547: pkc.cont_information11, -- Bug 7661820
3548: pkc.national_identifier,
3549: pkc.cont_information2,
3550: pkc.cont_information3,

Line 4120: -- Bug 3172960 Calling pay_kr_ff_functions_pkg for nationality

4116: hr_utility.set_location('pay_kr_yea_pkg.yea_info.',15);
4117: end if;
4118: ------------------------------------------------------------------------
4119: -- Bug 3201332 Derive Nationality from national identifier
4120: -- Bug 3172960 Calling pay_kr_ff_functions_pkg for nationality
4121: -- Bug 6615356 Modified logic for Korean/Foreigner
4122: ------------------------------------------------------------------------
4123: if (pay_kr_ff_functions_pkg.ni_nationality(p_assignment_id, p_effective_date) = 'F' or p_yea_info.foreign_residency_flag = 'Y') then
4124: p_yea_info.nationality := 'F';

Line 4123: if (pay_kr_ff_functions_pkg.ni_nationality(p_assignment_id, p_effective_date) = 'F' or p_yea_info.foreign_residency_flag = 'Y') then

4119: -- Bug 3201332 Derive Nationality from national identifier
4120: -- Bug 3172960 Calling pay_kr_ff_functions_pkg for nationality
4121: -- Bug 6615356 Modified logic for Korean/Foreigner
4122: ------------------------------------------------------------------------
4123: if (pay_kr_ff_functions_pkg.ni_nationality(p_assignment_id, p_effective_date) = 'F' or p_yea_info.foreign_residency_flag = 'Y') then
4124: p_yea_info.nationality := 'F';
4125: else
4126: p_yea_info.nationality := 'K';
4127: end if;

Line 4333: l_dummy := pay_kr_ff_functions_pkg.get_dependent_info(

4329: if g_debug then
4330: hr_utility.set_location('pay_kr_yea_pkg.yea_info.',40);
4331: end if;
4332: --
4333: l_dummy := pay_kr_ff_functions_pkg.get_dependent_info(
4334: p_assignment_id => p_assignment_id,
4335: p_date_earned => p_effective_date,
4336: p_non_resident_flag => p_yea_info.non_resident_flag,
4337: p_dpnt_spouse_flag => p_yea_info.dpnt_spouse_flag,

Line 5632: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_TYPE', null) = 'YEA'

5628: and ppa.payroll_id = p_payroll_id -- Bug 5045110
5629: and paa.assignment_action_id <> p_bal_asg_action_id
5630: and paa.source_action_id is null
5631: and ppa.action_type = 'B'
5632: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_TYPE', null) = 'YEA'
5633: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_QUALIFIER', null) = 'KR'
5634: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_CATEGORY', null) IN ('N','I')
5635: and ppa.effective_date between trunc(p_effective_date, 'YYYY')
5636: and (trunc(add_months(p_effective_date, 12), 'YYYY') - 1) -- Bug 5045110

Line 5633: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_QUALIFIER', null) = 'KR'

5629: and paa.assignment_action_id <> p_bal_asg_action_id
5630: and paa.source_action_id is null
5631: and ppa.action_type = 'B'
5632: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_TYPE', null) = 'YEA'
5633: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_QUALIFIER', null) = 'KR'
5634: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_CATEGORY', null) IN ('N','I')
5635: and ppa.effective_date between trunc(p_effective_date, 'YYYY')
5636: and (trunc(add_months(p_effective_date, 12), 'YYYY') - 1) -- Bug 5045110
5637: order by paa.action_sequence desc;

Line 5634: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_CATEGORY', null) IN ('N','I')

5630: and paa.source_action_id is null
5631: and ppa.action_type = 'B'
5632: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_TYPE', null) = 'YEA'
5633: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_QUALIFIER', null) = 'KR'
5634: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_CATEGORY', null) IN ('N','I')
5635: and ppa.effective_date between trunc(p_effective_date, 'YYYY')
5636: and (trunc(add_months(p_effective_date, 12), 'YYYY') - 1) -- Bug 5045110
5637: order by paa.action_sequence desc;
5638:

Line 6028: select pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_CATEGORY', null) report_category

6024: l_return number;
6025: ------------------------------------------------------------------------------
6026: cursor csr_pact
6027: IS
6028: select pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_CATEGORY', null) report_category
6029: ,ppa.element_type_id element_type_id
6030: ,ppa.payroll_id payroll_id
6031: from pay_payroll_actions ppa
6032: where ppa.payroll_action_id = p_payroll_action_id;