APPS.PAY_IN_FORM_24Q_WEB_ADI dependencies on HR_ORGANIZATION_INFORMATION

Line 148: ,hr_organization_information hoi

144: CURSOR c_tan_number
145: IS
146: SELECT hou.organization_id
147: FROM hr_organization_units hou
148: ,hr_organization_information hoi
149: WHERE hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
150: AND hoi.organization_id = hou.organization_id
151: AND hoi.org_information_context = 'PER_IN_INCOME_TAX_DF'
152: AND hoi.org_information1 = p_tan_number;

Line 206: ,hr_organization_information hoi

202: CURSOR c_tan_number
203: IS
204: SELECT hoi.org_information1
205: FROM hr_organization_units hou
206: ,hr_organization_information hoi
207: ,per_assignments_f asg
208: ,hr_soft_coding_keyflex scl
209: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
210: AND asg.business_group_id = hou.business_group_id

Line 218: l_tan_number hr_organization_information.org_information1%TYPE;

214: AND hoi.org_information_context = 'PER_IN_INCOME_TAX_DF'
215: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date
216: AND p_effective_date BETWEEN hou.date_from AND NVL(date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));
217: --
218: l_tan_number hr_organization_information.org_information1%TYPE;
219: l_procedure VARCHAR2(250);
220: l_message VARCHAR2(250);
221: BEGIN
222: g_debug := hr_utility.debug_enabled;

Line 273: l_tan_number hr_organization_information.org_information1%TYPE;

269:
270: l_effective_date DATE;
271: l_assignment_id NUMBER;
272: l_ee_payment_date DATE;
273: l_tan_number hr_organization_information.org_information1%TYPE;
274: l_procedure VARCHAR2(250);
275: l_message VARCHAR2(250);
276: BEGIN
277: g_debug := hr_utility.debug_enabled;