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_P45_PKG dependencies on FND_NUMBER

Line 644: -- to_date('06-04-'||to_char(fnd_number.canonical_to_number(to_char(p_eff_date,'YYYY'))),'DD-MM-YYYY')

640: AND pact.action_type IN ( 'Q','R','B','I')
641: AND assact2.action_status = 'C'
642: AND pact.effective_date between
643: -- Bug 6900025 Modified pact.effective_date condtion to fetch PAYE details from run results instead of element entries.
644: -- to_date('06-04-'||to_char(fnd_number.canonical_to_number(to_char(p_eff_date,'YYYY'))),'DD-MM-YYYY')
645: -- and to_date('05-04-'||to_char(fnd_number.canonical_to_number(to_char(p_eff_date,'YYYY') + 1)),'DD-MM-YYYY')
646: to_date('06-04-'||to_char(fnd_number.canonical_to_number(to_char(l_eff_date,'YYYY'))),'DD-MM-YYYY')
647: and to_date('05-04-'||to_char(fnd_number.canonical_to_number(to_char(l_eff_date,'YYYY') + 1)),'DD-MM-YYYY')
648: AND NOT EXISTS(

Line 645: -- and to_date('05-04-'||to_char(fnd_number.canonical_to_number(to_char(p_eff_date,'YYYY') + 1)),'DD-MM-YYYY')

641: AND assact2.action_status = 'C'
642: AND pact.effective_date between
643: -- Bug 6900025 Modified pact.effective_date condtion to fetch PAYE details from run results instead of element entries.
644: -- to_date('06-04-'||to_char(fnd_number.canonical_to_number(to_char(p_eff_date,'YYYY'))),'DD-MM-YYYY')
645: -- and to_date('05-04-'||to_char(fnd_number.canonical_to_number(to_char(p_eff_date,'YYYY') + 1)),'DD-MM-YYYY')
646: to_date('06-04-'||to_char(fnd_number.canonical_to_number(to_char(l_eff_date,'YYYY'))),'DD-MM-YYYY')
647: and to_date('05-04-'||to_char(fnd_number.canonical_to_number(to_char(l_eff_date,'YYYY') + 1)),'DD-MM-YYYY')
648: AND NOT EXISTS(
649: SELECT '1'

Line 646: to_date('06-04-'||to_char(fnd_number.canonical_to_number(to_char(l_eff_date,'YYYY'))),'DD-MM-YYYY')

642: AND pact.effective_date between
643: -- Bug 6900025 Modified pact.effective_date condtion to fetch PAYE details from run results instead of element entries.
644: -- to_date('06-04-'||to_char(fnd_number.canonical_to_number(to_char(p_eff_date,'YYYY'))),'DD-MM-YYYY')
645: -- and to_date('05-04-'||to_char(fnd_number.canonical_to_number(to_char(p_eff_date,'YYYY') + 1)),'DD-MM-YYYY')
646: to_date('06-04-'||to_char(fnd_number.canonical_to_number(to_char(l_eff_date,'YYYY'))),'DD-MM-YYYY')
647: and to_date('05-04-'||to_char(fnd_number.canonical_to_number(to_char(l_eff_date,'YYYY') + 1)),'DD-MM-YYYY')
648: AND NOT EXISTS(
649: SELECT '1'
650: FROM pay_action_interlocks pai,

Line 647: and to_date('05-04-'||to_char(fnd_number.canonical_to_number(to_char(l_eff_date,'YYYY') + 1)),'DD-MM-YYYY')

643: -- Bug 6900025 Modified pact.effective_date condtion to fetch PAYE details from run results instead of element entries.
644: -- to_date('06-04-'||to_char(fnd_number.canonical_to_number(to_char(p_eff_date,'YYYY'))),'DD-MM-YYYY')
645: -- and to_date('05-04-'||to_char(fnd_number.canonical_to_number(to_char(p_eff_date,'YYYY') + 1)),'DD-MM-YYYY')
646: to_date('06-04-'||to_char(fnd_number.canonical_to_number(to_char(l_eff_date,'YYYY'))),'DD-MM-YYYY')
647: and to_date('05-04-'||to_char(fnd_number.canonical_to_number(to_char(l_eff_date,'YYYY') + 1)),'DD-MM-YYYY')
648: AND NOT EXISTS(
649: SELECT '1'
650: FROM pay_action_interlocks pai,
651: pay_assignment_actions assact3,

Line 663: fnd_number.canonical_to_number(result_value),NULL)))

659: CURSOR csr_run_result(l_run_result_id number,l_element_type_id number) IS
660: SELECT max(decode(name,'Tax Code',result_value,NULL)) tax_code,
661: max(decode(name,'Tax Basis',result_value,NULL)) tax_basis,
662: to_number(max(decode(name,'Pay Previous',
663: fnd_number.canonical_to_number(result_value),NULL)))
664: pay_previous,
665: to_number(max(decode(name,'Tax Previous',
666: fnd_number.canonical_to_number(result_value),NULL)))
667: tax_previous

Line 666: fnd_number.canonical_to_number(result_value),NULL)))

