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_KR_BATCH_YEA_PKG dependencies on PAY_KR_FF_FUNCTIONS_PKG

Line 14: and asg.payroll_id = to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, ''PAYROLL_ID'', null))

10: from per_periods_of_service pds,
11: per_assignments_f asg,
12: pay_payroll_actions ppa
13: where ppa.payroll_action_id = :payroll_action_id
14: and asg.payroll_id = to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, ''PAYROLL_ID'', null))
15: and ppa.effective_date between asg.effective_start_date and asg.effective_end_date
16: and pds.period_of_service_id = asg.period_of_service_id
17: and ppa.effective_date between pds.date_start and nvl(pds.final_process_date, ppa.effective_date)
18: and exists

Line 21: where paa.payroll_action_id = to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, ''BAL_ADJ_ACTION_ID'', null))

17: and ppa.effective_date between pds.date_start and nvl(pds.final_process_date, ppa.effective_date)
18: and exists
19: ( select paa.assignment_id
20: from pay_assignment_actions paa
21: where paa.payroll_action_id = to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, ''BAL_ADJ_ACTION_ID'', null))
22: and paa.assignment_id = asg.assignment_id
23: and paa.action_status in (''C'', ''S'')
24: )
25: order by pds.person_id';

Line 77: to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'BAL_ADJ_ACTION_ID', null)) bal_adj_action_id,

73: ppa.report_qualifier,
74: ppa.report_category,
75: ppa.business_group_id,
76: ppa.effective_date,
77: to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'BAL_ADJ_ACTION_ID', null)) bal_adj_action_id,
78: to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'PAYROLL_ID', null)) payroll_id,
79: to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'CONSOLIDATION_SET_ID', null)) consolidation_set_id
80: --
81: into g_pact.payroll_action_id

Line 78: to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'PAYROLL_ID', null)) payroll_id,

74: ppa.report_category,
75: ppa.business_group_id,
76: ppa.effective_date,
77: to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'BAL_ADJ_ACTION_ID', null)) bal_adj_action_id,
78: to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'PAYROLL_ID', null)) payroll_id,
79: to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'CONSOLIDATION_SET_ID', null)) consolidation_set_id
80: --
81: into g_pact.payroll_action_id
82: ,g_pact.report_type

Line 79: to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'CONSOLIDATION_SET_ID', null)) consolidation_set_id

75: ppa.business_group_id,
76: ppa.effective_date,
77: to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'BAL_ADJ_ACTION_ID', null)) bal_adj_action_id,
78: to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'PAYROLL_ID', null)) payroll_id,
79: to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'CONSOLIDATION_SET_ID', null)) consolidation_set_id
80: --
81: into g_pact.payroll_action_id
82: ,g_pact.report_type
83: ,g_pact.report_qualifier

Line 165: where paa6.payroll_action_id = to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'BAL_ADJ_ACTION_ID', null))

161: --
162: and exists (
163: select null
164: from pay_assignment_actions paa6
165: where paa6.payroll_action_id = to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'BAL_ADJ_ACTION_ID', null))
166: and paa6.assignment_id = asg.assignment_id
167: and paa6.action_status in ('C', 'S')) -- Bug 4442484: Include 'S'kipped assacts
168: --
169: for update of pds.period_of_service_id, asg.assignment_id;

Line 293: where paa6.payroll_action_id = to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'BAL_ADJ_ACTION_ID', null))

289: --
290: and exists (
291: select null
292: from pay_assignment_actions paa6
293: where paa6.payroll_action_id = to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'BAL_ADJ_ACTION_ID', null))
294: and paa6.assignment_id = asg.assignment_id
295: and paa6.action_status in ('C', 'S')) -- Bug 4442484: Include 'S'kipped assacts
296: --
297: for update of pds.period_of_service_id, asg.assignment_id;

Line 376: l_archive_type_used := pay_kr_ff_functions_pkg.get_legislative_parameter(

372: hr_utility.trace('Balance Adjustment Assignment Action Id : '||to_char(l_bal_adj_asg_action_id));
373: end if;
374: --
375: -- Bug 5225198
376: l_archive_type_used := pay_kr_ff_functions_pkg.get_legislative_parameter(
377: g_pact.payroll_action_id, 'ARCHIVE_TYPE', 'AAC');
378:
379: pay_kr_yea_pkg.process_assignment(
380: p_validate => false,