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 PER_ASSIGNMENTS_F

Line 72: FROM per_assignments_f assgn

68: )
69: IS
70: SELECT types.element_type_id
71: ,link.element_link_id
72: FROM per_assignments_f assgn
73: , pay_element_links_f link
74: , pay_element_types_f types
75: WHERE assgn.assignment_id = p_assignment_id
76: AND link.element_link_id = pay_in_utils.get_element_link_id(p_assignment_id

Line 643: from per_assignments_f

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;
646:
647: CURSOR csr_submitted_unexempt IS

Line 657: from per_assignments_f

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;
660:
661: l_submitted NUMBER;

Line 723: from per_assignments_f

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') ;
726:
727: CURSOR csr_submitted_unexempt IS

Line 738: from per_assignments_f

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');
741:
742: l_submitted NUMBER;

Line 801: from per_assignments_f

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;
804:
805: CURSOR csr_submitted_unexempt IS

Line 815: from per_assignments_f

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;
818:
819: l_exempted NUMBER;

Line 876: from per_assignments_f

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
879: and NVL(pae.aei_information18,'N') = nvl(p_carry_over,'N');
880:

Line 949: from per_assignments_f

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;
952:
953: CURSOR csr_submitted_unexempt IS

Line 963: from per_assignments_f

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;
966:
967: l_submitted VARCHAR2(10);

Line 1022: from per_assignments_f

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;
1025:
1026:

Line 1039: from per_assignments_f

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;
1042:
1043: CURSOR csr_get_med_date_unappr

Line 1054: from per_assignments_f

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;
1057:
1058:

Line 1072: from per_assignments_f

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;
1075:
1076: --