eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SE_RULES dependencies on HR_ORGANIZATION_UNITS

Line 31: FROM hr_organization_units o1

27: AND p_effective_date BETWEEN PAA.effective_start_date AND PAA.effective_end_date ;
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

Line 76: l_tax_unit_id hr_organization_units.organization_id%TYPE ;

72: l_third_party_id number;
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 ;

Line 80: l_pension_provider hr_organization_units.organization_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:
84: