eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_ZA_COIDA_ARCHIVE dependencies on PER_ASSIGNMENTS_F

Line 313: from per_assignments_f ass,

309: where payroll_action_id = pactid;
310:
311: sqlstr :=
312: 'select distinct ass.person_id
313: from per_assignments_f ass,
314: pay_payrolls_f ppf,
315: pay_payroll_actions ppa
316: where ppa.payroll_action_id = :payroll_action_id
317: and ass.business_group_id = ppa.business_group_id

Line 381: per_assignments_f asgm

377: AND asg.effective_end_date =
378: ( SELECT
379: MAX(asgm.effective_end_date)
380: FROM
381: per_assignments_f asgm
382: WHERE
383: asgm.assignment_id = asg.assignment_id
384: AND g_start_period_date <= asgm.effective_end_date
385: AND g_end_period_date >= asgm.effective_start_date

Line 1059: per_assignments_f asgm

1055: AND asg.effective_end_date =
1056: ( SELECT
1057: MAX(asgm.effective_end_date)
1058: FROM
1059: per_assignments_f asgm
1060: WHERE
1061: asgm.assignment_id = asg.assignment_id
1062: AND g_start_period_date <= asgm.effective_end_date
1063: AND g_end_period_date >= asgm.effective_start_date