eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.HR_LEGISLATION dependencies on HR_ORG_INFO_TYPES_BY_CLASS

Line 3519: from hr_org_info_types_by_class

3515: select ORG_CLASSIFICATION,
3516: ORG_INFORMATION_TYPE,
3517: MANDATORY_FLAG,
3518: ENABLED_FLAG
3519: from hr_org_info_types_by_class
3520: where org_information_type = stu_rec.org_information_type
3521: )
3522: UNION
3523: (select ORG_CLASSIFICATION,

Line 3527: from hr_org_info_types_by_class

3523: (select ORG_CLASSIFICATION,
3524: ORG_INFORMATION_TYPE,
3525: MANDATORY_FLAG,
3526: ENABLED_FLAG
3527: from hr_org_info_types_by_class
3528: where org_information_type = stu_rec.org_information_type
3529: MINUS
3530: select ORG_CLASSIFICATION,
3531: ORG_INFORMATION_TYPE,

Line 3587: delete from hr_org_info_types_by_class

3583:
3584: END IF;
3585:
3586:
3587: delete from hr_org_info_types_by_class
3588: where org_information_type = stu_rec.org_information_type;
3589:
3590:
3591: insert into hr_org_info_types_by_class

Line 3591: insert into hr_org_info_types_by_class

3587: delete from hr_org_info_types_by_class
3588: where org_information_type = stu_rec.org_information_type;
3589:
3590:
3591: insert into hr_org_info_types_by_class
3592: (ORG_CLASSIFICATION
3593: ,ORG_INFORMATION_TYPE
3594: ,MANDATORY_FLAG
3595: ,ENABLED_FLAG