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 641: AND fnd_date.canonical_to_date(pae.aei_information3) >=

637: AND pae.aei_information1 = p_tax_yr
638: AND pae.aei_information_category ='PER_IN_MEDICAL_BILLS'
639: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))
640: AND trunc(creation_date) <= nvl(p_created_to,to_date('31-12-4712','DD-MM-YYYY'))
641: AND fnd_date.canonical_to_date(pae.aei_information3) >=
642: (select min(effective_start_date)
643: from per_assignments_f
644: where assignment_id = p_assignment_id)
645: AND pae.aei_information7 IS NOT NULL;

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

651: AND pae.aei_information1 = p_tax_yr
652: AND pae.aei_information_category ='PER_IN_MEDICAL_BILLS'
653: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))
654: AND trunc(creation_date) <= nvl(p_created_to,to_date('31-12-4712','DD-MM-YYYY'))
655: AND fnd_date.canonical_to_date(pae.aei_information3) >=
656: (select min(effective_start_date)
657: from per_assignments_f
658: where assignment_id = p_assignment_id)
659: AND pae.aei_information7 IS NULL;

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

717: AND pae.aei_information_category ='PER_IN_LTC_BILLS'
718: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))
719: AND trunc(creation_date) <= nvl(p_created_to,to_date('31-12-4712','DD-MM-YYYY'))
720: AND pae.aei_information10 IS NOT NULL
721: AND fnd_date.canonical_to_date(pae.aei_information13) >=
722: (select min(effective_start_date)
723: from per_assignments_f
724: where assignment_id = p_assignment_id)
725: AND NVL(pae.aei_information18,'N') =nvl(p_carry_over,'N') ;

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

732: AND pae.aei_information_category ='PER_IN_LTC_BILLS'
733: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))
734: AND trunc(creation_date) <= nvl(p_created_to,to_date('31-12-4712','DD-MM-YYYY'))
735: AND pae.aei_information10 IS NULL
736: AND fnd_date.canonical_to_date(pae.aei_information13) >=
737: (select min(effective_start_date)
738: from per_assignments_f
739: where assignment_id = p_assignment_id)
740: AND NVL(pae.aei_information18,'N') = nvl(p_carry_over,'N');

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

795: AND pae.aei_information1 = p_tax_yr
796: AND pae.aei_information_category ='PER_IN_MEDICAL_BILLS'
797: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))
798: AND trunc(creation_date) <= nvl(p_created_to,to_date('31-12-4712','DD-MM-YYYY'))
799: AND fnd_date.canonical_to_date(pae.aei_information3) >=
800: (select min(effective_start_date)
801: from per_assignments_f
802: where assignment_id = p_assignment_id)
803: AND pae.aei_information7 IS NOT NULL;

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

809: AND pae.aei_information1 = p_tax_yr
810: AND pae.aei_information_category ='PER_IN_MEDICAL_BILLS'
811: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))
812: AND trunc(creation_date) <= nvl(p_created_to,to_date('31-12-4712','DD-MM-YYYY'))
813: AND fnd_date.canonical_to_date(pae.aei_information3) >=
814: (select min(effective_start_date)
815: from per_assignments_f
816: where assignment_id = p_assignment_id)
817: AND pae.aei_information7 IS NULL;

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

870: AND pae.aei_information1 = p_tax_yr
871: AND pae.aei_information_category ='PER_IN_LTC_BILLS'
872: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))
873: AND trunc(creation_date) <= nvl(p_created_to,to_date('31-12-4712','DD-MM-YYYY'))
874: AND fnd_date.canonical_to_date(pae.aei_information13) >=
875: (select min(effective_start_date)
876: from per_assignments_f
877: where assignment_id = p_assignment_id)
878: AND pae.aei_information10 IS NOT NULL

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

