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_SSHR_UTILS_PKG dependencies on FND_DATE

Line 232: And to_number(to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')) = p_target_year

228: Is
229: Select 'Y'
230: From per_assignment_extra_info
231: Where assignment_id = p_assignment_id
232: And to_number(to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')) = p_target_year
233: And information_type in ('KR_YEA_SP_TAX_EXEM_INFO'
234: ,'KR_YEA_SP_TAX_EXEM_INFO2'
235: ,'KR_YEA_DETAIL_MEDICAL_EXP_INFO'
236: ,'KR_YEA_HOU_EXP_TAX_EXEM_INFO'

Line 366: l_effective_date := fnd_date.canonical_to_date(p_effective_date);

362: --
363: if p_effective_date is null then
364: l_effective_date := to_date('31/12/'||to_char(p_target_year), 'DD/MM/YYYY');
365: else
366: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
367: end if;
368: --
369: -- Bug 4915940: Setting profiles PER_PERSON_ID and PER_ASSIGNMENT_ID
370:

Line 407: and to_number(to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')) = p_target_year

403:
404:
405: delete from per_assignment_extra_info
406: where assignment_id = p_assignment_id
407: and to_number(to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')) = p_target_year
408: And information_type in ('KR_YEA_SP_TAX_EXEM_INFO'
409: ,'KR_YEA_SP_TAX_EXEM_INFO2'
410: ,'KR_YEA_DETAIL_MEDICAL_EXP_INFO'
411: ,'KR_YEA_HOU_EXP_TAX_EXEM_INFO'

Line 562: select min(fnd_date.canonical_to_date(hoi.org_information2)),

558: -- cursor fetches the entry periods of the organizations defined in the hierarchy
559: -- in bottom to top order starting from the Employee's Organization.
560: cursor csr_hierarchy_entry_period(p_version in number,
561: p_emp_org_id in number) is
562: select min(fnd_date.canonical_to_date(hoi.org_information2)),
563: max(fnd_date.canonical_to_date(hoi.org_information3)),
564: max(fnd_date.canonical_to_date(hoi.org_information4))
565: from (select pose.organization_id_parent,
566: level hierarchy_level,

Line 563: max(fnd_date.canonical_to_date(hoi.org_information3)),

559: -- in bottom to top order starting from the Employee's Organization.
560: cursor csr_hierarchy_entry_period(p_version in number,
561: p_emp_org_id in number) is
562: select min(fnd_date.canonical_to_date(hoi.org_information2)),
563: max(fnd_date.canonical_to_date(hoi.org_information3)),
564: max(fnd_date.canonical_to_date(hoi.org_information4))
565: from (select pose.organization_id_parent,
566: level hierarchy_level,
567: pose.organization_id_child

Line 564: max(fnd_date.canonical_to_date(hoi.org_information4))

560: cursor csr_hierarchy_entry_period(p_version in number,
561: p_emp_org_id in number) is
562: select min(fnd_date.canonical_to_date(hoi.org_information2)),
563: max(fnd_date.canonical_to_date(hoi.org_information3)),
564: max(fnd_date.canonical_to_date(hoi.org_information4))
565: from (select pose.organization_id_parent,
566: level hierarchy_level,
567: pose.organization_id_child
568: from per_org_structure_elements pose

Line 582: select min(fnd_date.canonical_to_date(hoi.org_information2)),

578: order by org.hierarchy_level asc;
579:
580: -- cursor fetches the Entry Period defined in BG level
581: cursor csr_bg_entry_period is
582: select min(fnd_date.canonical_to_date(hoi.org_information2)),
583: max(fnd_date.canonical_to_date(hoi.org_information3)),
584: max(fnd_date.canonical_to_date(hoi.org_information4))
585: from hr_organization_information hoi
586: where hoi.organization_id = p_business_group_id

Line 583: max(fnd_date.canonical_to_date(hoi.org_information3)),

579:
580: -- cursor fetches the Entry Period defined in BG level
581: cursor csr_bg_entry_period is
582: select min(fnd_date.canonical_to_date(hoi.org_information2)),
583: max(fnd_date.canonical_to_date(hoi.org_information3)),
584: max(fnd_date.canonical_to_date(hoi.org_information4))
585: from hr_organization_information hoi
586: where hoi.organization_id = p_business_group_id
587: and hoi.org_information1 = p_target_year

Line 584: max(fnd_date.canonical_to_date(hoi.org_information4))

580: -- cursor fetches the Entry Period defined in BG level
581: cursor csr_bg_entry_period is
582: select min(fnd_date.canonical_to_date(hoi.org_information2)),
583: max(fnd_date.canonical_to_date(hoi.org_information3)),
584: max(fnd_date.canonical_to_date(hoi.org_information4))
585: from hr_organization_information hoi
586: where hoi.organization_id = p_business_group_id
587: and hoi.org_information1 = p_target_year
588: and hoi.org_information_context ='KR_YEA_ENTRY_PERIOD_BG';

Line 592: select min(fnd_date.canonical_to_date(hoi.org_information2)),

588: and hoi.org_information_context ='KR_YEA_ENTRY_PERIOD_BG';
589:
590: -- cursor fetches the Entry Period defined in Employee's Org level
591: cursor csr_emp_org_entry_period (p_emp_org number) is
592: select min(fnd_date.canonical_to_date(hoi.org_information2)),
593: max(fnd_date.canonical_to_date(hoi.org_information3)),
594: max(fnd_date.canonical_to_date(hoi.org_information4))
595: from hr_organization_information hoi
596: where hoi.organization_id = p_emp_org

Line 593: max(fnd_date.canonical_to_date(hoi.org_information3)),

589:
590: -- cursor fetches the Entry Period defined in Employee's Org level
591: cursor csr_emp_org_entry_period (p_emp_org number) is
592: select min(fnd_date.canonical_to_date(hoi.org_information2)),
593: max(fnd_date.canonical_to_date(hoi.org_information3)),
594: max(fnd_date.canonical_to_date(hoi.org_information4))
595: from hr_organization_information hoi
596: where hoi.organization_id = p_emp_org
597: and hoi.org_information1 = p_target_year

Line 594: max(fnd_date.canonical_to_date(hoi.org_information4))

590: -- cursor fetches the Entry Period defined in Employee's Org level
591: cursor csr_emp_org_entry_period (p_emp_org number) is
592: select min(fnd_date.canonical_to_date(hoi.org_information2)),
593: max(fnd_date.canonical_to_date(hoi.org_information3)),
594: max(fnd_date.canonical_to_date(hoi.org_information4))
595: from hr_organization_information hoi
596: where hoi.organization_id = p_emp_org
597: and hoi.org_information1 = p_target_year
598: and hoi.org_information_context ='KR_YEA_ENTRY_PERIOD_ORG';

Line 889: l_effective_date := fnd_date.canonical_to_date(p_effective_date);

885: begin
886: P_RETURN_STATUS := 'E';
887: P_FF_RETURN_STATUS := 'INVALID';
888:
889: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
890: l_year := to_char(l_effective_date,'yyyy');
891: l_assignment_id := p_assignment_id;
892:
893: OPEN csr_formula_exists('VALIDATE_YEA_DATA',l_effective_date); -- 4644132

Line 1214: eff_date := fnd_date.canonical_to_date(P_EFFECTIVE_DATE);

1210: eff_date date ;
1211: l_def_bal_id pay_defined_balances.defined_balance_id%type ;
1212: --
1213: begin
1214: eff_date := fnd_date.canonical_to_date(P_EFFECTIVE_DATE);
1215: --
1216: P_ITAX := get_total_itax(P_ASSIGNMENT_ID, eff_date);
1217: P_STAX := get_total_stax(P_ASSIGNMENT_ID, eff_date);
1218: P_RTAX := get_total_rtax(P_ASSIGNMENT_ID, eff_date);

Line 1226: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;

1222: open csr_get_def_bal_id_ytd('HI_PREM_EE') ;
1223: fetch csr_get_def_bal_id_ytd into l_def_bal_id ;
1224: if csr_get_def_bal_id_ytd%found then
1225: p_hi_prem_ee := pay_balance_pkg.get_value(l_def_bal_id,
1226: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;
1227: end if ;
1228: close csr_get_def_bal_id_ytd ;
1229: --
1230: -- Bug 7260606

Line 1235: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;

1231: open csr_get_def_bal_id_ytd('LTCI_PREM_EE') ;
1232: fetch csr_get_def_bal_id_ytd into l_def_bal_id ;
1233: if csr_get_def_bal_id_ytd%found then
1234: p_ltci_prem_ee := pay_balance_pkg.get_value(l_def_bal_id,
1235: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;
1236: end if ;
1237: close csr_get_def_bal_id_ytd ;
1238: -- End of Bug 7260606
1239: --

Line 1244: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;

1240: open csr_get_def_bal_id_ytd('EI_PREM') ;
1241: fetch csr_get_def_bal_id_ytd into l_def_bal_id ;
1242: if csr_get_def_bal_id_ytd%found then
1243: p_ei_prem := pay_balance_pkg.get_value(l_def_bal_id,
1244: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;
1245: end if ;
1246: close csr_get_def_bal_id_ytd ;
1247: --
1248: open csr_get_def_bal_id_ytd('NP_PREM_EE') ;

Line 1252: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;

1248: open csr_get_def_bal_id_ytd('NP_PREM_EE') ;
1249: fetch csr_get_def_bal_id_ytd into l_def_bal_id ;
1250: if csr_get_def_bal_id_ytd%found then
1251: p_np_prem_ee := pay_balance_pkg.get_value(l_def_bal_id,
1252: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;
1253: end if ;
1254: close csr_get_def_bal_id_ytd ;
1255: --
1256: -- Bug 6024342

Line 1261: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;

1257: open csr_get_def_bal_id_ytd('Pension Premium') ;
1258: fetch csr_get_def_bal_id_ytd into l_def_bal_id ;
1259: if csr_get_def_bal_id_ytd%found then
1260: p_pen_prem_bal := pay_balance_pkg.get_value(l_def_bal_id,
1261: p_assignment_id, fnd_date.canonical_to_date(p_effective_date) ) ;
1262: end if ;
1263: close csr_get_def_bal_id_ytd ;
1264: --
1265: end get_balances;

Line 1276: and to_number(to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')) = p_target_year

1272: is
1273: begin
1274: delete from per_assignment_extra_info
1275: where assignment_id = p_assignment_id
1276: and to_number(to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')) = p_target_year
1277: And information_type in ('KR_YEA_SP_TAX_EXEM_INFO'
1278: ,'KR_YEA_SP_TAX_EXEM_INFO2'
1279: ,'KR_YEA_DETAIL_MEDICAL_EXP_INFO'
1280: ,'KR_YEA_HOU_EXP_TAX_EXEM_INFO'

Line 1355: OPEN csr_get_non_resident_flag(to_number(P_ASSIGNMENT_ID),fnd_date.canonical_to_date(P_EFFECTIVE_DATE));

1351: and pei.person_id = paf.person_id
1352: and information_type = 'PER_KR_RELATED_YEA_INFORMATION';
1353:
1354: begin
1355: OPEN csr_get_non_resident_flag(to_number(P_ASSIGNMENT_ID),fnd_date.canonical_to_date(P_EFFECTIVE_DATE));
1356: FETCH csr_get_non_resident_flag into l_nonresident_flag;
1357: CLOSE csr_get_non_resident_flag;
1358: --
1359:

Line 1361: open csr_house_holder(p_assignment_id, fnd_date.canonical_to_date(p_effective_date));

1357: CLOSE csr_get_non_resident_flag;
1358: --
1359:
1360: p_house_holder_code := null;
1361: open csr_house_holder(p_assignment_id, fnd_date.canonical_to_date(p_effective_date));
1362: fetch csr_house_holder into p_house_holder_code;
1363: close csr_house_holder;
1364:
1365: if p_house_holder_code is null then

Line 1374: p_date_earned => fnd_date.canonical_to_date(P_EFFECTIVE_DATE),

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,
1377: p_num_of_aged_dpnts => l_aged_dependents,
1378: p_num_of_adult_dpnts => l_adult_dependents,