APPS.PAY_IN_24Q_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 157: ,hr_organization_units hou

153: IS
154: SELECT 1
155: FROM pay_action_information pai
156: ,pay_payroll_actions ppa
157: ,hr_organization_units hou
158: WHERE pai.action_information_category = 'IN_24Q_ORG'
159: AND pai.action_context_type = 'PA'
160: AND pai.action_information1 like g_gre_id
161: AND pai.action_information3 = g_year||g_quarter

Line 670: ,hr_organization_units hou

666: ,hoi.org_information4 reg_org_id
667: ,hoi.org_information7 division
668: ,hou.location_id location_id
669: FROM hr_organization_information hoi
670: ,hr_organization_units hou
671: WHERE hoi.organization_id = p_gre_id
672: AND hoi.org_information_context = 'PER_IN_INCOME_TAX_DF'
673: AND hou.organization_id = hoi.organization_id
674: AND hou.business_group_id = g_bg_id

Line 682: ,hr_organization_units hou

678: IS
679: SELECT hoi.org_information3 pan
680: ,hoi.org_information4 legal_name
681: FROM hr_organization_information hoi
682: ,hr_organization_units hou
683: WHERE hoi.organization_id = p_reg_org_id
684: AND hoi.org_information_context = 'PER_IN_COMPANY_DF'
685: AND hou.organization_id = hoi.organization_id
686: AND hou.business_group_id = g_bg_id

Line 711: ,hr_organization_units hou

707: SELECT hoi.org_information1 person_id
708: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) rep_name
709: ,pep.email_address email_id
710: FROM hr_organization_information hoi
711: ,hr_organization_units hou
712: ,per_people_f pep
713: WHERE hoi.org_information_context = 'PER_IN_INCOME_TAX_REP_DF'
714: AND hoi.organization_id = p_gre_id
715: AND hou.organization_id = hoi.organization_id

Line 728: ,hr_organization_units hou

724: CURSOR c_rep_address(p_person_id NUMBER)
725: IS
726: SELECT hou.location_id rep_location
727: FROM per_assignments_f asg
728: ,hr_organization_units hou
729: WHERE asg.person_id = p_person_id
730: AND asg.primary_flag = 'Y'
731: AND asg.business_group_id = g_bg_id
732: AND hou.organization_id = asg.organization_id

Line 759: l_location_id hr_organization_units.location_id%TYPE;

755: l_tan hr_organization_information.org_information1%TYPE;
756: l_er_class hr_organization_information.org_information3%TYPE;
757: l_reg_org_id hr_organization_information.org_information4%TYPE;
758: l_division hr_organization_information.org_information7%TYPE;
759: l_location_id hr_organization_units.location_id%TYPE;
760: l_pan hr_organization_information.org_information3%TYPE;
761: l_legal_name hr_organization_information.org_information4%TYPE;
762: l_rep_person_id per_all_people_f.person_id%TYPE;
763: l_rep_name per_all_people_f.full_name%TYPE;

Line 765: l_rep_location hr_organization_units.location_id%TYPE;

761: l_legal_name hr_organization_information.org_information4%TYPE;
762: l_rep_person_id per_all_people_f.person_id%TYPE;
763: l_rep_name per_all_people_f.full_name%TYPE;
764: l_position per_all_positions.name%TYPE;
765: l_rep_location hr_organization_units.location_id%TYPE;
766: l_rep_phone_no per_phones.phone_number%TYPE;
767: l_rep_email_id per_all_people_f.email_address%TYPE;
768: l_action_info_id NUMBER;
769: l_ovn NUMBER;