DBA Data[Home] [Help]

APPS.PAY_AE_GENERAL dependencies on HR_ORGANIZATION_UNITS

Line 591: from hr_organization_units HOU

587: p_date_earned IN Date)
588: RETURN VARCHAR2 IS
589: cursor csr_get_formula_id is
590: select HOI2.org_information1
591: from hr_organization_units HOU
592: ,hr_organization_information HOI1
593: ,hr_organization_information HOI2
594: ,hr_soft_coding_keyflex HSCK
595: ,per_all_assignments_f PAA

Line 697: from hr_organization_units HOU

693: )
694: return NUMBER is
695: cursor csr_get_formula_id is
696: select HOI2.org_information2
697: from hr_organization_units HOU
698: ,hr_organization_information HOI1
699: ,hr_organization_information HOI2
700: ,hr_soft_coding_keyflex HSCK
701: ,per_all_assignments_f PAA

Line 783: from hr_organization_units HOU

779: )
780: return NUMBER is
781: cursor csr_get_formula_id is
782: select HOI2.org_information3
783: from hr_organization_units HOU
784: ,hr_organization_information HOI1
785: ,hr_organization_information HOI2
786: ,hr_soft_coding_keyflex HSCK
787: ,per_all_assignments_f PAA

Line 903: from hr_organization_units HOU

899: )
900: RETURN VARCHAR2 IS
901: CURSOR csr_get_gratuity_basis IS
902: select NVL(HOI2.org_information1,'X')
903: from hr_organization_units HOU
904: ,hr_organization_information HOI1
905: ,hr_organization_information HOI2
906: ,hr_soft_coding_keyflex HSCK
907: ,per_all_assignments_f PAA