DBA Data[Home] [Help]

APPS.PAY_KR_BATCH_YEA_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 10: from per_periods_of_service pds,

6: -- Bug 4442484: Include 'S'kipped assacts in c_range_code
7: c_range_cursor constant varchar2(32767) :=
8: 'select
9: distinct pds.person_id
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))

Line 117: per_periods_of_service pds,

113: select
114: asg.assignment_id
115: --
116: from per_assignments_f asg,
117: per_periods_of_service pds,
118: pay_payroll_actions ppa
119: --
120: where ppa.payroll_action_id = p_payroll_action_id
121: and pds.person_id between p_start_person_id and p_end_person_id

Line 230: per_periods_of_service pds,

226: select
227: asg.assignment_id
228: --
229: from per_assignments_f asg,
230: per_periods_of_service pds,
231: pay_payroll_actions ppa
232: --
233: where ppa.payroll_action_id = p_payroll_action_id
234: and pds.person_id between p_start_person_id and p_end_person_id