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 2113: FROM HR_ORGANIZATION_INFORMATION O2

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

Line 2119: FROM HR_ORGANIZATION_INFORMATION O2

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

Line 4096: HR_ORGANIZATION_INFORMATION O3

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