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

Line 172: and l_session_date between nvl(fnd_date.canonical_to_date(pei.pei_information4), l_session_date)

168: )
169: and pap.PERSON_ID = pcr.CONTACT_PERSON_ID
170: and pcr.PERSON_ID = pei.PERSON_ID (+)
171: and pei.PEI_INFORMATION_CATEGORY (+)='DE_PQH_CHILD_DETAILS'
172: and l_session_date between nvl(fnd_date.canonical_to_date(pei.pei_information4), l_session_date)
173: and nvl(fnd_date.canonical_to_date(pei.pei_information5), l_session_date)
174: order by nvl(pap.DATE_OF_BIRTH,l_session_date);
175:
176: --Select disability status of a person

Line 173: and nvl(fnd_date.canonical_to_date(pei.pei_information5), l_session_date)

169: and pap.PERSON_ID = pcr.CONTACT_PERSON_ID
170: and pcr.PERSON_ID = pei.PERSON_ID (+)
171: and pei.PEI_INFORMATION_CATEGORY (+)='DE_PQH_CHILD_DETAILS'
172: and l_session_date between nvl(fnd_date.canonical_to_date(pei.pei_information4), l_session_date)
173: and nvl(fnd_date.canonical_to_date(pei.pei_information5), l_session_date)
174: order by nvl(pap.DATE_OF_BIRTH,l_session_date);
175:
176: --Select disability status of a person
177:

Line 256: l_session_date := fnd_date.canonical_to_date(pEffective_date);

252: --OPEN C_B_Grp(pBusiness_grp_name);
253: --fetch C_B_grp into lBusiness_group_id;
254: lBusiness_group_id :=pBusiness_grp_id;
255:
256: l_session_date := fnd_date.canonical_to_date(pEffective_date);
257:
258: --l_session_date := to_date(pEffective_date, 'RRRR/MM/DD HH24:MI:SS');
259: --l_session_date := to_date(to_char(trunc(l_session_date), 'DD/MM/RRRR'),'DD/MM/RRRR');
260:

Line 291: and c_Age < (21 + months_between(fnd_date.canonical_to_date(c_Child_Mil.PEI_INFORMATION2),fnd_date.canonical_to_date(c_Child_Mil.PEI_INFORMATION1))/12)

287: ( --Child age less than 21
288: ( c_Age < 21)
289: or -- or Child is Unemployed and has done militaty service and less than 21 +period of service
290: (C_Child_Military_Info%FOUND and c_Child_Mil.PEI_INFORMATION3 ='M' and c_Child_Mil.PEI_INFORMATION4 ='Y'
291: and c_Age < (21 + months_between(fnd_date.canonical_to_date(c_Child_Mil.PEI_INFORMATION2),fnd_date.canonical_to_date(c_Child_Mil.PEI_INFORMATION1))/12)
292: )
293: or -- or Child is Unemployed and has done civil service and less than 21 +period of sevice+1 month
294: (C_Child_Military_Info%FOUND and c_Child_Mil.PEI_INFORMATION3 ='C' and c_Child_Mil.PEI_INFORMATION4 ='Y'
295: and c_Age < (21 + (1+months_between(fnd_date.canonical_to_date(c_Child_Mil.PEI_INFORMATION2),fnd_date.canonical_to_date(c_Child_Mil.PEI_INFORMATION1)))/12)

Line 295: and c_Age < (21 + (1+months_between(fnd_date.canonical_to_date(c_Child_Mil.PEI_INFORMATION2),fnd_date.canonical_to_date(c_Child_Mil.PEI_INFORMATION1)))/12)

291: and c_Age < (21 + months_between(fnd_date.canonical_to_date(c_Child_Mil.PEI_INFORMATION2),fnd_date.canonical_to_date(c_Child_Mil.PEI_INFORMATION1))/12)
292: )
293: or -- or Child is Unemployed and has done civil service and less than 21 +period of sevice+1 month
294: (C_Child_Military_Info%FOUND and c_Child_Mil.PEI_INFORMATION3 ='C' and c_Child_Mil.PEI_INFORMATION4 ='Y'
295: and c_Age < (21 + (1+months_between(fnd_date.canonical_to_date(c_Child_Mil.PEI_INFORMATION2),fnd_date.canonical_to_date(c_Child_Mil.PEI_INFORMATION1)))/12)
296: )
297: or
298: ( C_Children_Qualification%FOUND )
299: or

Line 313: and c_Age < (21 + months_between(fnd_date.canonical_to_date(c_Child_Mil.PEI_INFORMATION2),fnd_date.canonical_to_date(c_Child_Mil.PEI_INFORMATION1))/12)

309: ( --Child age less than 21
310: ( c_Age < 21)
311: or -- or Child is Unemployed and has done militaty service and less than 22 +period of service
312: (C_Child_Military_Info%FOUND and c_Child_Mil.PEI_INFORMATION3 ='M' and c_Child_Mil.PEI_INFORMATION4 ='Y'
313: and c_Age < (21 + months_between(fnd_date.canonical_to_date(c_Child_Mil.PEI_INFORMATION2),fnd_date.canonical_to_date(c_Child_Mil.PEI_INFORMATION1))/12)
314: )
315: or -- or Child is Unemployed and has done civil service and less than 22 +period of sevice+1 month
316: (C_Child_Military_Info%FOUND and c_Child_Mil.PEI_INFORMATION3 ='C' and c_Child_Mil.PEI_INFORMATION4 ='Y'
317: and c_Age < (21 + (1+months_between(fnd_date.canonical_to_date(c_Child_Mil.PEI_INFORMATION2),fnd_date.canonical_to_date(c_Child_Mil.PEI_INFORMATION1)))/12)

Line 317: and c_Age < (21 + (1+months_between(fnd_date.canonical_to_date(c_Child_Mil.PEI_INFORMATION2),fnd_date.canonical_to_date(c_Child_Mil.PEI_INFORMATION1)))/12)

313: and c_Age < (21 + months_between(fnd_date.canonical_to_date(c_Child_Mil.PEI_INFORMATION2),fnd_date.canonical_to_date(c_Child_Mil.PEI_INFORMATION1))/12)
314: )
315: or -- or Child is Unemployed and has done civil service and less than 22 +period of sevice+1 month
316: (C_Child_Military_Info%FOUND and c_Child_Mil.PEI_INFORMATION3 ='C' and c_Child_Mil.PEI_INFORMATION4 ='Y'
317: and c_Age < (21 + (1+months_between(fnd_date.canonical_to_date(c_Child_Mil.PEI_INFORMATION2),fnd_date.canonical_to_date(c_Child_Mil.PEI_INFORMATION1)))/12)
318: )
319: or
320: (C_Children_Qualification%FOUND )
321: or