APPS.HR_DE_TAX_SUPPORT dependencies on DUAL

Line 50: from dual

46: and ose.organization_id_parent = P_TOP_ORG
47:
48: UNION
49: select P_TOP_ORG organization_id
50: from dual
51: order by organization_id;
52:
53: cursor get_organizations
54: ( P_ORG_HIERARCHY NUMBER

Line 67: from dual;

63: start with ose.organization_id_parent = P_ORGANIZATION_ID
64: and ose.org_structure_version_id = P_ORG_HIERARCHY
65: UNION
66: select P_ORGANIZATION_ID organization_id
67: from dual;
68:
69:
70: cursor get_assignment_sets
71: ( P_BUSINESS_GROUP_ID NUMBER

Line 314: from dual;

310: IF P_ACTION = 'UR' THEN
311:
312: select nvl(p_end_date,to_date('31/12/4712','dd/mm/yyyy'))
313: into l_cdate
314: from dual;
315:
316: select to_date('31/12/4712','dd/mm/yyyy')
317: into l_bdate
318: from dual;

Line 318: from dual;

314: from dual;
315:
316: select to_date('31/12/4712','dd/mm/yyyy')
317: into l_bdate
318: from dual;
319:
320: if l_cdate = l_bdate then
321:
322: l_update_mode := 'UPDATE' ;

Line 343: from dual;

339: ,l_no_of_children
340: ,l_tax_free_income
341: ,l_add_income
342:
343: from dual;
344:
345:
346: l_object_version_number := p_object_version_number;
347: per_de_ele_api.update_tax_information