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.

APPS.PAY_EGU_BUS dependencies on PAY_EVENT_GROUP_USAGES

Line 31: , pay_event_group_usages egu

27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , pay_event_group_usages egu
32: where egu.event_group_usage_id = p_event_group_usage_id
33: and pbg.business_group_id (+) = egu.business_group_id;
34: --
35: -- Declare local variables

Line 101: , pay_event_group_usages egu

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , pay_event_group_usages egu
102: where egu.event_group_usage_id = p_event_group_usage_id
103: and pbg.business_group_id (+) = egu.business_group_id;
104: --
105: -- Declare local variables

Line 300: (p_associated_column1 => 'PAY_EVENT_GROUP_USAGES.ELEMENT_SET_ID'

296:
297: exception
298: when app_exception.application_exception then
299: if hr_multi_message.exception_add
300: (p_associated_column1 => 'PAY_EVENT_GROUP_USAGES.ELEMENT_SET_ID'
301: ) then
302: raise;
303: end if;
304: when others then

Line 398: (p_associated_column1 => 'PAY_EVENT_GROUP_USAGES.EVENT_GROUP_ID'

394:
395: exception
396: when app_exception.application_exception then
397: if hr_multi_message.exception_add
398: (p_associated_column1 => 'PAY_EVENT_GROUP_USAGES.EVENT_GROUP_ID'
399: ) then
400: raise;
401: end if;
402: when others then

Line 415: -- Validates that there is only one row in PAY_EVENT_GROUP_USAGES

411: -- |------------------------< chk_event_group_ele_set >-----------------------|
412: -- ----------------------------------------------------------------------------
413: --
414: -- Description:
415: -- Validates that there is only one row in PAY_EVENT_GROUP_USAGES
416: -- with the combination of EVENT_GROUP_ID and ELEMENT_SET_ID
417: -- in a particular business group or legislation.
418: --
419: -- Pre-Requisites:

Line 450: from pay_event_group_usages egu

446: ) is
447: --
448: cursor csr_event_group_ele_set is
449: select null
450: from pay_event_group_usages egu
451: where egu.event_group_id = p_event_group_id
452: and egu.element_set_id = p_element_set_id
453: and ( p_business_group_id is null
454: or ( p_business_group_id is not null and p_business_group_id = egu.business_group_id )

Line 474: (p_check_column1 => 'PAY_EVENT_GROUP_USAGES.EVENT_GROUP_ID'

470:
471: hr_utility.set_location('Entering:'|| l_proc, 10);
472:
473: if hr_multi_message.no_exclusive_error
474: (p_check_column1 => 'PAY_EVENT_GROUP_USAGES.EVENT_GROUP_ID'
475: ,p_check_column2 => 'PAY_EVENT_GROUP_USAGES.ELEMENT_SET_ID'
476: ,p_associated_column1 => 'PAY_EVENT_GROUP_USAGES.EVENT_GROUP_ID'
477: ,p_associated_column2 => 'PAY_EVENT_GROUP_USAGES.ELEMENT_SET_ID'
478: ) then

Line 475: ,p_check_column2 => 'PAY_EVENT_GROUP_USAGES.ELEMENT_SET_ID'

471: hr_utility.set_location('Entering:'|| l_proc, 10);
472:
473: if hr_multi_message.no_exclusive_error
474: (p_check_column1 => 'PAY_EVENT_GROUP_USAGES.EVENT_GROUP_ID'
475: ,p_check_column2 => 'PAY_EVENT_GROUP_USAGES.ELEMENT_SET_ID'
476: ,p_associated_column1 => 'PAY_EVENT_GROUP_USAGES.EVENT_GROUP_ID'
477: ,p_associated_column2 => 'PAY_EVENT_GROUP_USAGES.ELEMENT_SET_ID'
478: ) then
479: --

Line 476: ,p_associated_column1 => 'PAY_EVENT_GROUP_USAGES.EVENT_GROUP_ID'

472:
473: if hr_multi_message.no_exclusive_error
474: (p_check_column1 => 'PAY_EVENT_GROUP_USAGES.EVENT_GROUP_ID'
475: ,p_check_column2 => 'PAY_EVENT_GROUP_USAGES.ELEMENT_SET_ID'
476: ,p_associated_column1 => 'PAY_EVENT_GROUP_USAGES.EVENT_GROUP_ID'
477: ,p_associated_column2 => 'PAY_EVENT_GROUP_USAGES.ELEMENT_SET_ID'
478: ) then
479: --
480: open csr_event_group_ele_set;

Line 477: ,p_associated_column2 => 'PAY_EVENT_GROUP_USAGES.ELEMENT_SET_ID'

473: if hr_multi_message.no_exclusive_error
474: (p_check_column1 => 'PAY_EVENT_GROUP_USAGES.EVENT_GROUP_ID'
475: ,p_check_column2 => 'PAY_EVENT_GROUP_USAGES.ELEMENT_SET_ID'
476: ,p_associated_column1 => 'PAY_EVENT_GROUP_USAGES.EVENT_GROUP_ID'
477: ,p_associated_column2 => 'PAY_EVENT_GROUP_USAGES.ELEMENT_SET_ID'
478: ) then
479: --
480: open csr_event_group_ele_set;
481: fetch csr_event_group_ele_set into l_exists;

Line 498: (p_associated_column1 => 'PAY_EVENT_GROUP_USAGES.EVENT_GROUP_ID',

494: exception
495:
496: when app_exception.application_exception then
497: if hr_multi_message.exception_add
498: (p_associated_column1 => 'PAY_EVENT_GROUP_USAGES.EVENT_GROUP_ID',
499: p_associated_column2 => 'PAY_EVENT_GROUP_USAGES.ELEMENT_SET_ID') then
500: raise;
501: end if;
502:

Line 499: p_associated_column2 => 'PAY_EVENT_GROUP_USAGES.ELEMENT_SET_ID') then

495:
496: when app_exception.application_exception then
497: if hr_multi_message.exception_add
498: (p_associated_column1 => 'PAY_EVENT_GROUP_USAGES.EVENT_GROUP_ID',
499: p_associated_column2 => 'PAY_EVENT_GROUP_USAGES.ELEMENT_SET_ID') then
500: raise;
501: end if;
502:
503: when others then

Line 567: (p_associated_column1 => 'PAY_EVENT_GROUP_USAGES.LEGISLATION_CODE'

563: --
564: exception
565: when app_exception.application_exception then
566: if hr_multi_message.exception_add
567: (p_associated_column1 => 'PAY_EVENT_GROUP_USAGES.LEGISLATION_CODE'
568: ) then
569: raise;
570: end if;
571: when others then