APPS.PAY_NO_RULES dependencies on HR_ORGANIZATION_INFORMATION

Line 24: , hr_organization_information hoi1

20: AND p_effective_date BETWEEN PAA.effective_start_date AND PAA.effective_end_date ;
21: CURSOR c_tax_unit_id (p_business_group_id NUMBER , p_organization_id NUMBER) IS
22: SELECT hoi3.organization_id
23: FROM hr_organization_units o1
24: , hr_organization_information hoi1
25: , hr_organization_information hoi2
26: , hr_organization_information hoi3
27: WHERE o1.business_group_id =p_business_group_id
28: AND hoi1.organization_id = o1.organization_id

Line 25: , hr_organization_information hoi2

21: CURSOR c_tax_unit_id (p_business_group_id NUMBER , p_organization_id NUMBER) IS
22: SELECT hoi3.organization_id
23: FROM hr_organization_units o1
24: , hr_organization_information hoi1
25: , hr_organization_information hoi2
26: , hr_organization_information hoi3
27: WHERE o1.business_group_id =p_business_group_id
28: AND hoi1.organization_id = o1.organization_id
29: AND hoi1.organization_id = p_organization_id

Line 26: , hr_organization_information hoi3

22: SELECT hoi3.organization_id
23: FROM hr_organization_units o1
24: , hr_organization_information hoi1
25: , hr_organization_information hoi2
26: , hr_organization_information hoi3
27: WHERE o1.business_group_id =p_business_group_id
28: AND hoi1.organization_id = o1.organization_id
29: AND hoi1.organization_id = p_organization_id
30: AND hoi1.org_information1 = 'NO_LOCAL_UNIT'

Line 527: hr_organization_information hoi

523: FROM pay_assignment_actions assact ,
524: per_all_assignments_f paa ,
525: pay_payroll_actions ppa ,
526: hr_soft_coding_keyflex scl ,
527: hr_organization_information hoi
528: WHERE assact.assignment_action_id = p_assignment_action_id
529: AND ppa.payroll_action_id = assact.payroll_action_id
530: AND paa.assignment_id = assact.assignment_id
531: AND ppa.effective_date BETWEEN paa.effective_start_date AND paa.effective_end_date

Line 1490: FROM hr_organization_information

1486: --
1487: BEGIN
1488: SELECT org_information1 --Local Unit ID flag
1489: INTO l_sort_flag
1490: FROM hr_organization_information
1491: WHERE organization_id = to_number(l_bg_id)
1492: AND org_information_context = 'NO_PAYSLIP_SORT_DETAILS'
1493: AND rownum <= 1;
1494: EXCEPTION WHEN OTHERS THEN

Line 1523: FROM hr_organization_information

1519: --
1520: BEGIN
1521: SELECT org_information2 --Org ID flag
1522: INTO l_sort_flag
1523: FROM hr_organization_information
1524: WHERE organization_id = to_number(l_bg_id)
1525: AND org_information_context = 'NO_PAYSLIP_SORT_DETAILS'
1526: AND rownum <= 1;
1527: EXCEPTION WHEN OTHERS THEN