662: to_number(max(decode(name,'Pay Previous',
663: fnd_number.canonical_to_number(result_value),NULL)))
664: pay_previous,
665: to_number(max(decode(name,'Tax Previous',
666: fnd_number.canonical_to_number(result_value),NULL)))
667: tax_previous
668: FROM pay_input_values_f v,
669: pay_run_result_values rrv
670: WHERE rrv.run_result_id = l_run_result_id

Line 708: --if fnd_number.canonical_to_number(to_char(p_eff_date,'DD')) >= 06

704:
705: --Bug 6900025 assigning proper date earned to l_effective_date
706: --Bug 7410767 Modified the p_eff_date check
707:
708: --if fnd_number.canonical_to_number(to_char(p_eff_date,'DD')) >= 06
709: --and fnd_number.canonical_to_number(to_char(p_eff_date,'MM')) >= 04 then
710: l_start_year := to_date('06/04/'||to_char(p_eff_date,'YYYY'),'DD/MM/YYYY');
711: if to_number(p_eff_date - l_start_year) >= 0 then
712: l_effective_date := p_eff_date;

Line 709: --and fnd_number.canonical_to_number(to_char(p_eff_date,'MM')) >= 04 then

705: --Bug 6900025 assigning proper date earned to l_effective_date
706: --Bug 7410767 Modified the p_eff_date check
707:
708: --if fnd_number.canonical_to_number(to_char(p_eff_date,'DD')) >= 06
709: --and fnd_number.canonical_to_number(to_char(p_eff_date,'MM')) >= 04 then
710: l_start_year := to_date('06/04/'||to_char(p_eff_date,'YYYY'),'DD/MM/YYYY');
711: if to_number(p_eff_date - l_start_year) >= 0 then
712: l_effective_date := p_eff_date;
713: else

Line 714: --l_effective_date := to_date(to_char(p_eff_date,'DD-MM')||to_char(fnd_number.canonical_to_number(to_char(p_eff_date,'YYYY') - 1)),'DD-MM-YYYY');

710: l_start_year := to_date('06/04/'||to_char(p_eff_date,'YYYY'),'DD/MM/YYYY');
711: if to_number(p_eff_date - l_start_year) >= 0 then
712: l_effective_date := p_eff_date;
713: else
714: --l_effective_date := to_date(to_char(p_eff_date,'DD-MM')||to_char(fnd_number.canonical_to_number(to_char(p_eff_date,'YYYY') - 1)),'DD-MM-YYYY');
715: l_effective_date := add_months( p_eff_date,-12);
716: end if;
717:
718: hr_utility.trace('l_effective_date value'||l_effective_date);

Line 806: -- to_date('06-04-'||to_char(fnd_number.canonical_to_number(to_char(x_assignment_end_date,'YYYY'))),'DD-MM-YYYY')

