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

Line 357: and fnd_number.canonical_to_number(substr(paa.serial_number,1,14)) = paa1.assignment_action_id

353: pay_payroll_actions ppa1
354: where ppa.payroll_action_id = paa.payroll_action_id
355: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
356: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
357: and fnd_number.canonical_to_number(substr(paa.serial_number,1,14)) = paa1.assignment_action_id
358: and paa1.payroll_action_id = ppa1.payroll_action_id
359: --and ppa1.report_type = 'T4A'
360: and ( ((ppa.report_type = 'PAYCAT4ACLPDF')
361: and ppa1.report_type in ('CAEOY_T4A_AMEND_PP','T4A'))

Line 720: if (fnd_number.canonical_to_number(l_box16) = 0 ) then

716: 'CAEOY_EMPLOYEE_INITIAL'),1,1);
717:
718: l_box16 := pay_ca_archive_utils.get_archive_value(l_aa_id
719: ,'CAEOY_T4A_BOX16_PER_GRE_YTD');
720: if (fnd_number.canonical_to_number(l_box16) = 0 ) then
721: l_box16 := null;
722: end if;
723:
724: l_box18 := pay_ca_archive_utils.get_archive_value(l_aa_id

Line 726: if (fnd_number.canonical_to_number(l_box18) = 0 ) then

722: end if;
723:
724: l_box18 := pay_ca_archive_utils.get_archive_value(l_aa_id
725: ,'CAEOY_T4A_BOX18_PER_GRE_YTD');
726: if (fnd_number.canonical_to_number(l_box18) = 0 ) then
727: l_box18 := null;
728: end if;
729:
730: l_box20 := pay_ca_archive_utils.get_archive_value(l_aa_id

Line 732: if (fnd_number.canonical_to_number(l_box20) = 0 ) then

728: end if;
729:
730: l_box20 := pay_ca_archive_utils.get_archive_value(l_aa_id
731: ,'CAEOY_T4A_BOX20_PER_GRE_YTD');
732: if (fnd_number.canonical_to_number(l_box20) = 0 ) then
733: l_box20 := null;
734: end if;
735:
736: l_box22 := pay_ca_archive_utils.get_archive_value(l_aa_id

Line 738: if (fnd_number.canonical_to_number(l_box22) = 0 ) then

734: end if;
735:
736: l_box22 := pay_ca_archive_utils.get_archive_value(l_aa_id
737: ,'CAEOY_FED_WITHHELD_PER_GRE_YTD');
738: if (fnd_number.canonical_to_number(l_box22) = 0 ) then
739: l_box22 := null;
740: end if;
741:
742: l_box24 := pay_ca_archive_utils.get_archive_value(l_aa_id

Line 744: if (fnd_number.canonical_to_number(l_box24) = 0 ) then

740: end if;
741:
742: l_box24 := pay_ca_archive_utils.get_archive_value(l_aa_id
743: ,'CAEOY_T4A_BOX24_PER_GRE_YTD');
744: if (fnd_number.canonical_to_number(l_box24) = 0 ) then
745: l_box24 := null;
746: end if;
747:
748: l_box26 := pay_ca_archive_utils.get_archive_value(l_aa_id

Line 750: if (fnd_number.canonical_to_number(l_box26) = 0 ) then

746: end if;
747:
748: l_box26 := pay_ca_archive_utils.get_archive_value(l_aa_id
749: ,'CAEOY_T4A_BOX26_PER_GRE_YTD');
750: if (fnd_number.canonical_to_number(l_box26) = 0 ) then
751: l_box26 := null;
752: end if;
753:
754: l_box27 := pay_ca_archive_utils.get_archive_value(l_aa_id

Line 756: if (fnd_number.canonical_to_number(l_box27) = 0 ) then

752: end if;
753:
754: l_box27 := pay_ca_archive_utils.get_archive_value(l_aa_id
755: ,'CAEOY_T4A_BOX27_PER_GRE_YTD');
756: if (fnd_number.canonical_to_number(l_box27) = 0 ) then
757: l_box27 := null;
758: end if;
759:
760: l_box28 := pay_ca_archive_utils.get_archive_value(l_aa_id

Line 762: if (fnd_number.canonical_to_number(l_box28) = 0 ) then

758: end if;
759:
760: l_box28 := pay_ca_archive_utils.get_archive_value(l_aa_id
761: ,'CAEOY_T4A_BOX28_PER_GRE_YTD');
762: if (fnd_number.canonical_to_number(l_box28) = 0 ) then
763: l_box28 := null;
764: end if;
765:
766: l_box30 := pay_ca_archive_utils.get_archive_value(l_aa_id

Line 768: if (fnd_number.canonical_to_number(l_box30) = 0 ) then

764: end if;
765:
766: l_box30 := pay_ca_archive_utils.get_archive_value(l_aa_id
767: ,'CAEOY_T4A_BOX30_PER_GRE_YTD');
768: if (fnd_number.canonical_to_number(l_box30) = 0 ) then
769: l_box30 := null;
770: end if;
771:
772: l_box32 := pay_ca_archive_utils.get_archive_value(l_aa_id

Line 774: if (fnd_number.canonical_to_number(l_box32) = 0 ) then

770: end if;
771:
772: l_box32 := pay_ca_archive_utils.get_archive_value(l_aa_id
773: ,'CAEOY_T4A_BOX32_PER_GRE_YTD');
774: if (fnd_number.canonical_to_number(l_box32) = 0 ) then
775: l_box32 := null;
776: end if;
777:
778: l_box34 := pay_ca_archive_utils.get_archive_value(l_aa_id

Line 780: if (fnd_number.canonical_to_number(l_box34) = 0 ) then

776: end if;
777:
778: l_box34 := pay_ca_archive_utils.get_archive_value(l_aa_id
779: ,'CAEOY_T4A_BOX34_PER_GRE_YTD');
780: if (fnd_number.canonical_to_number(l_box34) = 0 ) then
781: l_box34 := null;
782: end if;
783:
784: l_box36 := pay_ca_archive_utils.get_archive_value(l_aa_id

Line 789: if (fnd_number.canonical_to_number(l_box40) = 0 ) then

785: ,'CAEOY_T4A_EMPLOYEE_REGISTRATION_NO');
786:
787: l_box40 := pay_ca_archive_utils.get_archive_value(l_aa_id
788: ,'CAEOY_T4A_BOX40_PER_GRE_YTD');
789: if (fnd_number.canonical_to_number(l_box40) = 0 ) then
790: l_box40 := null;
791: end if;
792:
793: l_box42 := pay_ca_archive_utils.get_archive_value(l_aa_id

Line 795: if (fnd_number.canonical_to_number(l_box42) = 0 ) then

791: end if;
792:
793: l_box42 := pay_ca_archive_utils.get_archive_value(l_aa_id
794: ,'CAEOY_T4A_BOX42_PER_GRE_YTD');
795: if (fnd_number.canonical_to_number(l_box42) = 0 ) then
796: l_box42 := null;
797: end if;
798:
799: l_box46 := pay_ca_archive_utils.get_archive_value(l_aa_id

Line 801: if (fnd_number.canonical_to_number(l_box46) = 0 ) then

797: end if;
798:
799: l_box46 := pay_ca_archive_utils.get_archive_value(l_aa_id
800: ,'CAEOY_T4A_BOX46_PER_GRE_YTD');
801: if (fnd_number.canonical_to_number(l_box46) = 0 ) then
802: l_box46 := null;
803: end if;
804:
805: l_box48 := pay_ca_archive_utils.get_archive_value(l_aa_id

Line 807: if (fnd_number.canonical_to_number(l_box48) = 0 ) then

803: end if;
804:
805: l_box48 := pay_ca_archive_utils.get_archive_value(l_aa_id
806: ,'CAEOY_T4A_BOX48_PER_GRE_YTD');
807: if (fnd_number.canonical_to_number(l_box48) = 0 ) then
808: l_box48 := null;
809: end if;
810: --added by rgottipa for bug 6456662
811: l_box16_1:=l_box16;

Line 1251: and fnd_number.canonical_to_number(substr(paa.serial_number,1,14)) = paa1.assignment_action_id

1247: where ppa.payroll_action_id = paa.payroll_action_id
1248: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
1249: and substr(paa.serial_number,29,1) = 'Y'
1250: --and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
1251: and fnd_number.canonical_to_number(substr(paa.serial_number,1,14)) = paa1.assignment_action_id
1252: and paa1.payroll_action_id = ppa1.payroll_action_id
1253: --and ppa1.report_type = 'T4A'
1254: and ( ((ppa.report_type = 'PAYCAT4ACLPDF')
1255: and ppa1.report_type in ('CAEOY_T4A_AMEND_PP','T4A'))