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 68: FROM per_assignments_f assgn

64: )
65: IS
66: SELECT types.element_type_id
67: ,link.element_link_id
68: FROM per_assignments_f assgn
69: , pay_element_links_f link
70: , pay_element_types_f types
71: WHERE assgn.assignment_id = p_assignment_id
72: AND link.element_link_id = pay_in_utils.get_element_link_id(p_assignment_id

Line 594: from per_assignments_f

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;
597:
598: CURSOR csr_submitted_unexempt IS

Line 608: from per_assignments_f

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;
611:
612: l_submitted NUMBER;

Line 674: from per_assignments_f

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') ;
677:
678: CURSOR csr_submitted_unexempt IS

Line 689: from per_assignments_f

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');
692:
693: l_submitted NUMBER;

Line 752: from per_assignments_f

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;
755:
756: CURSOR csr_submitted_unexempt IS

Line 766: from per_assignments_f

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;
769:
770: l_exempted NUMBER;

Line 827: from per_assignments_f

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

Line 900: from per_assignments_f

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;
903:
904: CURSOR csr_submitted_unexempt IS

Line 914: from per_assignments_f

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;
917:
918: l_submitted VARCHAR2(10);

Line 973: from per_assignments_f

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;
976:
977:

Line 990: from per_assignments_f

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;
993:
994: CURSOR csr_get_med_date_unappr

Line 1005: from per_assignments_f

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;
1008:
1009:

Line 1023: from per_assignments_f

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