DBA Data[Home] [Help]

APPS.PAY_KR_BATCH_YEA_PKG dependencies on PER_ASSIGNMENTS_F

Line 11: per_assignments_f asg,

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))
15: and ppa.effective_date between asg.effective_start_date and asg.effective_end_date

Line 116: from per_assignments_f asg,

112: IS
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

Line 229: from per_assignments_f asg,

225: IS
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