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_FI_TELR dependencies on FND_DATE

Line 64: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION5),'DDMMYY'))

60: )
61: IS
62: SELECT ACTION_INFORMATION4 FIRST_CODE,
63: decode(ACTION_INFORMATION6,null,
64: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION5),'DDMMYY'))
65: ,(to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION5),'DDMMYY'))||
66: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION6),'DDMMYY')) ) FIRSTDATEPAIR,
67: ACTION_INFORMATION7 SECOND_CODE,
68: decode(ACTION_INFORMATION9,null,

Line 65: ,(to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION5),'DDMMYY'))||

61: IS
62: SELECT ACTION_INFORMATION4 FIRST_CODE,
63: decode(ACTION_INFORMATION6,null,
64: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION5),'DDMMYY'))
65: ,(to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION5),'DDMMYY'))||
66: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION6),'DDMMYY')) ) FIRSTDATEPAIR,
67: ACTION_INFORMATION7 SECOND_CODE,
68: decode(ACTION_INFORMATION9,null,
69: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION8),'DDMMYY'))

Line 66: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION6),'DDMMYY')) ) FIRSTDATEPAIR,

62: SELECT ACTION_INFORMATION4 FIRST_CODE,
63: decode(ACTION_INFORMATION6,null,
64: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION5),'DDMMYY'))
65: ,(to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION5),'DDMMYY'))||
66: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION6),'DDMMYY')) ) FIRSTDATEPAIR,
67: ACTION_INFORMATION7 SECOND_CODE,
68: decode(ACTION_INFORMATION9,null,
69: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION8),'DDMMYY'))
70: ,(to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION8),'DDMMYY'))||

Line 69: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION8),'DDMMYY'))

65: ,(to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION5),'DDMMYY'))||
66: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION6),'DDMMYY')) ) FIRSTDATEPAIR,
67: ACTION_INFORMATION7 SECOND_CODE,
68: decode(ACTION_INFORMATION9,null,
69: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION8),'DDMMYY'))
70: ,(to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION8),'DDMMYY'))||
71: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION9),'DDMMYY')) ) SECONDDATEPAIR,
72: ACTION_INFORMATION10 THIRD_CODE,
73: decode(ACTION_INFORMATION12,null,

Line 70: ,(to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION8),'DDMMYY'))||

66: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION6),'DDMMYY')) ) FIRSTDATEPAIR,
67: ACTION_INFORMATION7 SECOND_CODE,
68: decode(ACTION_INFORMATION9,null,
69: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION8),'DDMMYY'))
70: ,(to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION8),'DDMMYY'))||
71: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION9),'DDMMYY')) ) SECONDDATEPAIR,
72: ACTION_INFORMATION10 THIRD_CODE,
73: decode(ACTION_INFORMATION12,null,
74: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION11),'DDMMYY'))

Line 71: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION9),'DDMMYY')) ) SECONDDATEPAIR,

67: ACTION_INFORMATION7 SECOND_CODE,
68: decode(ACTION_INFORMATION9,null,
69: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION8),'DDMMYY'))
70: ,(to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION8),'DDMMYY'))||
71: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION9),'DDMMYY')) ) SECONDDATEPAIR,
72: ACTION_INFORMATION10 THIRD_CODE,
73: decode(ACTION_INFORMATION12,null,
74: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION11),'DDMMYY'))
75: ,(to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION11),'DDMMYY'))||

Line 74: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION11),'DDMMYY'))

70: ,(to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION8),'DDMMYY'))||
71: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION9),'DDMMYY')) ) SECONDDATEPAIR,
72: ACTION_INFORMATION10 THIRD_CODE,
73: decode(ACTION_INFORMATION12,null,
74: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION11),'DDMMYY'))
75: ,(to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION11),'DDMMYY'))||
76: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION12),'DDMMYY')) ) THIRDDATEPAIR
77: , PAI.*
78: FROM PAY_ACTION_INFORMATION PAI

