DBA Data[Home] [Help]

APPS.HR_LEGISLATION dependencies on HR_ORG_INFORMATION_TYPES

Line 3737: from hr_org_information_types

3733: -- will be deleted.
3734:
3735: select null
3736: into l_null_return
3737: from hr_org_information_types
3738: where org_information_type = stu_rec.org_information_type
3739: and nvl(destination,'X') = nvl(stu_rec.destination,'X')
3740: and nvl(displayed_org_information_type,'X') = nvl(stu_rec.doit,'X')
3741: and nvl(legislation_code,'X') = nvl(stu_rec.legislation_code,'X')

Line 3801: update hr_org_information_types

3797:
3798: IF p_phase = 1 THEN return; END IF;
3799:
3800:
3801: update hr_org_information_types
3802: set destination = stu_rec.destination
3803: , displayed_org_information_type = stu_rec.doit
3804: , legislation_code = stu_rec.legislation_code
3805: , navigation_method = stu_rec.navigation_method

Line 3811: insert into hr_org_information_types

3807:
3808: IF SQL%NOTFOUND THEN
3809:
3810:
3811: insert into hr_org_information_types
3812: (org_information_type
3813: ,description
3814: ,destination
3815: ,displayed_org_information_type