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_BDGT_ACTUAL_CMMTMNT_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 604: FROM HR_ORGANIZATION_INFORMATION O3

600: RETURN varchar2 IS
601: --
602: Cursor csr_lc is
603: SELECT O3.ORG_INFORMATION9 legislation_code
604: FROM HR_ORGANIZATION_INFORMATION O3
605: WHERE O3.ORGANIZATION_ID = p_business_group_id
606: AND O3.ORG_INFORMATION_CONTEXT = 'Business Group Information';
607: --
608: l_legislation_code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION9%type;

Line 608: l_legislation_code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION9%type;

604: FROM HR_ORGANIZATION_INFORMATION O3
605: WHERE O3.ORGANIZATION_ID = p_business_group_id
606: AND O3.ORG_INFORMATION_CONTEXT = 'Business Group Information';
607: --
608: l_legislation_code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION9%type;
609: --
610: BEGIN
611: --
612: Open csr_lc;

Line 2116: FROM HR_ORGANIZATION_INFORMATION O2

2112:
2113: --frequency, workinig_hours of organization
2114: Cursor c_org_freq(p_organization_id number) Is
2115: SELECT O2.ORG_INFORMATION4 , O2.ORG_INFORMATION3
2116: FROM HR_ORGANIZATION_INFORMATION O2
2117: WHERE O2.ORG_INFORMATION_CONTEXT = 'Work Day Information'
2118: AND O2.organization_id = p_organization_id;
2119:
2120: Cursor c_bg_freq(p_bg_id number) Is

Line 2122: FROM HR_ORGANIZATION_INFORMATION O2

2118: AND O2.organization_id = p_organization_id;
2119:
2120: Cursor c_bg_freq(p_bg_id number) Is
2121: SELECT O2.ORG_INFORMATION4 , O2.ORG_INFORMATION3
2122: FROM HR_ORGANIZATION_INFORMATION O2
2123: WHERE O2.ORG_INFORMATION_CONTEXT = 'Work Day Information'
2124: AND O2.organization_id = p_bg_id;
2125:
2126: cursor c_assg is

Line 4099: HR_ORGANIZATION_INFORMATION O3

4095: cursor curs1(p_position_id number, p_actuals_start_date date) is
4096: select classification_id
4097: from pay_element_classifications,
4098: hr_all_positions_f pos,
4099: HR_ORGANIZATION_INFORMATION O3
4100: where classification_name in ('Earnings', 'Employer Liabilities')
4101: and legislation_code = O3.ORG_INFORMATION9
4102: and pos.position_id = p_position_id
4103: and p_actuals_start_date between pos.effective_start_date and pos.effective_end_date