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.PER_MX_SSAFFL_DISPMAG dependencies on PAY_MX_RULES

Line 47: 18-May-2006 vpandya 115.8 5234421 Calling pay_mx_rules.strip_spl_chars

43: 02-Dec-2004 kthirmiy 115.6 Added format to IDW to retrive 4,2 with
44: implied decimal
45: 06-May-2005 kthirmiy 115.7 4353084 removed the redundant use of bind variable
46: payroll_action_id
47: 18-May-2006 vpandya 115.8 5234421 Calling pay_mx_rules.strip_spl_chars
48: for all names that are printed in
49: output files to remove special
50: characters.
51: ******************************************************************************/

Line 513: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information5)),' '),1,27),27,' ') || -- Paternal Last Name

509: rpad(action_information1,10,' ') || -- employer ss id
510: nvl(action_information2,' ') || -- employer ss check digit
511: rpad(action_information3,10,' ') || -- employee ss id
512: nvl(action_information4,' ') || -- employee ss check digit
513: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information5)),' '),1,27),27,' ') || -- Paternal Last Name
514: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information6)),' '),1,27),27,' ') || -- Maternal Last Name
515: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information7)),' '),1,27),27,' ') || -- Employee Name
516: lpad(to_char(to_number(nvl(action_information8,'0'))*100),6,'0') || -- IDW
517: rpad(' ',6,' ') || -- Filler

Line 514: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information6)),' '),1,27),27,' ') || -- Maternal Last Name

510: nvl(action_information2,' ') || -- employer ss check digit
511: rpad(action_information3,10,' ') || -- employee ss id
512: nvl(action_information4,' ') || -- employee ss check digit
513: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information5)),' '),1,27),27,' ') || -- Paternal Last Name
514: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information6)),' '),1,27),27,' ') || -- Maternal Last Name
515: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information7)),' '),1,27),27,' ') || -- Employee Name
516: lpad(to_char(to_number(nvl(action_information8,'0'))*100),6,'0') || -- IDW
517: rpad(' ',6,' ') || -- Filler
518: nvl(action_information10,' ')|| -- Worker Type

Line 515: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information7)),' '),1,27),27,' ') || -- Employee Name

511: rpad(action_information3,10,' ') || -- employee ss id
512: nvl(action_information4,' ') || -- employee ss check digit
513: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information5)),' '),1,27),27,' ') || -- Paternal Last Name
514: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information6)),' '),1,27),27,' ') || -- Maternal Last Name
515: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information7)),' '),1,27),27,' ') || -- Employee Name
516: lpad(to_char(to_number(nvl(action_information8,'0'))*100),6,'0') || -- IDW
517: rpad(' ',6,' ') || -- Filler
518: nvl(action_information10,' ')|| -- Worker Type
519: nvl(action_information11,' ') || -- Salary Type

Line 534: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information5)),' '),1,27),27,' ')) ||

530: format_data_string(rpad(action_information1,10,' ')) ||
531: format_data_string(nvl(action_information2,' ')) ||
532: format_data_string(rpad(action_information3,10,' ')) ||
533: format_data_string(nvl(action_information4,' ')) ||
534: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information5)),' '),1,27),27,' ')) ||
535: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information6)),' '),1,27),27,' ')) ||
536: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information7)),' '),1,27),27,' ')) ||
537: format_data_string(lpad(to_char(to_number(nvl(action_information8,'0'))*100),6,'0')) ||
538: format_data_string(rpad(' ',6,' ')) ||

Line 535: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information6)),' '),1,27),27,' ')) ||

531: format_data_string(nvl(action_information2,' ')) ||
532: format_data_string(rpad(action_information3,10,' ')) ||
533: format_data_string(nvl(action_information4,' ')) ||
534: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information5)),' '),1,27),27,' ')) ||
535: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information6)),' '),1,27),27,' ')) ||
536: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information7)),' '),1,27),27,' ')) ||
537: format_data_string(lpad(to_char(to_number(nvl(action_information8,'0'))*100),6,'0')) ||
538: format_data_string(rpad(' ',6,' ')) ||
539: format_data_string(nvl(action_information10,' ')) ||

Line 536: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information7)),' '),1,27),27,' ')) ||

532: format_data_string(rpad(action_information3,10,' ')) ||
533: format_data_string(nvl(action_information4,' ')) ||
534: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information5)),' '),1,27),27,' ')) ||
535: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information6)),' '),1,27),27,' ')) ||
536: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information7)),' '),1,27),27,' ')) ||
537: format_data_string(lpad(to_char(to_number(nvl(action_information8,'0'))*100),6,'0')) ||
538: format_data_string(rpad(' ',6,' ')) ||
539: format_data_string(nvl(action_information10,' ')) ||
540: format_data_string(nvl(action_information11,' ')) ||

Line 583: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information5)),' '),1,27),27,' ') || -- Paternal Last Name

579: rpad(action_information1,10,' ') || -- employer ss id
580: nvl(action_information2,' ') || -- employer ss check digit
581: rpad(action_information3,10,' ') || -- employee ss id
582: nvl(action_information4,' ') || -- employee ss check digit
583: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information5)),' '),1,27),27,' ') || -- Paternal Last Name
584: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information6)),' '),1,27),27,' ') || -- Maternal Last Name
585: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information7)),' '),1,27),27,' ') || -- Employee Name
586: rpad('0',15,'0') || -- Filler
587: rpad(nvl(action_information9,' '),8,' ') || -- Date of Emp Separation

Line 584: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information6)),' '),1,27),27,' ') || -- Maternal Last Name

580: nvl(action_information2,' ') || -- employer ss check digit
581: rpad(action_information3,10,' ') || -- employee ss id
582: nvl(action_information4,' ') || -- employee ss check digit
583: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information5)),' '),1,27),27,' ') || -- Paternal Last Name
584: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information6)),' '),1,27),27,' ') || -- Maternal Last Name
585: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information7)),' '),1,27),27,' ') || -- Employee Name
586: rpad('0',15,'0') || -- Filler
587: rpad(nvl(action_information9,' '),8,' ') || -- Date of Emp Separation
588: rpad(' ',5,' ') || -- Filler

Line 585: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information7)),' '),1,27),27,' ') || -- Employee Name

581: rpad(action_information3,10,' ') || -- employee ss id
582: nvl(action_information4,' ') || -- employee ss check digit
583: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information5)),' '),1,27),27,' ') || -- Paternal Last Name
584: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information6)),' '),1,27),27,' ') || -- Maternal Last Name
585: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information7)),' '),1,27),27,' ') || -- Employee Name
586: rpad('0',15,'0') || -- Filler
587: rpad(nvl(action_information9,' '),8,' ') || -- Date of Emp Separation
588: rpad(' ',5,' ') || -- Filler
589: action_information11 || -- Type of Trans

Line 599: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information5)),' '),1,27),27,' ')) ||

595: format_data_string(rpad(action_information1,10,' ')) ||
596: format_data_string(nvl(action_information2,' ')) ||
597: format_data_string(rpad(action_information3,10,' ')) ||
598: format_data_string(nvl(action_information4,' ')) ||
599: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information5)),' '),1,27),27,' ')) ||
600: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information6)),' '),1,27),27,' ')) ||
601: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information7)),' '),1,27),27,' ')) ||
602: format_data_string(rpad('0',15,'0')) ||
603: format_data_string(rpad(action_information9,8,' ')) ||

Line 600: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information6)),' '),1,27),27,' ')) ||

596: format_data_string(nvl(action_information2,' ')) ||
597: format_data_string(rpad(action_information3,10,' ')) ||
598: format_data_string(nvl(action_information4,' ')) ||
599: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information5)),' '),1,27),27,' ')) ||
600: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information6)),' '),1,27),27,' ')) ||
601: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information7)),' '),1,27),27,' ')) ||
602: format_data_string(rpad('0',15,'0')) ||
603: format_data_string(rpad(action_information9,8,' ')) ||
604: format_data_string(rpad(' ',5,' ')) ||

Line 601: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information7)),' '),1,27),27,' ')) ||

597: format_data_string(rpad(action_information3,10,' ')) ||
598: format_data_string(nvl(action_information4,' ')) ||
599: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information5)),' '),1,27),27,' ')) ||
600: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information6)),' '),1,27),27,' ')) ||
601: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information7)),' '),1,27),27,' ')) ||
602: format_data_string(rpad('0',15,'0')) ||
603: format_data_string(rpad(action_information9,8,' ')) ||
604: format_data_string(rpad(' ',5,' ')) ||
605: format_data_string(action_information11) ||

Line 645: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information5)),' '),1,27),27,' ') || -- Paternal Last Name

641: rpad(action_information1,10,' ') || -- employer ss id
642: nvl(action_information2,' ') || -- employer ss check digit
643: rpad(action_information3,10,' ') || -- employee ss id
644: nvl(action_information4,' ') || -- employee ss check digit
645: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information5)),' '),1,27),27,' ') || -- Paternal Last Name
646: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information6)),' '),1,27),27,' ') || -- Maternal Last Name
647: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information7)),' '),1,27),27,' ') || -- Employee Name
648: lpad(to_char(to_number(nvl(action_information8,'0'))*100),6,'0') || -- IDW
649: rpad(' ',6,' ') || -- Filler

Line 646: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information6)),' '),1,27),27,' ') || -- Maternal Last Name

642: nvl(action_information2,' ') || -- employer ss check digit
643: rpad(action_information3,10,' ') || -- employee ss id
644: nvl(action_information4,' ') || -- employee ss check digit
645: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information5)),' '),1,27),27,' ') || -- Paternal Last Name
646: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information6)),' '),1,27),27,' ') || -- Maternal Last Name
647: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information7)),' '),1,27),27,' ') || -- Employee Name
648: lpad(to_char(to_number(nvl(action_information8,'0'))*100),6,'0') || -- IDW
649: rpad(' ',6,' ') || -- Filler
650: nvl(action_information10,' ')|| -- Worker Type

Line 647: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information7)),' '),1,27),27,' ') || -- Employee Name

643: rpad(action_information3,10,' ') || -- employee ss id
644: nvl(action_information4,' ') || -- employee ss check digit
645: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information5)),' '),1,27),27,' ') || -- Paternal Last Name
646: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information6)),' '),1,27),27,' ') || -- Maternal Last Name
647: rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information7)),' '),1,27),27,' ') || -- Employee Name
648: lpad(to_char(to_number(nvl(action_information8,'0'))*100),6,'0') || -- IDW
649: rpad(' ',6,' ') || -- Filler
650: nvl(action_information10,' ')|| -- Worker Type
651: nvl(action_information11,' ') || -- Salary Type

Line 665: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information5)),' '),1,27),27,' ')) ||

661: format_data_string(rpad(action_information1,10,' ')) ||
662: format_data_string(nvl(action_information2,' ')) ||
663: format_data_string(rpad(action_information3,10,' ')) ||
664: format_data_string(nvl(action_information4,' ')) ||
665: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information5)),' '),1,27),27,' ')) ||
666: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information6)),' '),1,27),27,' ')) ||
667: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information7)),' '),1,27),27,' ')) ||
668: format_data_string(lpad(to_char(to_number(nvl(action_information8,'0'))*100),6,'0')) ||
669: format_data_string(rpad(' ',6,' ')) ||

Line 666: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information6)),' '),1,27),27,' ')) ||

662: format_data_string(nvl(action_information2,' ')) ||
663: format_data_string(rpad(action_information3,10,' ')) ||
664: format_data_string(nvl(action_information4,' ')) ||
665: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information5)),' '),1,27),27,' ')) ||
666: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information6)),' '),1,27),27,' ')) ||
667: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information7)),' '),1,27),27,' ')) ||
668: format_data_string(lpad(to_char(to_number(nvl(action_information8,'0'))*100),6,'0')) ||
669: format_data_string(rpad(' ',6,' ')) ||
670: format_data_string(nvl(action_information10,' ')) ||

Line 667: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information7)),' '),1,27),27,' ')) ||

663: format_data_string(rpad(action_information3,10,' ')) ||
664: format_data_string(nvl(action_information4,' ')) ||
665: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information5)),' '),1,27),27,' ')) ||
666: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information6)),' '),1,27),27,' ')) ||
667: format_data_string(rpad(substr(nvl(pay_mx_rules.STRIP_SPL_CHARS(upper(action_information7)),' '),1,27),27,' ')) ||
668: format_data_string(lpad(to_char(to_number(nvl(action_information8,'0'))*100),6,'0')) ||
669: format_data_string(rpad(' ',6,' ')) ||
670: format_data_string(nvl(action_information10,' ')) ||
671: format_data_string(nvl(action_information11,' ')) ||