DBA Data[Home] [Help]

APPS.PAY_CA_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 1822: , per_all_assignments_f ASSIGN

1818: , hr_lookups f
1819: , hr_lookups g
1820: , hr_lookups h
1821: , hr_lookups i
1822: , per_all_assignments_f ASSIGN
1823: where l_effective_date BETWEEN
1824: ASSIGN.effective_start_date
1825: AND ASSIGN.effective_end_date
1826: and ASSIGN.assignment_id = l_assignment_id

Line 1873: from per_all_assignments_f assign,

1869: addr.region_1 province,
1870: addr.country country,
1871: addr.postal_code postal_code,
1872: addr.telephone_number_1 telephone_number
1873: from per_all_assignments_f assign,
1874: per_addresses addr
1875: where assign.assignment_id = l_assignment_id
1876: and l_effective_date BETWEEN
1877: assign.effective_start_date

Line 1953: per_all_assignments_f assign

1949: cursor cur_asg_job is
1950: select
1951: job.name name
1952: from
1953: per_all_assignments_f assign
1954: , per_grades grade
1955: , per_jobs job
1956: , per_assignment_status_types ast
1957: , pay_all_payrolls_f payroll