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_PYUCSLIS_PKG dependencies on PAY_CORE_UTILS

Line 3096: select pay_core_utils.get_parameter('GENERATION_SCOPE',

3092: l_generation_scope varchar2(20);
3093: begin
3094: --hr_utility.trace_on('F','LISTGEN');
3095: hr_utility.set_location('Entering : '||l_proc,10);
3096: select pay_core_utils.get_parameter('GENERATION_SCOPE',
3097: pa1.legislative_parameters)
3098: into l_generation_scope
3099: from pay_payroll_actions pa1
3100: where payroll_action_id = pactid;

Line 3126: and pay_core_utils.get_parameter(''BUSINESS_GROUP_ID'',

3122: sqlstr := 'select distinct per.person_id
3123: from per_all_people_f per
3124: ,pay_payroll_actions ppa
3125: where ppa.payroll_action_id = :payroll_action_id
3126: and pay_core_utils.get_parameter(''BUSINESS_GROUP_ID'',
3127: ppa.legislative_parameters) =
3128: per.business_group_id
3129: order by per.person_id';
3130: -- and ppa.effective_date between per.effective_start_date

Line 3263: and ( pay_core_utils.get_parameter('BUSINESS_GROUP_ID',

3259: ,pay_payroll_actions ppa
3260: where asg.assignment_type in ('E','A','C')
3261: and asg.person_id between stperson and endperson
3262: and ppa.payroll_action_id = pactid
3263: and ( pay_core_utils.get_parameter('BUSINESS_GROUP_ID',
3264: ppa.legislative_parameters) =
3265: asg.business_group_id
3266: and pay_core_utils.get_parameter('GENERATION_SCOPE',
3267: ppa.legislative_parameters) =

Line 3266: and pay_core_utils.get_parameter('GENERATION_SCOPE',

3262: and ppa.payroll_action_id = pactid
3263: and ( pay_core_utils.get_parameter('BUSINESS_GROUP_ID',
3264: ppa.legislative_parameters) =
3265: asg.business_group_id
3266: and pay_core_utils.get_parameter('GENERATION_SCOPE',
3267: ppa.legislative_parameters) =
3268: 'ALL_BUS_GRP'
3269: OR
3270: pay_core_utils.get_parameter('GENERATION_SCOPE',

Line 3270: pay_core_utils.get_parameter('GENERATION_SCOPE',

3266: and pay_core_utils.get_parameter('GENERATION_SCOPE',
3267: ppa.legislative_parameters) =
3268: 'ALL_BUS_GRP'
3269: OR
3270: pay_core_utils.get_parameter('GENERATION_SCOPE',
3271: ppa.legislative_parameters) =
3272: 'ALL_GLOBAL'
3273: OR
3274: pay_core_utils.get_parameter('GENERATION_SCOPE',

Line 3274: pay_core_utils.get_parameter('GENERATION_SCOPE',

3270: pay_core_utils.get_parameter('GENERATION_SCOPE',
3271: ppa.legislative_parameters) =
3272: 'ALL_GLOBAL'
3273: OR
3274: pay_core_utils.get_parameter('GENERATION_SCOPE',
3275: ppa.legislative_parameters) =
3276: 'ALL_PROFILES')
3277: and ((ppa.effective_date between asg.effective_start_date
3278: and asg.effective_end_date)

Line 3293: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',

3289: begin
3290:
3291: l_temp_person_id := null;
3292:
3293: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',
3294: ppa.legislative_parameters),
3295: pay_core_utils.get_parameter('GENERATION_SCOPE',
3296: ppa.legislative_parameters),
3297: pay_core_utils.get_parameter('WHO_TO_PROCESS',

Line 3295: pay_core_utils.get_parameter('GENERATION_SCOPE',

3291: l_temp_person_id := null;
3292:
3293: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',
3294: ppa.legislative_parameters),
3295: pay_core_utils.get_parameter('GENERATION_SCOPE',
3296: ppa.legislative_parameters),
3297: pay_core_utils.get_parameter('WHO_TO_PROCESS',
3298: ppa.legislative_parameters)
3299: into l_business_group_id, l_generation_scope, l_who_to_proc

Line 3297: pay_core_utils.get_parameter('WHO_TO_PROCESS',

3293: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',
3294: ppa.legislative_parameters),
3295: pay_core_utils.get_parameter('GENERATION_SCOPE',
3296: ppa.legislative_parameters),
3297: pay_core_utils.get_parameter('WHO_TO_PROCESS',
3298: ppa.legislative_parameters)
3299: into l_business_group_id, l_generation_scope, l_who_to_proc
3300: from pay_payroll_actions ppa
3301: where ppa.payroll_action_id = pactid;

Line 3451: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',

3447: begin
3448: --hr_utility.trace_on('F','PERSLM');
3449:
3450:
3451: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',
3452: ppa.legislative_parameters),
3453: pay_core_utils.get_parameter('GENERATION_SCOPE',
3454: ppa.legislative_parameters),
3455: pay_core_utils.get_parameter('WHO_TO_PROCESS',

Line 3453: pay_core_utils.get_parameter('GENERATION_SCOPE',

3449:
3450:
3451: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',
3452: ppa.legislative_parameters),
3453: pay_core_utils.get_parameter('GENERATION_SCOPE',
3454: ppa.legislative_parameters),
3455: pay_core_utils.get_parameter('WHO_TO_PROCESS',
3456: ppa.legislative_parameters)
3457: into l_business_group_id, l_generation_scope, l_who_to_process

Line 3455: pay_core_utils.get_parameter('WHO_TO_PROCESS',

3451: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',
3452: ppa.legislative_parameters),
3453: pay_core_utils.get_parameter('GENERATION_SCOPE',
3454: ppa.legislative_parameters),
3455: pay_core_utils.get_parameter('WHO_TO_PROCESS',
3456: ppa.legislative_parameters)
3457: into l_business_group_id, l_generation_scope, l_who_to_process
3458: from pay_payroll_actions ppa,
3459: pay_assignment_actions paa