Line 75: ,(to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION11),'DDMMYY'))||

71: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION9),'DDMMYY')) ) SECONDDATEPAIR,
72: ACTION_INFORMATION10 THIRD_CODE,
73: decode(ACTION_INFORMATION12,null,
74: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION11),'DDMMYY'))
75: ,(to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION11),'DDMMYY'))||
76: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION12),'DDMMYY')) ) THIRDDATEPAIR
77: , PAI.*
78: FROM PAY_ACTION_INFORMATION PAI
79: WHERE ACTION_CONTEXT_TYPE = 'AAP'

Line 76: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION12),'DDMMYY')) ) THIRDDATEPAIR

72: ACTION_INFORMATION10 THIRD_CODE,
73: decode(ACTION_INFORMATION12,null,
74: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION11),'DDMMYY'))
75: ,(to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION11),'DDMMYY'))||
76: (to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION12),'DDMMYY')) ) THIRDDATEPAIR
77: , PAI.*
78: FROM PAY_ACTION_INFORMATION PAI
79: WHERE ACTION_CONTEXT_TYPE = 'AAP'
80: AND ACTION_INFORMATION_CATEGORY='EMEA REPORT INFORMATION'

Line 354: TEL_DATA(l_counter).TagValue := fnd_date.canonical_to_date(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION9);

350: l_counter := l_counter + 1;
351: -- Find the Action Id here
352:
353: TEL_DATA(l_counter).TagName := 'START_DATE';
354: TEL_DATA(l_counter).TagValue := fnd_date.canonical_to_date(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION9);
355: l_counter := l_counter + 1;
356:
357: TEL_DATA(l_counter).TagName := 'START_DATE_DDMMYY';
358: TEL_DATA(l_counter).TagValue := to_char(fnd_date.canonical_to_date(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION9),'DDMMYY');

Line 358: TEL_DATA(l_counter).TagValue := to_char(fnd_date.canonical_to_date(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION9),'DDMMYY');

354: TEL_DATA(l_counter).TagValue := fnd_date.canonical_to_date(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION9);
355: l_counter := l_counter + 1;
356:
357: TEL_DATA(l_counter).TagName := 'START_DATE_DDMMYY';
358: TEL_DATA(l_counter).TagValue := to_char(fnd_date.canonical_to_date(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION9),'DDMMYY');
359: l_counter := l_counter + 1;
360:
361: -- This Target year has to be included in case of only ACTION ID 2
362: -- Find if from g_effective date of Report prameters

Line 365: -- L_TARGET_YEAR := to_char(fnd_date.canonical_to_date(LR_REPORT_DETAILS.ACTION_INFORMATION8),'RRRR');

361: -- This Target year has to be included in case of only ACTION ID 2
362: -- Find if from g_effective date of Report prameters
363: --IF LR_REPORT_DETAILS.ACTION_INFORMATION8 = 'Y'
364: --THEN
365: -- L_TARGET_YEAR := to_char(fnd_date.canonical_to_date(LR_REPORT_DETAILS.ACTION_INFORMATION8),'RRRR');
366: --ELSE
367: L_TARGET_YEAR := null;
368: -- END IF;
369:

Line 414: -- TEL_DATA(l_counter).TagValue := fnd_date.canonical_to_date(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION9);

410: l_counter := l_counter + 1;
411:
412: TEL_DATA(l_counter).TagName := 'CAUSE_OF_TERMINATION';
413: TEL_DATA(l_counter).TagValue := NULL;
414: -- TEL_DATA(l_counter).TagValue := fnd_date.canonical_to_date(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION9);
415: l_counter := l_counter + 1;
416:
417: TEL_DATA(l_counter).TagName := 'YEARLY_TEL_INCOME_PRIOR';
418: TEL_DATA(l_counter).TagValue := NULL;

Line 430: --TEL_DATA(l_counter).TagValue := fnd_date.canonical_to_date( lr_TEL_PERSON_DETAILS.ACTION_INFORMATION9 );

