DBA Data[Home] [Help]

APPS.PAY_KR_SEP_ARCHIVE_PKG dependencies on PER_ASSIGNMENTS_F

Line 11: per_assignments_f paa

7:
8: c_range_cursor constant varchar2(3000) := -- 4660184
9: 'select distinct paa.person_id
10: from pay_payroll_actions bppa,
11: per_assignments_f paa
12: where bppa.payroll_action_id = :payroll_action_id
13: and paa.business_group_id = bppa.business_group_id
14: and paa.payroll_id = to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(bppa.payroll_action_id, ''PAYROLL_ID'', null))
15: order by 1';

Line 265: per_assignments_f paaf,

261: pay_input_values_f piv2,
262: pay_input_values_f piv3,
263: pay_input_values_f piv4,
264: per_people_f pap,
265: per_assignments_f paaf,
266: pay_run_types_f prt,
267: fnd_territories ft
268: where ppa.payroll_action_id = p_payroll_action_id
269: and ppa.business_group_id = p_business_group_id

Line 699: per_assignments_f pa,

695: paa.tax_unit_id
696: from pay_run_types_f prt,
697: pay_payroll_actions ppa,
698: pay_assignment_actions paa,
699: per_assignments_f pa,
700: pay_payroll_actions bppa
701: where bppa.payroll_action_id = p_payroll_action_id
702: and pa.business_group_id = bppa.business_group_id
703: and pa.person_id