DBA Data[Home] [Help]

APPS.PAY_CA_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 1826: , per_all_assignments_f ASSIGN

1822: , hr_lookups f
1823: , hr_lookups g
1824: , hr_lookups h
1825: , hr_lookups i
1826: , per_all_assignments_f ASSIGN
1827: where l_effective_date BETWEEN
1828: ASSIGN.effective_start_date
1829: AND ASSIGN.effective_end_date
1830: and ASSIGN.assignment_id = l_assignment_id

Line 1877: from per_all_assignments_f assign,

1873: addr.region_1 province,
1874: addr.country country,
1875: addr.postal_code postal_code,
1876: addr.telephone_number_1 telephone_number
1877: from per_all_assignments_f assign,
1878: per_addresses addr
1879: where assign.assignment_id = l_assignment_id
1880: and l_effective_date BETWEEN
1881: assign.effective_start_date

Line 1957: per_all_assignments_f assign

1953: cursor cur_asg_job is
1954: select
1955: job.name name
1956: from
1957: per_all_assignments_f assign
1958: , per_grades grade
1959: , per_jobs job
1960: , per_assignment_status_types ast
1961: , pay_all_payrolls_f payroll