426: l_counter := l_counter + 1;
427:
428: TEL_DATA(l_counter).TagName :='LEL_EMPLOYMENT_START_DATE';
429: TEL_DATA(l_counter).TagValue := NULL;
430: --TEL_DATA(l_counter).TagValue := fnd_date.canonical_to_date( lr_TEL_PERSON_DETAILS.ACTION_INFORMATION9 );
431: l_counter := l_counter + 1;
432:
433: TEL_DATA(l_counter).TagName :='LEL_EMPLOYMENT_START_DATE_DDMMYY';
434: TEL_DATA(l_counter).TagValue := NULL;

Line 435: --TEL_DATA(l_counter).TagValue := fnd_date.canonical_to_date( lr_TEL_PERSON_DETAILS.ACTION_INFORMATION9 );

431: l_counter := l_counter + 1;
432:
433: TEL_DATA(l_counter).TagName :='LEL_EMPLOYMENT_START_DATE_DDMMYY';
434: TEL_DATA(l_counter).TagValue := NULL;
435: --TEL_DATA(l_counter).TagValue := fnd_date.canonical_to_date( lr_TEL_PERSON_DETAILS.ACTION_INFORMATION9 );
436: l_counter := l_counter + 1;
437:
438: -- find it If there is change in Pension Group report the date of starting new record from EIT
439:

Line 495: TEL_DATA(l_counter).TagValue := fnd_date.canonical_to_date( lr_TEL_PERSON_DETAILS.ACTION_INFORMATION9 );

491: l_counter := l_counter + 1;
492: -- Find the Action Id here
493:
494: TEL_DATA(l_counter).TagName := 'START_DATE';
495: TEL_DATA(l_counter).TagValue := fnd_date.canonical_to_date( lr_TEL_PERSON_DETAILS.ACTION_INFORMATION9 );
496: l_counter := l_counter + 1;
497:
498: TEL_DATA(l_counter).TagName := 'START_DATE_DDMMYY';
499: TEL_DATA(l_counter).TagValue := TO_CHAR(fnd_date.canonical_to_date( lr_TEL_PERSON_DETAILS.ACTION_INFORMATION9 ),'DDMMYY');

Line 499: TEL_DATA(l_counter).TagValue := TO_CHAR(fnd_date.canonical_to_date( lr_TEL_PERSON_DETAILS.ACTION_INFORMATION9 ),'DDMMYY');

495: TEL_DATA(l_counter).TagValue := fnd_date.canonical_to_date( lr_TEL_PERSON_DETAILS.ACTION_INFORMATION9 );
496: l_counter := l_counter + 1;
497:
498: TEL_DATA(l_counter).TagName := 'START_DATE_DDMMYY';
499: TEL_DATA(l_counter).TagValue := TO_CHAR(fnd_date.canonical_to_date( lr_TEL_PERSON_DETAILS.ACTION_INFORMATION9 ),'DDMMYY');
500: l_counter := l_counter + 1;
501:
502: -- Find if from g_effective date of Report prameters
503:

Line 504: L_TARGET_YEAR := to_char(fnd_date.canonical_to_date(LR_REPORT_DETAILS.ACTION_INFORMATION9),'RRRR');

500: l_counter := l_counter + 1;
501:
502: -- Find if from g_effective date of Report prameters
503:
504: L_TARGET_YEAR := to_char(fnd_date.canonical_to_date(LR_REPORT_DETAILS.ACTION_INFORMATION9),'RRRR');
505:
506: TEL_DATA(l_counter).TagName := 'TARGET_YEAR_FOR_ANNUAL_INCOME';
507: TEL_DATA(l_counter).TagValue := L_TARGET_YEAR;
508: l_counter := l_counter + 1;

Line 528: -- TEL_DATA(l_counter).TagValue :=fnd_date.canonical_to_date(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION8);

