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.PER_CN_ORG_INFO_LEG_HOOK dependencies on FND_DATE

Line 50: AND p_effective_start_date BETWEEN fnd_date.canonical_to_date(org_information15)

46: WHERE org_information_context= 'PER_CONT_AREA_CONT_BASE_CN'
47: AND org_information1 = p_org_information1
48: AND org_information2 = p_org_information2
49: AND nvl(org_information3,'X') = nvl(p_org_information3,'X')
50: AND p_effective_start_date BETWEEN fnd_date.canonical_to_date(org_information15)
51: AND fnd_date.canonical_to_date(NVL(org_information16,'4712/12/31 00:00:00'))
52: AND organization_id = p_organization_id
53: AND (org_information_id <> p_org_information_id
54: OR p_org_information_id IS NULL);

Line 51: AND fnd_date.canonical_to_date(NVL(org_information16,'4712/12/31 00:00:00'))

47: AND org_information1 = p_org_information1
48: AND org_information2 = p_org_information2
49: AND nvl(org_information3,'X') = nvl(p_org_information3,'X')
50: AND p_effective_start_date BETWEEN fnd_date.canonical_to_date(org_information15)
51: AND fnd_date.canonical_to_date(NVL(org_information16,'4712/12/31 00:00:00'))
52: AND organization_id = p_organization_id
53: AND (org_information_id <> p_org_information_id
54: OR p_org_information_id IS NULL);
55:

Line 66: AND p_effective_start_date BETWEEN fnd_date.canonical_to_date(org_information10)

62: AND org_information1 = p_org_information1
63: AND nvl(org_information2,'X') = nvl(p_org_information2,'X')
64: AND org_information3 = p_org_information3
65: AND nvl(org_information9,'X') = nvl(p_org_information4,'X')
66: AND p_effective_start_date BETWEEN fnd_date.canonical_to_date(org_information10)
67: AND fnd_date.canonical_to_date(NVL(org_information11,'4712/12/31 00:00:00'))
68: AND organization_id = p_organization_id
69: AND (org_information_id <> p_org_information_id
70: OR p_org_information_id IS NULL) ;

Line 67: AND fnd_date.canonical_to_date(NVL(org_information11,'4712/12/31 00:00:00'))

63: AND nvl(org_information2,'X') = nvl(p_org_information2,'X')
64: AND org_information3 = p_org_information3
65: AND nvl(org_information9,'X') = nvl(p_org_information4,'X')
66: AND p_effective_start_date BETWEEN fnd_date.canonical_to_date(org_information10)
67: AND fnd_date.canonical_to_date(NVL(org_information11,'4712/12/31 00:00:00'))
68: AND organization_id = p_organization_id
69: AND (org_information_id <> p_org_information_id
70: OR p_org_information_id IS NULL) ;
71:

Line 74: SELECT min(fnd_date.canonical_to_date(org_information15))

70: OR p_org_information_id IS NULL) ;
71:
72: CURSOR csr_future_rec_cont_base
73: IS
74: SELECT min(fnd_date.canonical_to_date(org_information15))
75: FROM hr_organization_information
76: WHERE org_information1 = p_org_information1
77: AND org_information2 = p_org_information2
78: AND nvl(org_information3,'X') = nvl(p_org_information3,'X')

Line 81: AND fnd_date.canonical_to_date(org_information15) > p_effective_start_date

77: AND org_information2 = p_org_information2
78: AND nvl(org_information3,'X') = nvl(p_org_information3,'X')
79: AND org_information_context='PER_CONT_AREA_CONT_BASE_CN'
80: AND NVL(org_information_id,-1) <> NVL(p_org_information_id,-1)
81: AND fnd_date.canonical_to_date(org_information15) > p_effective_start_date
82: AND organization_id = p_organization_id
83: AND (org_information_id <> p_org_information_id
84: OR p_org_information_id IS NULL);
85:

Line 88: SELECT min(fnd_date.canonical_to_date(org_information10))

84: OR p_org_information_id IS NULL);
85:
86: CURSOR csr_future_rec_phfsi_base
87: IS
88: SELECT min(fnd_date.canonical_to_date(org_information10))
89: FROM hr_organization_information
90: WHERE org_information1 = p_org_information1
91: AND NVL(org_information2,'X') = NVL(p_org_information2,'X')
92: AND nvl(org_information3,'X') = nvl(p_org_information3,'X')

Line 96: AND fnd_date.canonical_to_date(org_information10) > p_effective_start_date