802: and a.action_status = 'C'
803: and pact2.effective_date <= X_TRANSFER_DATE
804: and pact2.effective_date >= l_tax_year_start
805: -- and pact2.effective_date >=
806: -- to_date('06-04-'||to_char(fnd_number.canonical_to_number(to_char(x_assignment_end_date,'YYYY'))),'DD-MM-YYYY')
807: and pact2.effective_date between f.effective_start_date and f.effective_end_date
808: and v.result_value is not null --Added for bug 13054902
809: and v.result_value <> '0'); --Added for bug 13054902
810:

Line 817: to_char(fnd_number.canonical_to_number(to_char(c_date_paid,'YYYY'))

813: from per_time_periods PTP
814: where PTP.payroll_id = taxable_update_payroll
815: and (PTP.REGULAR_PAYMENT_DATE ) >= (/*start of fyear prior to session date*/
816: to_date('06-04-'||
817: to_char(fnd_number.canonical_to_number(to_char(c_date_paid,'YYYY'))
818: + least(sign(c_date_paid - to_date('06-04-'
819: || to_char(c_date_paid,'YYYY'),'DD-MM-YYYY')),0)),'DD-MM-YYYY'));
820: --
821: -- Bug 9910054: agg_latest_action modified to take all the asg actions in desc order, instead of Max action.

Line 828: -- fnd_number.canonical_to_number(substr(max(

824: c_tax_reference in varchar2,
825: c_agg_active_start in date,
826: c_agg_active_end in date) is
827: select /*+ ORDERED index(a PER_ASSIGNMENTS_F_N12) use_nl(paa ppa pay flex) */
828: -- fnd_number.canonical_to_number(substr(max(
829: fnd_number.canonical_to_number(substr((
830: lpad(paa.action_sequence,15,'0')||
831: paa.assignment_action_id),16)) assignment_action_id
832: from per_all_assignments_f a,

Line 829: fnd_number.canonical_to_number(substr((

825: c_agg_active_start in date,
826: c_agg_active_end in date) is
827: select /*+ ORDERED index(a PER_ASSIGNMENTS_F_N12) use_nl(paa ppa pay flex) */
828: -- fnd_number.canonical_to_number(substr(max(
829: fnd_number.canonical_to_number(substr((
830: lpad(paa.action_sequence,15,'0')||
831: paa.assignment_action_id),16)) assignment_action_id
832: from per_all_assignments_f a,
833: pay_assignment_actions paa,

Line 881: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||

877: --
878: cursor get_latest_id (c_assignment_id IN NUMBER,
879: c_effective_date IN DATE) is
880: SELECT /*+ USE_NL(paa, ppa) */
881: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
882: paa.assignment_action_id),16))
883: FROM pay_assignment_actions paa,
884: pay_payroll_actions ppa
885: WHERE

Line 898: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||

894: -- Added to support upgrade from 11.0 to 11i.
895: cursor get_last_action(c_assignment_id IN NUMBER,
896: c_effective_date IN DATE) is
897: SELECT /*+ USE_NL(paa, ppa) */
898: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
899: paa.assignment_action_id),16))
900: FROM pay_assignment_actions paa,
901: pay_payroll_actions ppa
902: WHERE

Line 945: to_char(fnd_number.canonical_to_number(to_char(X_ASSIGNMENT_END_DATE,'YYYY'))

941: p.effective_start_date and p.effective_end_date;
942: --
943: CURSOR csr_get_term_tax_year_start IS
944: SELECT to_date('06-04-'||
945: to_char(fnd_number.canonical_to_number(to_char(X_ASSIGNMENT_END_DATE,'YYYY'))
946: + least(sign(X_ASSIGNMENT_END_DATE - to_date('06-04-'
947: || to_char(X_ASSIGNMENT_END_DATE,'YYYY'),'DD-MM-YYYY')),0)),'DD-MM-YYYY')
948: FROM dual;
949: --

Line 952: to_char(fnd_number.canonical_to_number(to_char(ptp.regular_payment_date,'YYYY'))

948: FROM dual;
949: --
950: CURSOR csr_get_action_tax_year_start (p_asg_action_id NUMBER) IS
951: SELECT to_date('06-04-'||
952: to_char(fnd_number.canonical_to_number(to_char(ptp.regular_payment_date,'YYYY'))
953: + least(sign(ptp.regular_payment_date - to_date('06-04-'
954: || to_char(ptp.regular_payment_date,'YYYY'),'DD-MM-YYYY')),0)),'DD-MM-YYYY')
955: FROM per_time_periods ptp, pay_assignment_actions act, pay_payroll_actions pact
956: WHERE act.assignment_action_id = p_asg_action_id

Line 2113: select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0') ||

2109: l_latest_asg_action_id number;
2110: --
2111: cursor csr_latest_action (c_assignment_id in number) is
2112: -- c_effective_end_date in date) is --Bug 9036584
2113: select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0') ||
2114: paa.assignment_action_id),16))
2115: FROM pay_assignment_actions paa,
2116: pay_payroll_actions ppa
2117: WHERE

Line 3316: to_date('06-04-'||to_char(fnd_number.canonical_to_number(to_char(l_date_earned,'YYYY'))),'DD-MM-YYYY')

3312: AND pact.payroll_action_id = assact2.payroll_action_id
3313: AND pact.action_type IN ( 'Q','R','B','I')
3314: AND assact2.action_status = 'C'
3315: AND pact.effective_date between
3316: to_date('06-04-'||to_char(fnd_number.canonical_to_number(to_char(l_date_earned,'YYYY'))),'DD-MM-YYYY')
3317: and to_date('05-04-'||to_char(fnd_number.canonical_to_number(to_char(l_date_earned,'YYYY') + 1)),'DD-MM-YYYY')
3318: AND NOT EXISTS(
3319: SELECT '1'
3320: FROM pay_action_interlocks pai,

Line 3317: and to_date('05-04-'||to_char(fnd_number.canonical_to_number(to_char(l_date_earned,'YYYY') + 1)),'DD-MM-YYYY')

3313: AND pact.action_type IN ( 'Q','R','B','I')
3314: AND assact2.action_status = 'C'
3315: AND pact.effective_date between
3316: to_date('06-04-'||to_char(fnd_number.canonical_to_number(to_char(l_date_earned,'YYYY'))),'DD-MM-YYYY')
3317: and to_date('05-04-'||to_char(fnd_number.canonical_to_number(to_char(l_date_earned,'YYYY') + 1)),'DD-MM-YYYY')
3318: AND NOT EXISTS(
3319: SELECT '1'
3320: FROM pay_action_interlocks pai,
3321: pay_assignment_actions assact3,

Line 3504: fnd_number.number_to_canonical(l_payroll_id));

3500: archive_asg_info(g_sex_eid, l_sex);
3501: IF g_payroll_id IS NULL THEN
3502: -- archive not restricted by payroll so stamp asg with payroll id.
3503: archive_asg_info(g_payroll_id_eid,
3504: fnd_number.number_to_canonical(l_payroll_id));
3505: END IF;
3506: archive_asg_info(g_issue_date_eid, nvl(fnd_date.date_to_canonical(p_effective_date), fnd_date.date_to_canonical(sysdate)));
3507: --
3508: PAY_P45_PKG.get_data

Line 4037: fnd_number.number_to_canonical(l_taxable));

4033: END IF;
4034: archive_asg_info(g_prev_taxable_pay_eid, l_prev_pay_char);
4035: archive_asg_info(g_prev_tax_paid_eid, l_prev_tax_char);
4036: archive_asg_info(g_taxable_pay_eid,
4037: fnd_number.number_to_canonical(l_taxable));
4038: archive_asg_info(g_tax_paid_eid,
4039: fnd_number.number_to_canonical(l_paye));
4040: --
4041: hr_utility.set_location(' Leaving: '||l_proc,999);

Line 4039: fnd_number.number_to_canonical(l_paye));

4035: archive_asg_info(g_prev_tax_paid_eid, l_prev_tax_char);
4036: archive_asg_info(g_taxable_pay_eid,
4037: fnd_number.number_to_canonical(l_taxable));
4038: archive_asg_info(g_tax_paid_eid,
4039: fnd_number.number_to_canonical(l_paye));
4040: --
4041: hr_utility.set_location(' Leaving: '||l_proc,999);
4042: --hr_utility.trace_off;
4043: END archive_code;