APPS.PAY_HK_EXC dependencies on FND_NUMBER

Line 281: SELECT to_date('01-04-'||to_char(fnd_number.canonical_to_number(

277: ELSIF p_dimension_name like '%MPF_QTD' THEN
278: l_expiry_date := next_ri_quarter(p_owner_payroll_action_id);
279:
280: ELSIF p_dimension_name like '%MPF_YTD' THEN
281: SELECT to_date('01-04-'||to_char(fnd_number.canonical_to_number(
282: to_char(PACT.date_earned,'YYYY'))+ decode(sign(PACT.date_earned
283: - to_date('01-04-'||to_char(PACT.date_earned,'YYYY'),'DD-MM-YYYY'))
284: ,-1,0,1)),'DD-MM-YYYY')
285: INTO l_expiry_date

Line 327: SELECT to_date('01-04-'||to_char(fnd_number.canonical_to_number(

323: ELSIF p_dimension_name like '%QTD' THEN
324: l_expiry_date := next_quarter(p_owner_effective_date);
325:
326: ELSIF p_dimension_name like '%YTD' THEN
327: SELECT to_date('01-04-'||to_char(fnd_number.canonical_to_number(
328: to_char(PACT.effective_date,'YYYY'))+ decode(sign(PACT.effective_date
329: - to_date('01-04-'||to_char(PACT.effective_date,'YYYY'),'DD-MM-YYYY'))
330: ,-1,0,1)),'DD-MM-YYYY')
331: INTO l_expiry_date

Line 410: SELECT to_date('01-04-'||to_char(fnd_number.canonical_to_number(

406: ELSIF l_dimension_name like '%MPF_QTD' THEN
407: RETURN next_ri_quarter(l_payroll_action_id) - 1;
408:
409: ELSIF l_dimension_name like '%MPF_YTD' THEN
410: SELECT to_date('01-04-'||to_char(fnd_number.canonical_to_number(
411: to_char(PACT.date_earned,'YYYY'))+ decode(sign(PACT.date_earned
412: - to_date('01-04-'||to_char(PACT.date_earned,'YYYY'),'DD-MM-YYYY'))
413: ,-1,0,1)),'DD-MM-YYYY')
414: INTO l_beg_of_tax_year

Line 457: SELECT to_date('01-04-'||to_char(fnd_number.canonical_to_number(

453: ELSIF l_dimension_name like '%QTD' THEN
454: RETURN next_quarter(l_effective_date) - 1;
455:
456: ELSIF l_dimension_name like '%YTD' THEN
457: SELECT to_date('01-04-'||to_char(fnd_number.canonical_to_number(
458: to_char(PACT.effective_date,'YYYY'))+ decode(sign(PACT.effective_date
459: - to_date('01-04-'||to_char(PACT.effective_date,'YYYY'),'DD-MM-YYYY'))
460: ,-1,0,1)),'DD-MM-YYYY')
461: INTO l_beg_of_tax_year

Line 556: SELECT to_date('01-04-'||to_char(fnd_number.canonical_to_number(

552: p_expiry_date := next_ri_quarter(p_owner_payroll_action_id) - 1;
553: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);
554:
555: ELSIF p_dimension_name like '%MPF_YTD' THEN
556: SELECT to_date('01-04-'||to_char(fnd_number.canonical_to_number(
557: to_char(PACT.date_earned,'YYYY'))+ decode(sign(PACT.date_earned
558: - to_date('01-04-'||to_char(PACT.date_earned,'YYYY'),'DD-MM-YYYY'))
559: ,-1,0,1)),'DD-MM-YYYY') - 1
560: INTO p_expiry_date

Line 605: SELECT to_date('01-04-'||to_char(fnd_number.canonical_to_number(

601: p_expiry_date := next_quarter(p_owner_effective_date) - 1;
602: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);
603:
604: ELSIF p_dimension_name like '%YTD' THEN
605: SELECT to_date('01-04-'||to_char(fnd_number.canonical_to_number(
606: to_char(PACT.effective_date,'YYYY'))+ decode(sign(PACT.effective_date
607: - to_date('01-04-'||to_char(PACT.effective_date,'YYYY'),'DD-MM-YYYY'))
608: ,-1,0,1)),'DD-MM-YYYY') - 1
609: INTO p_expiry_date