92: AND nvl(org_information3,'X') = nvl(p_org_information3,'X')
93: AND org_information_context='PER_CONT_AREA_PHF_SI_RATES_CN'
94: AND nvl(org_information9,'X') = nvl(p_org_information4,'X') --Added for bug 9358335
95: AND NVL(org_information_id,-1) <> NVL(p_org_information_id,-1)
96: AND fnd_date.canonical_to_date(org_information10) > p_effective_start_date
97: AND organization_id = p_organization_id
98: AND (org_information_id <> p_org_information_id
99: OR p_org_information_id IS NULL);
100:

Line 203: fnd_date.canonical_to_date(NVL(hoi.org_information3,'1900/01/01 00:00:00'))

199: FROM hr_organization_information hoi
200: WHERE hoi.organization_id = p_organization_id
201: AND hoi.org_information_context = p_org_info_type_code
202: AND p_effective_start_date BETWEEN
203: fnd_date.canonical_to_date(NVL(hoi.org_information3,'1900/01/01 00:00:00'))
204: AND fnd_date.canonical_to_date(NVL(hoi.org_information4,'4712/12/31 00:00:00'))
205: AND (org_information_id <>p_org_information_id OR p_org_information_id IS NULL);
206:
207:

Line 204: AND fnd_date.canonical_to_date(NVL(hoi.org_information4,'4712/12/31 00:00:00'))

200: WHERE hoi.organization_id = p_organization_id
201: AND hoi.org_information_context = p_org_info_type_code
202: AND p_effective_start_date BETWEEN
203: fnd_date.canonical_to_date(NVL(hoi.org_information3,'1900/01/01 00:00:00'))
204: AND fnd_date.canonical_to_date(NVL(hoi.org_information4,'4712/12/31 00:00:00'))
205: AND (org_information_id <>p_org_information_id OR p_org_information_id IS NULL);
206:
207:
208: CURSOR c_fut_term_info_setup

Line 210: SELECT min(fnd_date.canonical_to_date(org_information3))

206:
207:
208: CURSOR c_fut_term_info_setup
209: IS
210: SELECT min(fnd_date.canonical_to_date(org_information3))
211: FROM hr_organization_information
212: WHERE org_information_context= p_org_info_type_code
213: AND NVL(org_information_id,-1) <> NVL(p_org_information_id,-1)
214: AND fnd_date.canonical_to_date(NVL(org_information3,'1900/01/01 00:00:00')) > p_effective_start_date

Line 214: AND fnd_date.canonical_to_date(NVL(org_information3,'1900/01/01 00:00:00')) > p_effective_start_date

210: SELECT min(fnd_date.canonical_to_date(org_information3))
211: FROM hr_organization_information
212: WHERE org_information_context= p_org_info_type_code
213: AND NVL(org_information_id,-1) <> NVL(p_org_information_id,-1)
214: AND fnd_date.canonical_to_date(NVL(org_information3,'1900/01/01 00:00:00')) > p_effective_start_date
215: AND organization_id = p_organization_id
216: AND (org_information_id <> p_org_information_id
217: OR p_org_information_id IS NULL);
218:

Line 511: l_start_date := fnd_date.canonical_to_date(NVL(p_org_information3,'1900/01/01 00:00:00'));

507:
508: /* Changes for Bug 6943573 start */
509: IF p_org_info_type_code = 'PER_TERM_STAT_INFO_CN' THEN
510:
511: l_start_date := fnd_date.canonical_to_date(NVL(p_org_information3,'1900/01/01 00:00:00'));
512: l_end_date := fnd_date.canonical_to_date(NVL(p_org_information4,'4712/12/31 00:00:00'));
513: validate_date(l_start_date,l_end_date);
514:
515: --call a new procedure to check if any records are overlapping or if any duplicate records are

Line 512: l_end_date := fnd_date.canonical_to_date(NVL(p_org_information4,'4712/12/31 00:00:00'));

508: /* Changes for Bug 6943573 start */
509: IF p_org_info_type_code = 'PER_TERM_STAT_INFO_CN' THEN
510:
511: l_start_date := fnd_date.canonical_to_date(NVL(p_org_information3,'1900/01/01 00:00:00'));
512: l_end_date := fnd_date.canonical_to_date(NVL(p_org_information4,'4712/12/31 00:00:00'));
513: validate_date(l_start_date,l_end_date);
514:
515: --call a new procedure to check if any records are overlapping or if any duplicate records are
516: --existing

Line 527: l_start_date := fnd_date.canonical_to_date(NVL(p_org_information3,'1900/01/01 00:00:00'));

523: );
524:
525: ELSIF p_org_info_type_code = 'PER_TERM_GRE_INFO_CN' THEN
526:
527: l_start_date := fnd_date.canonical_to_date(NVL(p_org_information3,'1900/01/01 00:00:00'));
528: l_end_date := fnd_date.canonical_to_date(NVL(p_org_information4,'4712/12/31 00:00:00'));
529: validate_date(l_start_date,l_end_date);
530:
531: --call a new procedure to check if any records are overlapping or if any duplicate records are

Line 528: l_end_date := fnd_date.canonical_to_date(NVL(p_org_information4,'4712/12/31 00:00:00'));

524:
525: ELSIF p_org_info_type_code = 'PER_TERM_GRE_INFO_CN' THEN
526:
527: l_start_date := fnd_date.canonical_to_date(NVL(p_org_information3,'1900/01/01 00:00:00'));
528: l_end_date := fnd_date.canonical_to_date(NVL(p_org_information4,'4712/12/31 00:00:00'));
529: validate_date(l_start_date,l_end_date);
530:
531: --call a new procedure to check if any records are overlapping or if any duplicate records are
532: --existing

Line 546: l_start_date := fnd_date.canonical_to_date(NVL(p_org_information3,'1900/01/01 00:00:00'));

542: /* Changes for bug 6943573 end */
543: /* Changes for bug 8799060 start */
544: ELSIF p_org_info_type_code = 'PER_SEVERANCE_PAY_TAX_RULE_CN' THEN
545:
546: l_start_date := fnd_date.canonical_to_date(NVL(p_org_information3,'1900/01/01 00:00:00'));
547: l_end_date := fnd_date.canonical_to_date(NVL(p_org_information4,'4712/12/31 00:00:00'));
548: validate_date(l_start_date,l_end_date);
549:
550: --call a new procedure to check if any records are overlapping or if any duplicate records are

Line 547: l_end_date := fnd_date.canonical_to_date(NVL(p_org_information4,'4712/12/31 00:00:00'));

543: /* Changes for bug 8799060 start */
544: ELSIF p_org_info_type_code = 'PER_SEVERANCE_PAY_TAX_RULE_CN' THEN
545:
546: l_start_date := fnd_date.canonical_to_date(NVL(p_org_information3,'1900/01/01 00:00:00'));
547: l_end_date := fnd_date.canonical_to_date(NVL(p_org_information4,'4712/12/31 00:00:00'));
548: validate_date(l_start_date,l_end_date);
549:
550: --call a new procedure to check if any records are overlapping or if any duplicate records are
551: --existing

Line 566: l_start_date := fnd_date.canonical_to_date(p_org_information15);

562: IF g_debug THEN
563: hr_utility.trace('Validating Effective Start Date and Effective End Date');
564: END IF;
565:
566: l_start_date := fnd_date.canonical_to_date(p_org_information15);
567: l_end_date := fnd_date.canonical_to_date(NVL(p_org_information16,'4712/12/31 00:00:00'));
568: validate_date(l_start_date
569: ,l_end_date);
570:

Line 567: l_end_date := fnd_date.canonical_to_date(NVL(p_org_information16,'4712/12/31 00:00:00'));

563: hr_utility.trace('Validating Effective Start Date and Effective End Date');
564: END IF;
565:
566: l_start_date := fnd_date.canonical_to_date(p_org_information15);
567: l_end_date := fnd_date.canonical_to_date(NVL(p_org_information16,'4712/12/31 00:00:00'));
568: validate_date(l_start_date
569: ,l_end_date);
570:
571: IF g_debug THEN

Line 621: l_start_date := fnd_date.canonical_to_date(p_org_information10);

617: IF g_debug THEN
618: hr_utility.trace('Validating Effective Start Date and Effective End Date');
619: END IF;
620:
621: l_start_date := fnd_date.canonical_to_date(p_org_information10);
622: l_end_date := fnd_date.canonical_to_date(p_org_information11);
623: validate_date(l_start_date
624: ,l_end_date);
625:

Line 622: l_end_date := fnd_date.canonical_to_date(p_org_information11);

618: hr_utility.trace('Validating Effective Start Date and Effective End Date');
619: END IF;
620:
621: l_start_date := fnd_date.canonical_to_date(p_org_information10);
622: l_end_date := fnd_date.canonical_to_date(p_org_information11);
623: validate_date(l_start_date
624: ,l_end_date);
625:
626: IF g_debug THEN