524: */
525:
526: TEL_DATA(l_counter).TagName := 'TERMINATION_DATE';
527: TEL_DATA(l_counter).TagValue := NULL;
528: -- TEL_DATA(l_counter).TagValue :=fnd_date.canonical_to_date(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION8);
529: l_counter := l_counter + 1;
530:
531: TEL_DATA(l_counter).TagName := 'TERMINATION_DATE_DDMMYY';
532: TEL_DATA(l_counter).TagValue := NULL;

Line 626: TEL_DATA(l_counter).TagValue := fnd_date.canonical_to_date(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION9 );

622: l_counter := l_counter + 1;
623: -- Find the Action Id here
624:
625: TEL_DATA(l_counter).TagName := 'START_DATE';
626: TEL_DATA(l_counter).TagValue := fnd_date.canonical_to_date(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION9 );
627: l_counter := l_counter + 1;
628:
629: TEL_DATA(l_counter).TagName := 'START_DATE_DDMMYY';
630: TEL_DATA(l_counter).TagValue := TO_CHAR(fnd_date.canonical_to_date( lr_TEL_PERSON_DETAILS.ACTION_INFORMATION9 ),'DDMMYY');

Line 630: TEL_DATA(l_counter).TagValue := TO_CHAR(fnd_date.canonical_to_date( lr_TEL_PERSON_DETAILS.ACTION_INFORMATION9 ),'DDMMYY');

626: TEL_DATA(l_counter).TagValue := fnd_date.canonical_to_date(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION9 );
627: l_counter := l_counter + 1;
628:
629: TEL_DATA(l_counter).TagName := 'START_DATE_DDMMYY';
630: TEL_DATA(l_counter).TagValue := TO_CHAR(fnd_date.canonical_to_date( lr_TEL_PERSON_DETAILS.ACTION_INFORMATION9 ),'DDMMYY');
631: l_counter := l_counter + 1;
632:
633: -- Find if from g_effective date of Report prameters
634:

Line 637: --L_TARGET_YEAR := to_char(fnd_date.canonical_to_date(LR_REPORT_DETAILS.ACTION_INFORMATION8),'RRRR');

633: -- Find if from g_effective date of Report prameters
634:
635: --IF LR_REPORT_DETAILS.ACTION_INFORMATION8 = 'Y'
636: --THEN
637: --L_TARGET_YEAR := to_char(fnd_date.canonical_to_date(LR_REPORT_DETAILS.ACTION_INFORMATION8),'RRRR');
638: --ELSE
639: L_TARGET_YEAR := null;
640: --END IF;
641:

Line 677: TEL_DATA(l_counter).TagValue :=fnd_date.canonical_to_date(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION16);

673: l_counter := l_counter + 1;
674:
675: */
676: TEL_DATA(l_counter).TagName := 'TERMINATION_DATE';
677: TEL_DATA(l_counter).TagValue :=fnd_date.canonical_to_date(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION16);
678: l_counter := l_counter + 1;
679:
680: TEL_DATA(l_counter).TagName := 'TERMINATION_DATE_DDMMYY';
681: TEL_DATA(l_counter).TagValue :=TO_CHAR(fnd_date.canonical_to_date(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION16),'DDMMYY');

Line 681: TEL_DATA(l_counter).TagValue :=TO_CHAR(fnd_date.canonical_to_date(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION16),'DDMMYY');

677: TEL_DATA(l_counter).TagValue :=fnd_date.canonical_to_date(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION16);
678: l_counter := l_counter + 1;
679:
680: TEL_DATA(l_counter).TagName := 'TERMINATION_DATE_DDMMYY';
681: TEL_DATA(l_counter).TagValue :=TO_CHAR(fnd_date.canonical_to_date(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION16),'DDMMYY');
682: l_counter := l_counter + 1;
683:
684:
685: TEL_DATA(l_counter).TagName := 'CAUSE_OF_TERMINATION';

Line 696: TEL_DATA(l_counter).TagValue := TO_CHAR(fnd_date.canonical_to_date(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION16),'YYYY');

