DBA Data[Home] [Help]

APPS.PAY_US_EMP_BALADJ_CLEANUP dependencies on PER_ASSIGNMENTS_F

Line 678: from per_assignments_f paf,

674: from dual;
675:
676: lv_sql_string :=
677: 'select distinct paf.person_id
678: from per_assignments_f paf,
679: pay_assignment_actions paa,
680: pay_payroll_actions ppa
681: where ppa.business_group_id = ''' || ln_business_group_id || '''
682: and paf.assignment_id = paa.assignment_id

Line 735: from per_assignments_f paf,

731: select distinct
732: paa.tax_unit_id,
733: paa.assignment_id,
734: ppa.effective_date
735: from per_assignments_f paf,
736: pay_assignment_actions paa,
737: pay_payroll_actions ppa
738: where paf.person_id between cp_start_person_id
739: and cp_end_person_id

Line 780: from per_assignments_f paf,

776: select distinct
777: paa.tax_unit_id,
778: paa.assignment_id,
779: ppa.effective_date
780: from per_assignments_f paf,
781: pay_us_emp_state_tax_rules_f pest,
782: pay_assignment_actions paa,
783: pay_payroll_actions ppa
784: where paf.person_id between cp_start_person_id