DBA Data[Home] [Help]

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,