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 270: per_assignments_f paaf,

266: pay_input_values_f piv2,
267: pay_input_values_f piv3,
268: pay_input_values_f piv4,
269: per_people_f pap,
270: per_assignments_f paaf,
271: pay_run_types_f prt,
272: fnd_territories ft,
273: per_addresses adr
274: where ppa.payroll_action_id = p_payroll_action_id

Line 802: per_assignments_f pa,

798: paa.tax_unit_id
799: from pay_run_types_f prt,
800: pay_payroll_actions ppa,
801: pay_assignment_actions paa,
802: per_assignments_f pa,
803: pay_payroll_actions bppa
804: where bppa.payroll_action_id = p_payroll_action_id
805: and pa.business_group_id = bppa.business_group_id
806: and pa.person_id