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

Line 88: ,hr_organization_information HOI1

84: and (ID_FLEX_CODE='SCL') ;
85: cursor csr_get_formula_id ( p_id_flex_num number) is
86: select HOI2.org_information1
87: from hr_organization_units HOU
88: ,hr_organization_information HOI1
89: ,hr_organization_information HOI2
90: ,hr_soft_coding_keyflex HSCK
91: ,per_all_assignments_f PAA
92: where HOU.business_group_id = p_business_group_id

Line 89: ,hr_organization_information HOI2

85: cursor csr_get_formula_id ( p_id_flex_num number) is
86: select HOI2.org_information1
87: from hr_organization_units HOU
88: ,hr_organization_information HOI1
89: ,hr_organization_information HOI2
90: ,hr_soft_coding_keyflex HSCK
91: ,per_all_assignments_f PAA
92: where HOU.business_group_id = p_business_group_id
93: and trunc(p_date_earned) between HOU.date_from and nvl(HOU.date_to,

Line 189: ,hr_organization_information HOI1

185: and (ID_FLEX_CODE='SCL') ;
186: cursor csr_get_formula_id ( p_id_flex_num number) is
187: select HOI2.org_information1
188: from hr_organization_units HOU
189: ,hr_organization_information HOI1
190: ,hr_organization_information HOI2
191: ,hr_soft_coding_keyflex HSCK
192: ,per_all_assignments_f PAA
193: where HOU.business_group_id = p_business_group_id

Line 190: ,hr_organization_information HOI2

186: cursor csr_get_formula_id ( p_id_flex_num number) is
187: select HOI2.org_information1
188: from hr_organization_units HOU
189: ,hr_organization_information HOI1
190: ,hr_organization_information HOI2
191: ,hr_soft_coding_keyflex HSCK
192: ,per_all_assignments_f PAA
193: where HOU.business_group_id = p_business_group_id
194: and trunc(p_date_earned) between HOU.date_from and nvl(HOU.date_to,

Line 292: ,hr_organization_information HOI1

288: and (ID_FLEX_CODE='SCL') ;
289: cursor csr_get_formula_id ( p_id_flex_num number) is
290: select HOI2.org_information2
291: from hr_organization_units HOU
292: ,hr_organization_information HOI1
293: ,hr_organization_information HOI2
294: ,hr_soft_coding_keyflex HSCK
295: ,per_all_assignments_f PAA
296: where HOU.business_group_id = p_business_group_id

Line 293: ,hr_organization_information HOI2

289: cursor csr_get_formula_id ( p_id_flex_num number) is
290: select HOI2.org_information2
291: from hr_organization_units HOU
292: ,hr_organization_information HOI1
293: ,hr_organization_information HOI2
294: ,hr_soft_coding_keyflex HSCK
295: ,per_all_assignments_f PAA
296: where HOU.business_group_id = p_business_group_id
297: and trunc(p_date_earned) between HOU.date_from and nvl(HOU.date_to,