DBA Data[Home] [Help]

APPS.PAY_RUN_BALANCE_BUILD dependencies on PER_PERIODS_OF_SERVICE

Line 1319: per_periods_of_service pos,

1315: if (g_save_asg_run_bals = 'Y') then
1316: lv_sql_string :=
1317: 'select distinct asg.person_id
1318: from
1319: per_periods_of_service pos,
1320: per_assignments_f asg,
1321: pay_payroll_actions ppa
1322: where ppa.payroll_action_id = :payroll_action_id
1323: and pos.person_id = asg.person_id

Line 1377: per_periods_of_service pos,

1373: select distinct
1374: paf.assignment_id assignment_id,
1375: paf.person_id
1376: from
1377: per_periods_of_service pos,
1378: per_all_assignments_f paf,
1379: pay_payroll_actions ppa
1380: where pos.person_id between stperson and endperson
1381: and pos.person_id = paf.person_id