DBA Data[Home] [Help]

APPS.PAY_RUN_BALANCE_BUILD dependencies on PER_ALL_ASSIGNMENTS_F

Line 1673: per_all_assignments_f paf,

1669: paf.assignment_id assignment_id,
1670: paf.person_id
1671: from
1672: per_periods_of_service pos,
1673: per_all_assignments_f paf,
1674: pay_payroll_actions ppa
1675: where pos.person_id between stperson and endperson
1676: and pos.person_id = paf.person_id
1677: and pos.period_of_service_id = paf.period_of_service_id

Line 1691: per_all_assignments_f paf,

1687: paf.assignment_id assignment_id,
1688: paf.person_id
1689: from
1690: per_periods_of_service pos,
1691: per_all_assignments_f paf,
1692: pay_payroll_actions ppa,
1693: pay_population_ranges ppr
1694: where ppr.chunk_number = c_chunk
1695: and ppr.payroll_action_id = ppa.payroll_action_id

Line 1766: per_all_assignments_f paf,

1762: 1 object_version_number
1763: from
1764: ( select distinct paf.assignment_id from
1765: per_periods_of_service pos,
1766: per_all_assignments_f paf,
1767: pay_payroll_actions ppa,
1768: pay_population_ranges ppr
1769: where ppr.chunk_number = p_chunk
1770: and ppr.payroll_action_id = ppa.payroll_action_id

Line 1800: per_all_assignments_f paf,

1796: 1 object_version_number
1797: from
1798: ( select distinct paf.assignment_id from
1799: per_periods_of_service pos,
1800: per_all_assignments_f paf,
1801: pay_payroll_actions ppa,
1802: pay_population_ranges ppr
1803: where pos.person_id between p_start_person_id and p_end_person_id
1804: and ppr.payroll_action_id = ppa.payroll_action_id