DBA Data[Home] [Help]

APPS.HR_LEGISLATION dependencies on HR_ORG_INFORMATION_TYPES

Line 3491: from hr_org_information_types

3487: -- will be deleted.
3488:
3489: select null
3490: into l_null_return
3491: from hr_org_information_types
3492: where org_information_type = stu_rec.org_information_type
3493: and nvl(destination,'X') = nvl(stu_rec.destination,'X')
3494: and nvl(displayed_org_information_type,'X') = nvl(stu_rec.doit,'X')
3495: and nvl(legislation_code,'X') = nvl(stu_rec.legislation_code,'X')

Line 3555: update hr_org_information_types

3551:
3552: IF p_phase = 1 THEN return; END IF;
3553:
3554:
3555: update hr_org_information_types
3556: set destination = stu_rec.destination
3557: , displayed_org_information_type = stu_rec.doit
3558: , legislation_code = stu_rec.legislation_code
3559: , navigation_method = stu_rec.navigation_method

Line 3565: insert into hr_org_information_types

3561:
3562: IF SQL%NOTFOUND THEN
3563:
3564:
3565: insert into hr_org_information_types
3566: (org_information_type
3567: ,description
3568: ,destination
3569: ,displayed_org_information_type