DBA Data[Home] [Help]

APPS.HR_LEGISLATION dependencies on HR_S_ORG_INFO_TYPES_BY_CLASS

Line 3473: delete from hr_s_org_info_types_by_class

3469:
3470: delete from hr_s_org_information_types
3471: where rowid = stu_rec.rowid;
3472:
3473: delete from hr_s_org_info_types_by_class
3474: where org_information_type = stu_rec.org_information_type;
3475:
3476: END remove;
3477:

Line 3512: from hr_s_org_info_types_by_class

3508: ((select ORG_CLASSIFICATION,
3509: ORG_INFORMATION_TYPE,
3510: MANDATORY_FLAG,
3511: ENABLED_FLAG
3512: from hr_s_org_info_types_by_class
3513: where org_information_type = stu_rec.org_information_type
3514: MINUS
3515: select ORG_CLASSIFICATION,
3516: ORG_INFORMATION_TYPE,

Line 3534: from hr_s_org_info_types_by_class

3530: select ORG_CLASSIFICATION,
3531: ORG_INFORMATION_TYPE,
3532: MANDATORY_FLAG,
3533: ENABLED_FLAG
3534: from hr_s_org_info_types_by_class
3535: where org_information_type = stu_rec.org_information_type
3536: ));
3537:
3538: remove;

Line 3601: from hr_s_org_info_types_by_class

3597: select org_classification
3598: , org_information_type
3599: , mandatory_flag
3600: , 'Y' -- default to Y at least for now
3601: from hr_s_org_info_types_by_class
3602: where org_information_type = stu_rec.org_information_type;
3603:
3604: remove;
3605: