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 587: -- to_date('06-04-'||to_char(fnd_number.canonical_to_number(to_char(p_eff_date,'YYYY'))),'DD-MM-YYYY')

583: AND pact.action_type IN ( 'Q','R','B','I')
584: AND assact2.action_status = 'C'
585: AND pact.effective_date between
586: -- Bug 6900025 Modified pact.effective_date condtion to fetch PAYE details from run results instead of element entries.
587: -- to_date('06-04-'||to_char(fnd_number.canonical_to_number(to_char(p_eff_date,'YYYY'))),'DD-MM-YYYY')
588: -- and to_date('05-04-'||to_char(fnd_number.canonical_to_number(to_char(p_eff_date,'YYYY') + 1)),'DD-MM-YYYY')
589: to_date('06-04-'||to_char(fnd_number.canonical_to_number(to_char(l_eff_date,'YYYY'))),'DD-MM-YYYY')
590: and to_date('05-04-'||to_char(fnd_number.canonical_to_number(to_char(l_eff_date,'YYYY') + 1)),'DD-MM-YYYY')
591: AND NOT EXISTS(

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

584: AND assact2.action_status = 'C'
585: AND pact.effective_date between
586: -- Bug 6900025 Modified pact.effective_date condtion to fetch PAYE details from run results instead of element entries.
587: -- to_date('06-04-'||to_char(fnd_number.canonical_to_number(to_char(p_eff_date,'YYYY'))),'DD-MM-YYYY')
588: -- and to_date('05-04-'||to_char(fnd_number.canonical_to_number(to_char(p_eff_date,'YYYY') + 1)),'DD-MM-YYYY')
589: to_date('06-04-'||to_char(fnd_number.canonical_to_number(to_char(l_eff_date,'YYYY'))),'DD-MM-YYYY')
590: and to_date('05-04-'||to_char(fnd_number.canonical_to_number(to_char(l_eff_date,'YYYY') + 1)),'DD-MM-YYYY')
591: AND NOT EXISTS(
592: SELECT '1'

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

585: AND pact.effective_date between
586: -- Bug 6900025 Modified pact.effective_date condtion to fetch PAYE details from run results instead of element entries.
587: -- to_date('06-04-'||to_char(fnd_number.canonical_to_number(to_char(p_eff_date,'YYYY'))),'DD-MM-YYYY')
588: -- and to_date('05-04-'||to_char(fnd_number.canonical_to_number(to_char(p_eff_date,'YYYY') + 1)),'DD-MM-YYYY')
589: to_date('06-04-'||to_char(fnd_number.canonical_to_number(to_char(l_eff_date,'YYYY'))),'DD-MM-YYYY')
590: and to_date('05-04-'||to_char(fnd_number.canonical_to_number(to_char(l_eff_date,'YYYY') + 1)),'DD-MM-YYYY')
591: AND NOT EXISTS(
592: SELECT '1'
593: FROM pay_action_interlocks pai,

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

586: -- Bug 6900025 Modified pact.effective_date condtion to fetch PAYE details from run results instead of element entries.
587: -- to_date('06-04-'||to_char(fnd_number.canonical_to_number(to_char(p_eff_date,'YYYY'))),'DD-MM-YYYY')
588: -- and to_date('05-04-'||to_char(fnd_number.canonical_to_number(to_char(p_eff_date,'YYYY') + 1)),'DD-MM-YYYY')
589: to_date('06-04-'||to_char(fnd_number.canonical_to_number(to_char(l_eff_date,'YYYY'))),'DD-MM-YYYY')
590: and to_date('05-04-'||to_char(fnd_number.canonical_to_number(to_char(l_eff_date,'YYYY') + 1)),'DD-MM-YYYY')
591: AND NOT EXISTS(
592: SELECT '1'
593: FROM pay_action_interlocks pai,
594: pay_assignment_actions assact3,

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

602: CURSOR csr_run_result(l_run_result_id number,l_element_type_id number) IS
603: SELECT max(decode(name,'Tax Code',result_value,NULL)) tax_code,
604: max(decode(name,'Tax Basis',result_value,NULL)) tax_basis,
605: to_number(max(decode(name,'Pay Previous',
606: fnd_number.canonical_to_number(result_value),NULL)))
607: pay_previous,
608: to_number(max(decode(name,'Tax Previous',
609: fnd_number.canonical_to_number(result_value),NULL)))
610: tax_previous

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

605: to_number(max(decode(name,'Pay Previous',
606: fnd_number.canonical_to_number(result_value),NULL)))
607: pay_previous,
608: to_number(max(decode(name,'Tax Previous',
609: fnd_number.canonical_to_number(result_value),NULL)))
610: tax_previous
611: FROM pay_input_values_f v,
612: pay_run_result_values rrv
613: WHERE rrv.run_result_id = l_run_result_id

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

647:
648: --Bug 6900025 assigning proper date earned to l_effective_date
649: --Bug 7410767 Modified the p_eff_date check
650:
651: --if fnd_number.canonical_to_number(to_char(p_eff_date,'DD')) >= 06
652: --and fnd_number.canonical_to_number(to_char(p_eff_date,'MM')) >= 04 then
653: l_start_year := to_date('06/04/'||to_char(p_eff_date,'YYYY'),'DD/MM/YYYY');
654: if to_number(p_eff_date - l_start_year) >= 0 then
655: l_effective_date := p_eff_date;

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

648: --Bug 6900025 assigning proper date earned to l_effective_date
649: --Bug 7410767 Modified the p_eff_date check
650:
651: --if fnd_number.canonical_to_number(to_char(p_eff_date,'DD')) >= 06
652: --and fnd_number.canonical_to_number(to_char(p_eff_date,'MM')) >= 04 then
653: l_start_year := to_date('06/04/'||to_char(p_eff_date,'YYYY'),'DD/MM/YYYY');
654: if to_number(p_eff_date - l_start_year) >= 0 then
655: l_effective_date := p_eff_date;
656: else

Line 657: --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');

653: l_start_year := to_date('06/04/'||to_char(p_eff_date,'YYYY'),'DD/MM/YYYY');
654: if to_number(p_eff_date - l_start_year) >= 0 then
655: l_effective_date := p_eff_date;
656: else
657: --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');
658: l_effective_date := add_months( p_eff_date,-12);
659: end if;
660:
661: hr_utility.trace('l_effective_date value'||l_effective_date);

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

740: and a.assignment_id = X_ASSIGNMENT_ID
741: and a.action_status = 'C'
742: and pact2.effective_date <= X_TRANSFER_DATE
743: and pact2.effective_date >=
744: to_date('06-04-'||to_char(fnd_number.canonical_to_number(to_char(x_assignment_end_date,'YYYY'))),'DD-MM-YYYY')
745: and pact2.effective_date between f.effective_start_date and f.effective_end_date);
746:
747: cursor c_ptp (taxable_update_payroll number, c_date_paid date) is
748: select min(PTP.start_date) start_date

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

749: from per_time_periods PTP
750: where PTP.payroll_id = taxable_update_payroll
751: and (PTP.REGULAR_PAYMENT_DATE ) >= (/*start of fyear prior to session date*/
752: to_date('06-04-'||
753: to_char(fnd_number.canonical_to_number(to_char(c_date_paid,'YYYY'))
754: + least(sign(c_date_paid - to_date('06-04-'
755: || to_char(c_date_paid,'YYYY'),'DD-MM-YYYY')),0)),'DD-MM-YYYY'));
756: --
757: cursor agg_latest_action (c_person_id in number,

Line 764: fnd_number.canonical_to_number(substr(max(

760: c_agg_active_start in date,
761: c_agg_active_end in date) is
762: select /*+ ORDERED use_nl(flex pay ppa paa a)
763: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
764: fnd_number.canonical_to_number(substr(max(
765: lpad(paa.action_sequence,15,'0')||
766: paa.assignment_action_id),16)) assignment_action_id
767: from per_all_assignments_f a,
768: pay_assignment_actions paa,

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

799: --
800: cursor get_latest_id (c_assignment_id IN NUMBER,
801: c_effective_date IN DATE) is
802: SELECT /*+ USE_NL(paa, ppa) */
803: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
804: paa.assignment_action_id),16))
805: FROM pay_assignment_actions paa,
806: pay_payroll_actions ppa
807: WHERE

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

816: -- Added to support upgrade from 11.0 to 11i.
817: cursor get_last_action(c_assignment_id IN NUMBER,
818: c_effective_date IN DATE) is
819: SELECT /*+ USE_NL(paa, ppa) */
820: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
821: paa.assignment_action_id),16))
822: FROM pay_assignment_actions paa,
823: pay_payroll_actions ppa
824: WHERE

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

863: p.effective_start_date and p.effective_end_date;
864: --
865: CURSOR csr_get_term_tax_year_start IS
866: SELECT to_date('06-04-'||
867: to_char(fnd_number.canonical_to_number(to_char(X_ASSIGNMENT_END_DATE,'YYYY'))
868: + least(sign(X_ASSIGNMENT_END_DATE - to_date('06-04-'
869: || to_char(X_ASSIGNMENT_END_DATE,'YYYY'),'DD-MM-YYYY')),0)),'DD-MM-YYYY')
870: FROM dual;
871: --

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

870: FROM dual;
871: --
872: CURSOR csr_get_action_tax_year_start (p_asg_action_id NUMBER) IS
873: SELECT to_date('06-04-'||
874: to_char(fnd_number.canonical_to_number(to_char(ptp.regular_payment_date,'YYYY'))
875: + least(sign(ptp.regular_payment_date - to_date('06-04-'
876: || to_char(ptp.regular_payment_date,'YYYY'),'DD-MM-YYYY')),0)),'DD-MM-YYYY')
877: FROM per_time_periods ptp, pay_assignment_actions act, pay_payroll_actions pact
878: WHERE act.assignment_action_id = p_asg_action_id

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

1987: l_latest_asg_action_id number;
1988: --
1989: cursor csr_latest_action (c_assignment_id in number,
1990: c_effective_end_date in date) is
1991: select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0') ||
1992: paa.assignment_action_id),16))
1993: FROM pay_assignment_actions paa,
1994: pay_payroll_actions ppa
1995: WHERE

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

