DBA Data[Home] [Help]

APPS.PAY_US_FLS_REPORTING_PKG dependencies on PER_ASSIGNMENTS_F

Line 370: per_assignments_f paf

366: lv_sql_string :=
367: 'select distinct paf.person_id
368: from pay_payroll_actions ppa,
369: pay_assignment_actions paa,
370: per_assignments_f paf
371: where ppa.business_group_id = ' || ln_business_group_id || '
372: and ppa.effective_date
373: between to_date(''' || to_char(ld_start_date, 'dd/mm/yyyy')
374: || ''',''dd/mm/yyyy'')

Line 451: per_assignments_f paf

447: paa.tax_unit_id,
448: paa.assignment_action_id
449: from pay_payroll_actions ppa,
450: pay_assignment_actions paa,
451: per_assignments_f paf
452: where ppa.business_group_id = cp_business_group_id
453: and ppa.effective_date between cp_start_date
454: and cp_end_date
455: and ppa.action_type = 'X'