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_US_TAX_WF dependencies on PER_ASSIGNMENTS_F

Line 303: ln_current_assignment_id per_assignments_f.assignment_id%TYPE;

299:
300: l_proc varchar2(80) := gv_package||'check_final_notifier';
301: lv_contact_source VARCHAR2(50);
302: ln_transaction_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;
303: ln_current_assignment_id per_assignments_f.assignment_id%TYPE;
304: lv_contact_user_name VARCHAR2(150);
305: ln_contact_person_id per_people_f.person_id%TYPE;
306: ln_employee_person_id per_people_f.person_id%TYPE;
307:

Line 311: ,per_assignments_f paf

307:
308: CURSOR c_payroll_contact IS
309: select /*+ ordered */ prl.prl_information1 --Bug 3361934
310: from pay_stat_trans_audit pta
311: ,per_assignments_f paf
312: ,pay_payrolls_f prl
313: where prl.payroll_id = paf.payroll_id
314: and prl.prl_information_category = 'US'
315: and paf.assignment_id = pta.assignment_id

Line 327: ,per_assignments_f paf

323:
324: CURSOR c_gre_contact IS
325: select /*+ ordered */ org.org_information1 --Bug 3361934
326: from pay_stat_trans_audit pta
327: ,per_assignments_f paf
328: ,hr_soft_coding_keyflex hsc
329: ,hr_organization_information org
330: where org.organization_id = hsc.segment1
331: and hsc.soft_coding_keyflex_id = paf.soft_coding_keyflex_id

Line 445: ln_current_assignment_id per_assignments_f.assignment_id%TYPE;

441: IS
442:
443: l_proc varchar2(61) := gv_package||'get_next_payroll_notifer';
444: ln_transaction_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;
445: ln_current_assignment_id per_assignments_f.assignment_id%TYPE;
446: lv_contact_source VARCHAR2(50);
447: lv_curr_contact_user VARCHAR2(100);
448: lv_next_contact_user VARCHAR2(100);
449: lv_dummy VARCHAR2(100);

Line 457: ,per_assignments_f paf

453: CURSOR c_payroll_contact IS
454: select /*+ ordered */ usr.employee_id --Bug 3361934
455: ,pta.assignment_id
456: from pay_stat_trans_audit pta
457: ,per_assignments_f paf
458: ,pay_payrolls_f prl
459: ,fnd_user usr
460: where prl.payroll_id = paf.payroll_id
461: and usr.user_name = prl.prl_information1

Line 476: ,per_assignments_f paf

472: CURSOR c_gre_contact IS
473: select /*+ ordered */ usr.employee_id --Bug 3361934
474: ,pta.assignment_id
475: from pay_stat_trans_audit pta
476: ,per_assignments_f paf
477: ,hr_soft_coding_keyflex hsc
478: ,hr_organization_information org
479: ,fnd_user usr
480: where org.organization_id = hsc.segment1