APPS.PAY_RUN_BALANCE_BUILD dependencies on PER_PERIODS_OF_SERVICE

Line 1614: per_periods_of_service pos,

1610: if (g_save_asg_run_bals = 'Y') then
1611: lv_sql_string :=
1612: 'select distinct asg.person_id
1613: from
1614: per_periods_of_service pos,
1615: per_assignments_f asg,
1616: pay_payroll_actions ppa
1617: where ppa.payroll_action_id = :payroll_action_id
1618: and pos.person_id = asg.person_id

Line 1672: per_periods_of_service pos,

1668: select distinct
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

Line 1690: per_periods_of_service pos,

1686: select distinct
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

Line 1765: per_periods_of_service pos,

1761: pay_assignment_actions_s.currval action_sequence,
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

Line 1799: per_periods_of_service pos,

1795: pay_assignment_actions_s.currval action_sequence,
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