APPS.PAY_CN_BAL_UPLOAD dependencies on HR_ORGANIZATION_INFORMATION

Line 51: ,hr_organization_information HOI

47: ,12*(floor(months_between(p_upload_date
48: ,fnd_date.canonical_to_date(HOI.ORG_INFORMATION11))/12)))
49: ,END_OF_TIME)
50: FROM per_assignments_f ASS
51: ,hr_organization_information HOI
52: WHERE ASS.assignment_id = p_assignment_id
53: AND p_upload_date BETWEEN ASS.effective_start_date
54: AND ASS.effective_end_date
55: AND HOI.organization_id = ASS.business_group_id

Line 80: ,hr_organization_information HOI

76: , 3*(FLOOR(MONTHS_BETWEEN(p_upload_date
77: , fnd_date.canonical_to_date(HOI.ORG_INFORMATION11))/3)))
78: , END_OF_TIME)
79: FROM per_assignments_f ASS
80: ,hr_organization_information HOI
81: WHERE ASS.assignment_id = p_assignment_id
82: AND p_upload_date BETWEEN ASS.effective_start_date AND ASS.effective_end_date
83: AND HOI.organization_id = ASS.business_group_id
84: AND UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION';

Line 472: , hr_organization_information hoi

468: IS
469: SELECT pbbl.tax_unit_id
470: FROM pay_balance_batch_lines pbbl
471: , hr_all_organization_units_tl otl
472: , hr_organization_information hoi
473: WHERE pbbl.batch_line_id = p_batch_line_id
474: AND pbbl.tax_unit_id = otl.organization_id
475: AND pbbl.tax_unit_id IS NOT NULL
476: AND otl.organization_id = hoi.organization_id

Line 484: , hr_organization_information hoi

480: UNION ALL
481: SELECT pbbl.tax_unit_id
482: FROM pay_balance_batch_lines pbbl
483: , hr_all_organization_units_tl otl
484: , hr_organization_information hoi
485: WHERE pbbl.batch_line_id = p_batch_line_id
486: AND upper(pbbl.gre_name) = UPPER(otl.name)
487: AND pbbl.tax_unit_id IS NULL
488: AND otl.organization_id = hoi.organization_id