DBA Data[Home] [Help]

APPS.PAY_KR_YEA_SSHR_UTILS_PKG dependencies on PAY_KR_FF_FUNCTIONS_PKG

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

540: and ppa.payroll_action_id = paa.payroll_action_id
541: and ppa.action_type = 'B'
542: and ppa.action_status = 'C'
543: and trunc(ppa.effective_date, 'YYYY') = trunc(p_effective_date, 'YYYY')
544: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_TYPE', null) = 'YEA'
545: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_QUALIFIER', null) = 'KR'
546: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_CATEGORY', null) IN ('N','I');
547:
548: -- Cursor to get Org Structure version id of the Primary Hierarchy of the BG

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

541: and ppa.action_type = 'B'
542: and ppa.action_status = 'C'
543: and trunc(ppa.effective_date, 'YYYY') = trunc(p_effective_date, 'YYYY')
544: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_TYPE', null) = 'YEA'
545: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_QUALIFIER', null) = 'KR'
546: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_CATEGORY', null) IN ('N','I');
547:
548: -- Cursor to get Org Structure version id of the Primary Hierarchy of the BG
549: cursor csr_org_struct_version is

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

542: and ppa.action_status = 'C'
543: and trunc(ppa.effective_date, 'YYYY') = trunc(p_effective_date, 'YYYY')
544: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_TYPE', null) = 'YEA'
545: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_QUALIFIER', null) = 'KR'
546: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_CATEGORY', null) IN ('N','I');
547:
548: -- Cursor to get Org Structure version id of the Primary Hierarchy of the BG
549: cursor csr_org_struct_version is
550: select posv.org_structure_version_id

Line 1372: pay_kr_ff_functions_pkg.get_dependent_info(

1368:
1369: p_house_holder := hr_general.decode_lookup('YES_NO', p_house_holder_code);
1370:
1371: l_return_code :=
1372: pay_kr_ff_functions_pkg.get_dependent_info(
1373: p_assignment_id => to_number(P_ASSIGNMENT_ID),
1374: p_date_earned => fnd_date.canonical_to_date(P_EFFECTIVE_DATE),
1375: p_non_resident_flag => l_nonresident_flag,
1376: p_dpnt_spouse_flag => l_spouse_exem,

Line 1471: p_result := pay_kr_ff_functions_pkg.enable_credit_card(

1467: p_result out nocopy varchar2)
1468: is
1469: begin
1470:
1471: p_result := pay_kr_ff_functions_pkg.enable_credit_card(
1472: p_person_id,
1473: p_contact_person_id,
1474: p_contact_relationship_id,
1475: to_date(p_date_earned,'YYYY-MM-DD'));