2927: AND pact.payroll_action_id = assact2.payroll_action_id
2928: AND pact.action_type IN ( 'Q','R','B','I')
2929: AND assact2.action_status = 'C'
2930: AND pact.effective_date between
2931: to_date('06-04-'||to_char(fnd_number.canonical_to_number(to_char(l_date_earned,'YYYY'))),'DD-MM-YYYY')
2932: and to_date('05-04-'||to_char(fnd_number.canonical_to_number(to_char(l_date_earned,'YYYY') + 1)),'DD-MM-YYYY')
2933: AND NOT EXISTS(
2934: SELECT '1'
2935: FROM pay_action_interlocks pai,

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

2928: AND pact.action_type IN ( 'Q','R','B','I')
2929: AND assact2.action_status = 'C'
2930: AND pact.effective_date between
2931: to_date('06-04-'||to_char(fnd_number.canonical_to_number(to_char(l_date_earned,'YYYY'))),'DD-MM-YYYY')
2932: and to_date('05-04-'||to_char(fnd_number.canonical_to_number(to_char(l_date_earned,'YYYY') + 1)),'DD-MM-YYYY')
2933: AND NOT EXISTS(
2934: SELECT '1'
2935: FROM pay_action_interlocks pai,
2936: pay_assignment_actions assact3,

Line 3080: fnd_number.number_to_canonical(l_payroll_id));

3076: archive_asg_info(g_sex_eid, l_sex);
3077: IF g_payroll_id IS NULL THEN
3078: -- archive not restricted by payroll so stamp asg with payroll id.
3079: archive_asg_info(g_payroll_id_eid,
3080: fnd_number.number_to_canonical(l_payroll_id));
3081: END IF;
3082: archive_asg_info(g_issue_date_eid, nvl(fnd_date.date_to_canonical(p_effective_date), fnd_date.date_to_canonical(sysdate)));
3083: --
3084: PAY_P45_PKG.get_data

Line 3345: fnd_number.number_to_canonical(l_taxable));

3341: END IF;
3342: archive_asg_info(g_prev_taxable_pay_eid, l_prev_pay_char);
3343: archive_asg_info(g_prev_tax_paid_eid, l_prev_tax_char);
3344: archive_asg_info(g_taxable_pay_eid,
3345: fnd_number.number_to_canonical(l_taxable));
3346: archive_asg_info(g_tax_paid_eid,
3347: fnd_number.number_to_canonical(l_paye));
3348: --
3349: hr_utility.set_location(' Leaving: '||l_proc,999);

Line 3347: fnd_number.number_to_canonical(l_paye));

3343: archive_asg_info(g_prev_tax_paid_eid, l_prev_tax_char);
3344: archive_asg_info(g_taxable_pay_eid,
3345: fnd_number.number_to_canonical(l_taxable));
3346: archive_asg_info(g_tax_paid_eid,
3347: fnd_number.number_to_canonical(l_paye));
3348: --
3349: hr_utility.set_location(' Leaving: '||l_proc,999);
3350: --hr_utility.trace_off;
3351: END archive_code;