943: AND pae.aei_information1 = p_tax_yr
944: AND pae.aei_information_category ='PER_IN_MEDICAL_BILLS'
945: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))
946: AND trunc(creation_date) <= nvl(p_created_to,to_date('31-12-4712','DD-MM-YYYY'))
947: AND fnd_date.canonical_to_date(pae.aei_information3) >=
948: (select min(effective_start_date)
949: from per_assignments_f
950: where assignment_id = p_assignment_id)
951: AND pae.aei_information7 IS NOT NULL;

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

957: AND pae.aei_information1 = p_tax_yr
958: AND pae.aei_information_category ='PER_IN_MEDICAL_BILLS'
959: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))
960: AND trunc(creation_date) <= nvl(p_created_to,to_date('31-12-4712','DD-MM-YYYY'))
961: AND fnd_date.canonical_to_date(pae.aei_information3) >=
962: (select min(effective_start_date)
963: from per_assignments_f
964: where assignment_id = p_assignment_id)
965: AND pae.aei_information7 IS NULL;

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

1016: and extra.aei_information1 = p_block
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 fnd_date.canonical_to_date(extra.aei_information3) >=
1021: (select min(effective_start_date)
1022: from per_assignments_f
1023: where assignment_id = p_assignment_id)
1024: AND extra.aei_information7 IS not NULL;

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

1033: AND extra.assignment_id = p_assignment_id
1034: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))
1035: and trunc(creation_date) <= nvl(p_created_to,to_date('31-12-4712','DD-MM-YYYY'))
1036: and NVL(extra.aei_information18,'N') = nvl(p_carry_over,'N')
1037: AND fnd_date.canonical_to_date(extra.aei_information13) >=
1038: (select min(effective_start_date)
1039: from per_assignments_f
1040: where assignment_id = p_assignment_id)
1041: and extra.aei_information10 is not null;

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

1048: and extra.aei_information1 = p_block
1049: AND extra.assignment_id = p_assignment_id
1050: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))
1051: and trunc(creation_date) <= nvl(p_created_to,to_date('31-12-4712','DD-MM-YYYY'))
1052: AND fnd_date.canonical_to_date(extra.aei_information3) >=
1053: (select min(effective_start_date)
1054: from per_assignments_f
1055: where assignment_id = p_assignment_id)
1056: AND extra.aei_information7 IS NULL;

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

1066: AND extra.assignment_id = p_assignment_id
1067: AND trunc(creation_date) >= nvl(p_created_from,to_date('01-01-1901','DD-MM-YYYY'))
1068: and trunc(creation_date) <= nvl(p_created_to,to_date('31-12-4712','DD-MM-YYYY'))
1069: and NVL(extra.aei_information18,'N') = nvl(p_carry_over,'N')
1070: AND fnd_date.canonical_to_date(extra.aei_information13) >=
1071: (select min(effective_start_date)
1072: from per_assignments_f
1073: where assignment_id = p_assignment_id)
1074: and extra.aei_information10 is null;

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

1377: p_information_type => 'PER_IN_MEDICAL_BILLS',
1378: p_aei_information_category => 'PER_IN_MEDICAL_BILLS',
1379: p_aei_information1 => p_financial_yr,
1380: p_aei_information2 => '',
1381: p_aei_information3 => fnd_date.date_to_canonical(p_bill_date),
1382: p_aei_information4 => p_person_id,
1383: p_aei_information5 => p_bill_number,
1384: p_aei_information6 => fnd_number.number_to_canonical(p_new_bill_amt) ,
1385: p_aei_information8 => p_ee_comments,

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

1399:
1400: hr_assignment_extra_info_api.update_assignment_extra_info(
1401: p_aei_information1 => p_financial_yr,
1402: p_aei_information2 => '',
1403: p_aei_information3 => fnd_date.date_to_canonical(p_bill_date),
1404: p_aei_information4 => p_con_person_id,
1405: p_aei_information5 => p_bill_number,
1406: p_aei_information6 => fnd_number.number_to_canonical(p_new_bill_amt) ,
1407: p_aei_information8 => p_ee_comments,