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 HR_ORGANIZATION_INFORMATION

Line 208: hr_organization_information HOI

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'
210: AND HOI.organization_id = PACT.business_group_id
211: AND PACT.payroll_action_id = p_owner_payroll_action_id;
212:

Line 220: hr_organization_information HOI

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'
222: AND HOI.organization_id = PACT.business_group_id
223: AND PACT.payroll_action_id = p_owner_payroll_action_id;
224:

Line 326: hr_organization_information HOI

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'
328: AND HOI.organization_id = PACT.business_group_id
329: AND PACT.payroll_action_id = p_owner_payroll_action_id;
330:

Line 339: hr_organization_information HOI

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'
341:
342: AND HOI.organization_id = PACT.business_group_id
343: AND PACT.payroll_action_id = p_owner_payroll_action_id;

Line 430: hr_organization_information HOI

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'
432: AND HOI.organization_id = PACT.business_group_id
433: AND PACT.payroll_action_id = l_payroll_action_id;
434:

Line 441: hr_organization_information HOI

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'
443: AND HOI.organization_id = PACT.business_group_id
444: AND PACT.payroll_action_id = l_payroll_action_id;
445: