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

Line 592: AND fnd_date.canonical_to_date(pae.aei_information3) >=

588: AND pae.aei_information1 = p_tax_yr
589: AND pae.aei_information_category ='PER_IN_MEDICAL_BILLS'
590: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))
591: AND trunc(creation_date) <= nvl(p_created_to,to_date('31-12-4712','DD-MM-YYYY'))
592: AND fnd_date.canonical_to_date(pae.aei_information3) >=
593: (select min(effective_start_date)
594: from per_assignments_f
595: where assignment_id = p_assignment_id)
596: AND pae.aei_information7 IS NOT NULL;

Line 606: AND fnd_date.canonical_to_date(pae.aei_information3) >=

602: AND pae.aei_information1 = p_tax_yr
603: AND pae.aei_information_category ='PER_IN_MEDICAL_BILLS'
604: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))
605: AND trunc(creation_date) <= nvl(p_created_to,to_date('31-12-4712','DD-MM-YYYY'))
606: AND fnd_date.canonical_to_date(pae.aei_information3) >=
607: (select min(effective_start_date)
608: from per_assignments_f
609: where assignment_id = p_assignment_id)
610: AND pae.aei_information7 IS NULL;

Line 672: AND fnd_date.canonical_to_date(pae.aei_information13) >=

668: AND pae.aei_information_category ='PER_IN_LTC_BILLS'
669: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))
670: AND trunc(creation_date) <= nvl(p_created_to,to_date('31-12-4712','DD-MM-YYYY'))
671: AND pae.aei_information10 IS NOT NULL
672: AND fnd_date.canonical_to_date(pae.aei_information13) >=
673: (select min(effective_start_date)
674: from per_assignments_f
675: where assignment_id = p_assignment_id)
676: AND NVL(pae.aei_information18,'N') =nvl(p_carry_over,'N') ;

Line 687: AND fnd_date.canonical_to_date(pae.aei_information13) >=

683: AND pae.aei_information_category ='PER_IN_LTC_BILLS'
684: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))
685: AND trunc(creation_date) <= nvl(p_created_to,to_date('31-12-4712','DD-MM-YYYY'))
686: AND pae.aei_information10 IS NULL
687: AND fnd_date.canonical_to_date(pae.aei_information13) >=
688: (select min(effective_start_date)
689: from per_assignments_f
690: where assignment_id = p_assignment_id)
691: AND NVL(pae.aei_information18,'N') = nvl(p_carry_over,'N');

Line 750: AND fnd_date.canonical_to_date(pae.aei_information3) >=

746: AND pae.aei_information1 = p_tax_yr
747: AND pae.aei_information_category ='PER_IN_MEDICAL_BILLS'
748: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))
749: AND trunc(creation_date) <= nvl(p_created_to,to_date('31-12-4712','DD-MM-YYYY'))
750: AND fnd_date.canonical_to_date(pae.aei_information3) >=
751: (select min(effective_start_date)
752: from per_assignments_f
753: where assignment_id = p_assignment_id)
754: AND pae.aei_information7 IS NOT NULL;

Line 764: AND fnd_date.canonical_to_date(pae.aei_information3) >=

760: AND pae.aei_information1 = p_tax_yr
761: AND pae.aei_information_category ='PER_IN_MEDICAL_BILLS'
762: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))
763: AND trunc(creation_date) <= nvl(p_created_to,to_date('31-12-4712','DD-MM-YYYY'))
764: AND fnd_date.canonical_to_date(pae.aei_information3) >=
765: (select min(effective_start_date)
766: from per_assignments_f
767: where assignment_id = p_assignment_id)
768: AND pae.aei_information7 IS NULL;

Line 825: AND fnd_date.canonical_to_date(pae.aei_information13) >=

821: AND pae.aei_information1 = p_tax_yr
822: AND pae.aei_information_category ='PER_IN_LTC_BILLS'
823: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))
824: AND trunc(creation_date) <= nvl(p_created_to,to_date('31-12-4712','DD-MM-YYYY'))
825: AND fnd_date.canonical_to_date(pae.aei_information13) >=
826: (select min(effective_start_date)
827: from per_assignments_f
828: where assignment_id = p_assignment_id)
829: AND pae.aei_information10 IS NOT NULL

Line 898: AND fnd_date.canonical_to_date(pae.aei_information3) >=

894: AND pae.aei_information1 = p_tax_yr
895: AND pae.aei_information_category ='PER_IN_MEDICAL_BILLS'
896: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))
897: AND trunc(creation_date) <= nvl(p_created_to,to_date('31-12-4712','DD-MM-YYYY'))
898: AND fnd_date.canonical_to_date(pae.aei_information3) >=
899: (select min(effective_start_date)
900: from per_assignments_f
901: where assignment_id = p_assignment_id)
902: AND pae.aei_information7 IS NOT NULL;

Line 912: AND fnd_date.canonical_to_date(pae.aei_information3) >=

908: AND pae.aei_information1 = p_tax_yr
909: AND pae.aei_information_category ='PER_IN_MEDICAL_BILLS'
910: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))
911: AND trunc(creation_date) <= nvl(p_created_to,to_date('31-12-4712','DD-MM-YYYY'))
912: AND fnd_date.canonical_to_date(pae.aei_information3) >=
913: (select min(effective_start_date)
914: from per_assignments_f
915: where assignment_id = p_assignment_id)
916: AND pae.aei_information7 IS NULL;

Line 971: AND fnd_date.canonical_to_date(extra.aei_information3) >=

967: and extra.aei_information1 = p_block
968: AND extra.assignment_id = p_assignment_id
969: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))
970: and trunc(creation_date) <= nvl(p_created_to,to_date('31-12-4712','DD-MM-YYYY'))
971: AND fnd_date.canonical_to_date(extra.aei_information3) >=
972: (select min(effective_start_date)
973: from per_assignments_f
974: where assignment_id = p_assignment_id)
975: AND extra.aei_information7 IS not NULL;

Line 988: AND fnd_date.canonical_to_date(extra.aei_information13) >=

984: AND extra.assignment_id = p_assignment_id
985: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))
986: and trunc(creation_date) <= nvl(p_created_to,to_date('31-12-4712','DD-MM-YYYY'))
987: and NVL(extra.aei_information18,'N') = nvl(p_carry_over,'N')
988: AND fnd_date.canonical_to_date(extra.aei_information13) >=
989: (select min(effective_start_date)
990: from per_assignments_f
991: where assignment_id = p_assignment_id)
992: and extra.aei_information10 is not null;

Line 1003: AND fnd_date.canonical_to_date(extra.aei_information3) >=

999: and extra.aei_information1 = p_block
1000: AND extra.assignment_id = p_assignment_id
1001: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))
1002: and trunc(creation_date) <= nvl(p_created_to,to_date('31-12-4712','DD-MM-YYYY'))
1003: AND fnd_date.canonical_to_date(extra.aei_information3) >=
1004: (select min(effective_start_date)
1005: from per_assignments_f
1006: where assignment_id = p_assignment_id)
1007: AND extra.aei_information7 IS NULL;

Line 1021: AND fnd_date.canonical_to_date(extra.aei_information13) >=

1017: AND extra.assignment_id = p_assignment_id
1018: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))
1019: and trunc(creation_date) <= nvl(p_created_to,to_date('31-12-4712','DD-MM-YYYY'))
1020: and NVL(extra.aei_information18,'N') = nvl(p_carry_over,'N')
1021: AND fnd_date.canonical_to_date(extra.aei_information13) >=
1022: (select min(effective_start_date)
1023: from per_assignments_f
1024: where assignment_id = p_assignment_id)
1025: and extra.aei_information10 is null;

Line 1332: p_aei_information3 => fnd_date.date_to_canonical(p_bill_date),

1328: p_information_type => 'PER_IN_MEDICAL_BILLS',
1329: p_aei_information_category => 'PER_IN_MEDICAL_BILLS',
1330: p_aei_information1 => p_financial_yr,
1331: p_aei_information2 => '',
1332: p_aei_information3 => fnd_date.date_to_canonical(p_bill_date),
1333: p_aei_information4 => p_person_id,
1334: p_aei_information5 => p_bill_number,
1335: p_aei_information6 => fnd_number.number_to_canonical(p_new_bill_amt) ,
1336: p_aei_information8 => p_ee_comments,

Line 1354: p_aei_information3 => fnd_date.date_to_canonical(p_bill_date),

1350:
1351: hr_assignment_extra_info_api.update_assignment_extra_info(
1352: p_aei_information1 => p_financial_yr,
1353: p_aei_information2 => '',
1354: p_aei_information3 => fnd_date.date_to_canonical(p_bill_date),
1355: p_aei_information4 => p_con_person_id,
1356: p_aei_information5 => p_bill_number,
1357: p_aei_information6 => fnd_number.number_to_canonical(p_new_bill_amt) ,
1358: p_aei_information8 => p_ee_comments,