692:
693: IF NVL(FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION18) + FND_NUMBER.CANONICAL_TO_NUMBER(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION19) ,0) > 0 THEN
694:
695: TEL_DATA(l_counter).TagName := 'TARGET_YEAR_FOR_TERM';
696: TEL_DATA(l_counter).TagValue := TO_CHAR(fnd_date.canonical_to_date(lr_TEL_PERSON_DETAILS.ACTION_INFORMATION16),'YYYY');
697: l_counter := l_counter + 1;
698:
699: END IF;
700:

Line 874: -- p_pei_information7 =>FND_DATE.DATE_TO_CANONICAL(LR_REPORT_DETAILS.ACTION_INFORMATION8 )

870: -- p_pei_information3 => lr_PERSON_EIT.pei_information3,
871: p_pei_information4 => lr_TEL_PERSON_DETAILS.ACTION_INFORMATION9,
872: p_pei_information5 => 'Y'
873: -- p_pei_information6 => 'U',
874: -- p_pei_information7 =>FND_DATE.DATE_TO_CANONICAL(LR_REPORT_DETAILS.ACTION_INFORMATION8 )
875: );
876: END IF;
877: END IF;
878: CLOSE CSR_PERSON_EIT;

Line 910: -- p_pei_information7 =>FND_DATE.DATE_TO_CANONICAL(LR_REPORT_DETAILS.ACTION_INFORMATION8 )

906: -- p_pei_information3 => lr_PERSON_EIT.pei_information3,
907: p_pei_information4 => lr_TEL_PERSON_DETAILS.ACTION_INFORMATION27,
908: p_pei_information5 => 'Y'
909: -- p_pei_information6 => 'U',
910: -- p_pei_information7 =>FND_DATE.DATE_TO_CANONICAL(LR_REPORT_DETAILS.ACTION_INFORMATION8 )
911: );
912: END IF;
913: END IF;
914: CLOSE CSR_PERSON_EIT;

Line 947: -- p_pei_information7 =>FND_DATE.DATE_TO_CANONICAL(LR_REPORT_DETAILS.ACTION_INFORMATION8 )

943: -- p_pei_information3 => lr_PERSON_EIT.pei_information3,
944: p_pei_information4 => lr_TEL_PERSON_DETAILS.ACTION_INFORMATION26,
945: p_pei_information5 => 'Y'
946: -- p_pei_information6 => 'U',
947: -- p_pei_information7 =>FND_DATE.DATE_TO_CANONICAL(LR_REPORT_DETAILS.ACTION_INFORMATION8 )
948: );
949: END IF;
950: END IF;
951: CLOSE CSR_PERSON_EIT;

Line 985: -- p_pei_information7 =>FND_DATE.DATE_TO_CANONICAL(LR_REPORT_DETAILS.ACTION_INFORMATION8 )

981: -- p_pei_information3 => lr_PERSON_EIT.pei_information3,
982: p_pei_information4 => lr_TEL_PERSON_DETAILS.ACTION_INFORMATION21,
983: p_pei_information5 => 'Y'
984: -- p_pei_information6 => 'U',
985: -- p_pei_information7 =>FND_DATE.DATE_TO_CANONICAL(LR_REPORT_DETAILS.ACTION_INFORMATION8 )
986: );
987: END IF;
988: END IF;
989: CLOSE CSR_PERSON_EIT;

Line 1022: -- p_pei_information7 =>FND_DATE.DATE_TO_CANONICAL(LR_REPORT_DETAILS.ACTION_INFORMATION8 )

1018: -- p_pei_information3 => lr_PERSON_EIT.pei_information3,
1019: p_pei_information4 => lr_TEL_PERSON_DETAILS.ACTION_INFORMATION28,
1020: p_pei_information5 => 'Y'
1021: -- p_pei_information6 => 'U',
1022: -- p_pei_information7 =>FND_DATE.DATE_TO_CANONICAL(LR_REPORT_DETAILS.ACTION_INFORMATION8 )
1023: );
1024: END IF;
1025: END IF;
1026: