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_FR_UTILITY dependencies on FND_DATE

Line 29: AND FND_DATE.CANONICAL_TO_DATE(CSR_L_INFORMATION67) BETWEEN PAF.EFFECTIVE_START_DATE

25: SELECT ORG_INFORMATION9
26: FROM HR_ORGANIZATION_INFORMATION HOI,
27: PER_ALL_ASSIGNMENTS_F PAF
28: WHERE PAF.ASSIGNMENT_ID = P_INFORMATION2
29: AND FND_DATE.CANONICAL_TO_DATE(CSR_L_INFORMATION67) BETWEEN PAF.EFFECTIVE_START_DATE
30: AND PAF.EFFECTIVE_END_DATE
31:
32: AND HOI.ORGANIZATION_ID = PAF.BUSINESS_GROUP_ID
33: AND UPPER(HOI.ORG_INFORMATION_CONTEXT) = 'BUSINESS GROUP INFORMATION';

Line 73: l_information67 := fnd_date.date_to_canonical(fnd_date.string_to_date(p_information67,NVL(fnd_profile.value_specific('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY')));

69:
70: HR_UTILITY.SET_LOCATION('In pqh_assignment_update context', 20);
71: -- Added for Bug 6031763
72: if NOT(length(p_information67) > 11) then
73: l_information67 := fnd_date.date_to_canonical(fnd_date.string_to_date(p_information67,NVL(fnd_profile.value_specific('ICX_DATE_FORMAT_MASK'),'DD-MON-YYYY')));
74: else
75: l_information67 := p_information67;
76: end If;
77: --

Line 137: SELECT MAX(fnd_date.canonical_to_date(pea.segment5))

133:
134: l_id_flex_num NUMBER(15);
135:
136: Cursor C_national_award_date IS
137: SELECT MAX(fnd_date.canonical_to_date(pea.segment5))
138: FROM per_analysis_criteria pea,
139: per_person_analyses ppa
140: WHERE ppa.person_id = p_person_id
141: AND pea.id_flex_num = l_id_flex_num

Line 146: SELECT MAX(fnd_date.canonical_to_date(pea.segment7))

142: AND pea.segment1 = p_award_type
143: AND pea.analysis_criteria_id = ppa.analysis_criteria_id;
144:
145: Cursor C_ministry_award_date IS
146: SELECT MAX(fnd_date.canonical_to_date(pea.segment7))
147: FROM per_analysis_criteria pea,
148: per_person_analyses ppa
149: WHERE ppa.person_id = p_person_id
150: AND pea.id_flex_num = l_id_flex_num

Line 166: AND fnd_date.canonical_to_date(pea.segment5) = l_max_date;

162: WHERE ppa.person_id = p_person_id
163: AND pea.id_flex_num = l_id_flex_num
164: AND pea.analysis_criteria_id = ppa.analysis_criteria_id
165: AND pea.segment1 = p_award_type
166: AND fnd_date.canonical_to_date(pea.segment5) = l_max_date;
167:
168: -- Selects the most recent award (award type) for a given person, for Ministry award
169: CURSOR C_ministry_award_type IS
170: SELECT pea.segment1

Line 177: AND fnd_date.canonical_to_date(pea.segment7) = l_max_date;

173: WHERE ppa.person_id = p_person_id
174: AND pea.id_flex_num = l_id_flex_num
175: AND pea.analysis_criteria_id = ppa.analysis_criteria_id
176: AND pea.segment1 = p_award_type
177: AND fnd_date.canonical_to_date(pea.segment7) = l_max_date;
178:
179: l_award_type hr_lookups.lookup_code%TYPE;
180:
181: BEGIN

Line 226: SELECT MAX(fnd_date.canonical_to_date(pea.segment5))

222:
223: l_id_flex_num NUMBER(15);
224:
225: Cursor C_national_award_date IS
226: SELECT MAX(fnd_date.canonical_to_date(pea.segment5))
227: FROM per_analysis_criteria pea,
228: per_person_analyses ppa
229: WHERE ppa.person_id = p_person_id
230: AND pea.id_flex_num = l_id_flex_num

Line 235: SELECT MAX(fnd_date.canonical_to_date(pea.segment7))

231: AND pea.segment1 = p_award_type
232: AND pea.analysis_criteria_id = ppa.analysis_criteria_id;
233:
234: Cursor C_ministry_award_date IS
235: SELECT MAX(fnd_date.canonical_to_date(pea.segment7))
236: FROM per_analysis_criteria pea,
237: per_person_analyses ppa
238: WHERE ppa.person_id = p_person_id
239: AND pea.id_flex_num = l_id_flex_num

Line 255: AND fnd_date.canonical_to_date(pea.segment5) = l_max_date;

251: WHERE ppa.person_id = p_person_id
252: AND pea.id_flex_num = l_id_flex_num
253: AND pea.analysis_criteria_id = ppa.analysis_criteria_id
254: AND pea.segment1 = p_award_type
255: AND fnd_date.canonical_to_date(pea.segment5) = l_max_date;
256:
257: -- Selects the most recent award (award level) for a given person, for Ministry award
258: CURSOR C_ministry_award_level IS
259: SELECT pea.segment4

Line 266: AND fnd_date.canonical_to_date(pea.segment7) = l_max_date;

262: WHERE ppa.person_id = p_person_id
263: AND pea.id_flex_num = l_id_flex_num
264: AND pea.segment1 = p_award_type
265: AND pea.analysis_criteria_id = ppa.analysis_criteria_id
266: AND fnd_date.canonical_to_date(pea.segment7) = l_max_date;
267:
268: l_award_type hr_lookups.lookup_code%TYPE;
269:
270: BEGIN