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 521: hr_organization_information hoi

517: FROM pay_assignment_actions assact ,
518: per_all_assignments_f paa ,
519: pay_payroll_actions ppa ,
520: hr_soft_coding_keyflex scl ,
521: hr_organization_information hoi
522: WHERE assact.assignment_action_id = p_assignment_action_id
523: AND ppa.payroll_action_id = assact.payroll_action_id
524: AND paa.assignment_id = assact.assignment_id
525: AND ppa.effective_date BETWEEN paa.effective_start_date AND paa.effective_end_date

Line 1477: FROM hr_organization_information

1473: --
1474: BEGIN
1475: SELECT org_information1 --Local Unit ID flag
1476: INTO l_sort_flag
1477: FROM hr_organization_information
1478: WHERE organization_id = to_number(l_bg_id)
1479: AND org_information_context = 'NO_PAYSLIP_SORT_DETAILS'
1480: AND rownum <= 1;
1481: EXCEPTION WHEN OTHERS THEN

Line 1510: FROM hr_organization_information

1506: --
1507: BEGIN
1508: SELECT org_information2 --Org ID flag
1509: INTO l_sort_flag
1510: FROM hr_organization_information
1511: WHERE organization_id = to_number(l_bg_id)
1512: AND org_information_context = 'NO_PAYSLIP_SORT_DETAILS'
1513: AND rownum <= 1;
1514: EXCEPTION WHEN OTHERS THEN