DBA Data[Home] [Help]

APPS.PAY_AE_GENERAL dependencies on HR_ORGANIZATION_UNITS

Line 525: from hr_organization_units HOU

521: p_date_earned IN Date)
522: RETURN VARCHAR2 IS
523: cursor csr_get_formula_id is
524: select HOI2.org_information1
525: from hr_organization_units HOU
526: ,hr_organization_information HOI1
527: ,hr_organization_information HOI2
528: ,hr_soft_coding_keyflex HSCK
529: ,per_all_assignments_f PAA

Line 631: from hr_organization_units HOU

627: )
628: return NUMBER is
629: cursor csr_get_formula_id is
630: select HOI2.org_information2
631: from hr_organization_units HOU
632: ,hr_organization_information HOI1
633: ,hr_organization_information HOI2
634: ,hr_soft_coding_keyflex HSCK
635: ,per_all_assignments_f PAA

Line 717: from hr_organization_units HOU

713: )
714: return NUMBER is
715: cursor csr_get_formula_id is
716: select HOI2.org_information3
717: from hr_organization_units HOU
718: ,hr_organization_information HOI1
719: ,hr_organization_information HOI2
720: ,hr_soft_coding_keyflex HSCK
721: ,per_all_assignments_f PAA

Line 837: from hr_organization_units HOU

833: )
834: RETURN VARCHAR2 IS
835: CURSOR csr_get_gratuity_basis IS
836: select NVL(HOI2.org_information1,'X')
837: from hr_organization_units HOU
838: ,hr_organization_information HOI1
839: ,hr_organization_information HOI2
840: ,hr_soft_coding_keyflex HSCK
841: ,per_all_assignments_f PAA