DBA Data[Home] [Help]

APPS.HR_LEGISLATION dependencies on HR_S_ORG_INFO_TYPES_BY_CLASS

Line 3719: delete from hr_s_org_info_types_by_class

3715:
3716: delete from hr_s_org_information_types
3717: where rowid = stu_rec.rowid;
3718:
3719: delete from hr_s_org_info_types_by_class
3720: where org_information_type = stu_rec.org_information_type;
3721:
3722: END remove;
3723:

Line 3758: from hr_s_org_info_types_by_class

3754: ((select ORG_CLASSIFICATION,
3755: ORG_INFORMATION_TYPE,
3756: MANDATORY_FLAG,
3757: ENABLED_FLAG
3758: from hr_s_org_info_types_by_class
3759: where org_information_type = stu_rec.org_information_type
3760: MINUS
3761: select ORG_CLASSIFICATION,
3762: ORG_INFORMATION_TYPE,

Line 3780: from hr_s_org_info_types_by_class

3776: select ORG_CLASSIFICATION,
3777: ORG_INFORMATION_TYPE,
3778: MANDATORY_FLAG,
3779: ENABLED_FLAG
3780: from hr_s_org_info_types_by_class
3781: where org_information_type = stu_rec.org_information_type
3782: ));
3783:
3784: remove;

Line 3847: from hr_s_org_info_types_by_class

3843: select org_classification
3844: , org_information_type
3845: , mandatory_flag
3846: , 'Y' -- default to Y at least for now
3847: from hr_s_org_info_types_by_class
3848: where org_information_type = stu_rec.org_information_type;
3849:
3850: remove;
3851: