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

Line 297: SELECT fnd_date.canonical_to_date(org_information11)

293: ELSIF p_dimension_name like '%MONTH' THEN
294: l_expiry_date := next_month(p_owner_effective_date);
295:
296: ELSIF p_dimension_name like '%FQTD' THEN
297: SELECT fnd_date.canonical_to_date(org_information11)
298: INTO l_beg_of_fiscal_year
299: FROM pay_payroll_actions PACT,
300: hr_organization_information HOI
301: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'

Line 309: SELECT fnd_date.canonical_to_date(org_information11)

305: l_expiry_date := next_fiscal_quarter(l_beg_of_fiscal_year,
306: p_owner_effective_date);
307:
308: ELSIF p_dimension_name like '%FYTD' THEN
309: SELECT fnd_date.canonical_to_date(org_information11)
310: INTO l_beg_of_fiscal_year
311: FROM pay_payroll_actions PACT,
312: hr_organization_information HOI
313: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'

Line 429: SELECT fnd_date.canonical_to_date(org_information11)

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

Line 440: SELECT fnd_date.canonical_to_date(org_information11)

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

Line 574: SELECT fnd_date.canonical_to_date(org_information11)

570: p_expiry_date := next_month(p_owner_effective_date) - 1;
571: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);
572:
573: ELSIF p_dimension_name like '%FQTD' THEN
574: SELECT fnd_date.canonical_to_date(org_information11)
575: INTO l_beg_of_fiscal_year
576: FROM pay_payroll_actions PACT,
577: hr_organization_information HOI
578: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'

Line 585: SELECT fnd_date.canonical_to_date(org_information11)

581: p_expiry_date := next_fiscal_quarter(l_beg_of_fiscal_year,p_owner_effective_date) - 1;
582: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);
583:
584: ELSIF p_dimension_name like '%FYTD' THEN
585: SELECT fnd_date.canonical_to_date(org_information11)
586: INTO l_beg_of_fiscal_year
587: FROM pay_payroll_actions PACT,
588: hr_organization_information HOI
589: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'

Line 614: p_expiry_date := fnd_date.canonical_to_date('4712/12/31');

610: FROM pay_payroll_actions PACT
611: WHERE PACT.payroll_action_id = p_owner_payroll_action_id;
612:
613: ELSIF p_dimension_name like '%LTD' THEN
614: p_expiry_date := fnd_date.canonical_to_date('4712/12/31');
615: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);
616:
617: ELSE
618: hr_utility.trace('Entered Exception section');