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

Line 205: SELECT fnd_date.canonical_to_date(org_information11)

201: ELSIF p_dimension_name like '%MONTH' THEN
202: l_expiry_date := next_month(p_owner_effective_date);
203:
204: ELSIF p_dimension_name like '%FQTD' THEN
205: SELECT fnd_date.canonical_to_date(org_information11)
206: INTO l_beg_of_fiscal_year
207: FROM pay_payroll_actions PACT,
208: hr_organization_information HOI
209: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'

Line 217: SELECT fnd_date.canonical_to_date(org_information11)

213: l_expiry_date := next_fiscal_quarter(l_beg_of_fiscal_year,
214: p_owner_effective_date);
215:
216: ELSIF p_dimension_name like '%FYTD' THEN
217: SELECT fnd_date.canonical_to_date(org_information11)
218: INTO l_beg_of_fiscal_year
219: FROM pay_payroll_actions PACT,
220: hr_organization_information HOI
221: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'

Line 323: SELECT fnd_date.canonical_to_date(org_information11)

319: p_expiry_information := next_month(p_owner_effective_date) -1 ;
320: hr_utility.set_location('p_expiry_information'||p_dimension_name||':'||p_expiry_information, 30);
321:
322: ELSIF p_dimension_name like '%FQTD' THEN
323: SELECT fnd_date.canonical_to_date(org_information11)
324: INTO l_beg_of_fiscal_year
325: FROM pay_payroll_actions PACT,
326: hr_organization_information HOI
327: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'

Line 336: SELECT fnd_date.canonical_to_date(org_information11)

332: p_owner_effective_date) - 1;
333: hr_utility.set_location('p_expiry_information'||p_dimension_name||':'||p_expiry_information, 30);
334:
335: ELSIF p_dimension_name like '%FYTD' THEN
336: SELECT fnd_date.canonical_to_date(org_information11)
337: INTO l_beg_of_fiscal_year
338: FROM pay_payroll_actions PACT,
339: hr_organization_information HOI
340: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'

Line 360: p_expiry_information := fnd_date.canonical_to_date('4712/12/31');

356: hr_utility.set_location('p_expiry_information'||p_dimension_name||':'||p_expiry_information, 30);
357:
358: ELSIF p_dimension_name like '%LTD' THEN
359:
360: p_expiry_information := fnd_date.canonical_to_date('4712/12/31');
361: hr_utility.set_location('p_expiry_information'||p_dimension_name||':'||p_expiry_information, 30);
362:
363: ELSE
364:

Line 427: SELECT fnd_date.canonical_to_date(org_information11)

423: -- this will expire at the end of the month
424: RETURN next_month(l_effective_date) - 1;
425:
426: ELSIF l_dimension_name like '%FQTD' THEN
427: SELECT fnd_date.canonical_to_date(org_information11)
428: INTO l_beg_of_fiscal_year
429: FROM pay_payroll_actions PACT,
430: hr_organization_information HOI
431: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'

Line 438: SELECT fnd_date.canonical_to_date(org_information11)

434:
435: RETURN next_fiscal_quarter(l_beg_of_fiscal_year, l_effective_date) - 1;
436:
437: ELSIF l_dimension_name like '%FYTD' THEN
438: SELECT fnd_date.canonical_to_date(org_information11)
439: INTO l_beg_of_fiscal_year
440: FROM pay_payroll_actions PACT,
441: hr_organization_information HOI
442: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'