APPS.PAY_SE_RULES dependencies on HR_ORGANIZATION_INFORMATION

Line 32: , hr_organization_information hoi1

28:
29: CURSOR c_tax_unit_id (p_business_group_id NUMBER , p_organization_id NUMBER) IS
30: SELECT hoi3.organization_id
31: FROM hr_organization_units o1
32: , hr_organization_information hoi1
33: , hr_organization_information hoi2
34: , hr_organization_information hoi3
35: WHERE o1.business_group_id =p_business_group_id
36: AND hoi1.organization_id = o1.organization_id

Line 33: , hr_organization_information hoi2

29: CURSOR c_tax_unit_id (p_business_group_id NUMBER , p_organization_id NUMBER) IS
30: SELECT hoi3.organization_id
31: FROM hr_organization_units o1
32: , hr_organization_information hoi1
33: , hr_organization_information hoi2
34: , hr_organization_information hoi3
35: WHERE o1.business_group_id =p_business_group_id
36: AND hoi1.organization_id = o1.organization_id
37: AND hoi1.organization_id = p_organization_id

Line 34: , hr_organization_information hoi3

30: SELECT hoi3.organization_id
31: FROM hr_organization_units o1
32: , hr_organization_information hoi1
33: , hr_organization_information hoi2
34: , hr_organization_information hoi3
35: WHERE o1.business_group_id =p_business_group_id
36: AND hoi1.organization_id = o1.organization_id
37: AND hoi1.organization_id = p_organization_id
38: AND hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 77: l_pension_group_id hr_organization_information.org_information_id%TYPE;

73: l_element_name PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;
74: l_local_unit_id hr_soft_coding_keyflex.SEGMENT2%TYPE ;
75: l_business_group_id per_all_assignments_f.business_group_id%TYPE ;
76: l_tax_unit_id hr_organization_units.organization_id%TYPE ;
77: l_pension_group_id hr_organization_information.org_information_id%TYPE;
78: l_pension_group hr_organization_information.org_information2%TYPE;
79: l_pension_type hr_organization_information.org_information1%TYPE;
80: l_pension_provider hr_organization_units.organization_id%TYPE ;
81:

Line 78: l_pension_group hr_organization_information.org_information2%TYPE;

74: l_local_unit_id hr_soft_coding_keyflex.SEGMENT2%TYPE ;
75: l_business_group_id per_all_assignments_f.business_group_id%TYPE ;
76: l_tax_unit_id hr_organization_units.organization_id%TYPE ;
77: l_pension_group_id hr_organization_information.org_information_id%TYPE;
78: l_pension_group hr_organization_information.org_information2%TYPE;
79: l_pension_type hr_organization_information.org_information1%TYPE;
80: l_pension_provider hr_organization_units.organization_id%TYPE ;
81:
82: l_effective_date DATE;

Line 79: l_pension_type hr_organization_information.org_information1%TYPE;

75: l_business_group_id per_all_assignments_f.business_group_id%TYPE ;
76: l_tax_unit_id hr_organization_units.organization_id%TYPE ;
77: l_pension_group_id hr_organization_information.org_information_id%TYPE;
78: l_pension_group hr_organization_information.org_information2%TYPE;
79: l_pension_type hr_organization_information.org_information1%TYPE;
80: l_pension_provider hr_organization_units.organization_id%TYPE ;
81:
82: l_effective_date DATE;
83: