DBA Data[Home] [Help]

APPS.PAY_US_FLS_REPORTING_PKG dependencies on PER_ASSIGNMENTS_F

Line 379: per_assignments_f paf

375: lv_sql_string :=
376: 'select distinct paf.person_id
377: from pay_payroll_actions ppa,
378: pay_assignment_actions paa,
379: per_assignments_f paf
380: where ppa.business_group_id = ' || ln_business_group_id || '
381: and ppa.effective_date
382: between to_date(''' || to_char(ld_start_date, 'dd/mm/yyyy')
383: || ''',''dd/mm/yyyy'')

Line 460: per_assignments_f paf

456: paa.tax_unit_id,
457: paa.assignment_action_id
458: from pay_payroll_actions ppa,
459: pay_assignment_actions paa,
460: per_assignments_f paf
461: where ppa.business_group_id = cp_business_group_id
462: and ppa.effective_date between cp_start_date
463: and cp_end_date
464: and ppa.action_type = 'X'