DBA Data[Home] [Help]

APPS.PAY_KR_YEA_SSHR_UTILS_PKG dependencies on PAY_KR_FF_FUNCTIONS_PKG

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

1202: and ppa.payroll_action_id = paa.payroll_action_id
1203: and ppa.action_type = 'B'
1204: and ppa.action_status = 'C'
1205: and trunc(ppa.effective_date, 'YYYY') = trunc(p_effective_date, 'YYYY')
1206: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_TYPE', null) = 'YEA'
1207: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_QUALIFIER', null) = 'KR'
1208: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_CATEGORY', null) IN ('N','I');
1209:
1210: -- Cursor to get Org Structure version id of the Primary Hierarchy of the BG

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

1203: and ppa.action_type = 'B'
1204: and ppa.action_status = 'C'
1205: and trunc(ppa.effective_date, 'YYYY') = trunc(p_effective_date, 'YYYY')
1206: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_TYPE', null) = 'YEA'
1207: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_QUALIFIER', null) = 'KR'
1208: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_CATEGORY', null) IN ('N','I');
1209:
1210: -- Cursor to get Org Structure version id of the Primary Hierarchy of the BG
1211: cursor csr_org_struct_version is

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

1204: and ppa.action_status = 'C'
1205: and trunc(ppa.effective_date, 'YYYY') = trunc(p_effective_date, 'YYYY')
1206: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_TYPE', null) = 'YEA'
1207: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_QUALIFIER', null) = 'KR'
1208: and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_CATEGORY', null) IN ('N','I');
1209:
1210: -- Cursor to get Org Structure version id of the Primary Hierarchy of the BG
1211: cursor csr_org_struct_version is
1212: select posv.org_structure_version_id

Line 2125: pay_kr_ff_functions_pkg.get_dependent_info(

2121:
2122: p_house_holder := hr_general.decode_lookup('YES_NO', p_house_holder_code);
2123:
2124: l_return_code :=
2125: pay_kr_ff_functions_pkg.get_dependent_info(
2126: p_assignment_id => to_number(P_ASSIGNMENT_ID),
2127: p_date_earned => final_eff_date, -- Bug 9246066
2128: p_non_resident_flag => l_nonresident_flag,
2129: p_dpnt_spouse_flag => l_spouse_exem,

Line 2224: p_result := pay_kr_ff_functions_pkg.enable_credit_card(

2220: p_result out nocopy varchar2)
2221: is
2222: begin
2223:
2224: p_result := pay_kr_ff_functions_pkg.enable_credit_card(
2225: p_person_id,
2226: p_contact_person_id,
2227: p_contact_relationship_id,
2228: to_date(p_date_earned,'YYYY-MM-DD'));

Line 2243: p_result := pay_kr_ff_functions_pkg.enable_donation_fields(

2239: p_result out nocopy varchar2)
2240: is
2241: begin
2242:
2243: p_result := pay_kr_ff_functions_pkg.enable_donation_fields(
2244: p_person_id,
2245: p_contact_person_id,
2246: p_contact_relationship_id,
2247: to_date(p_date_earned,'YYYY-MM-DD'));

Line 2257: p_result := pay_kr_ff_functions_pkg.validate_bus_reg_num(

2253: p_national_identifier in varchar2,
2254: p_result out nocopy varchar2)
2255: is
2256: begin
2257: p_result := pay_kr_ff_functions_pkg.validate_bus_reg_num(
2258: p_national_identifier);
2259:
2260: end;
2261: ------------------------------------------------------------------------------------

Line 2342: select pay_kr_ff_functions_pkg.aged_flag(p_national_identifier,fnd_date.canonical_to_date(p_effective_date))

2338: p_result out nocopy varchar2)
2339: is
2340:
2341: cursor csr is
2342: select pay_kr_ff_functions_pkg.aged_flag(p_national_identifier,fnd_date.canonical_to_date(p_effective_date))
2343: from dual;
2344:
2345: begin
2346:

Line 2410: p_result := pay_kr_ff_functions_pkg.get_globalvalue(p_glbvar,fnd_date.canonical_to_date(p_process_date));

2406: p_process_date in varchar2,
2407: p_result out nocopy varchar2)
2408: is
2409: begin
2410: p_result := pay_kr_ff_functions_pkg.get_globalvalue(p_glbvar,fnd_date.canonical_to_date(p_process_date));
2411:
2412: end;
2413: --------------------------------------------------------------------------------------
2414: --

Line 2508: and (pay_kr_ff_functions_pkg.display_yea_info(p_assignment_id,

2504: 1);
2505: end if;
2506: else
2507: if((i.aei_information2 = p_target_year)
2508: and (pay_kr_ff_functions_pkg.display_yea_info(p_assignment_id,
2509: fnd_date.canonical_to_date(i.aei_information1)) = 'Y')) then
2510: update per_kr_assignment_yea_info
2511: set ayi_information4 = i.aei_information4,
2512: ayi_information11 = i.aei_information11,

Line 2704: p_result := pay_kr_ff_functions_pkg.display_yea_info(to_number(p_assignment_id),to_date('31-12-'||p_target_year,'DD-MM-YYYY'));

2700: p_target_year in varchar2,
2701: p_result out nocopy varchar2)
2702: is
2703: begin
2704: p_result := pay_kr_ff_functions_pkg.display_yea_info(to_number(p_assignment_id),to_date('31-12-'||p_target_year,'DD-MM-YYYY'));
2705: end;
2706: --------------------------------------------------------------------------------------
2707: -- Bug 9393732
2708: --------------------------------------------------------------------------------------