DBA Data[Home] [Help]

APPS.PAY_KW_USER_FUNCTION dependencies on HR_ORGANIZATION_INFORMATION

Line 87: ,hr_organization_information HOI1

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

Line 88: ,hr_organization_information HOI2

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