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_W4_WF dependencies on PAY_STAT_TRANS_AUDIT

Line 103: PROCEDURE start_wf(p_transaction_id IN pay_stat_trans_audit.stat_trans_audit_id%TYPE,

99:
100: end set_custom_wf_globals;
101:
102:
103: PROCEDURE start_wf(p_transaction_id IN pay_stat_trans_audit.stat_trans_audit_id%TYPE,
104: p_process IN VARCHAR2
105: )
106: /******************************************************************
107: **

Line 164: from pay_stat_trans_audit

160: lv_status_code VARCHAR2(30);
161:
162: CURSOR c_transaction IS
163: select *
164: from pay_stat_trans_audit
165: where source4_type = 'TRANSACTION_ID'
166: and source4 = ln_transaction_id;
167:
168:

Line 171: from pay_stat_trans_audit pta

167:
168:
169: CURSOR c_state_list IS
170: select pus.state_name
171: from pay_stat_trans_audit pta
172: ,pay_us_states pus
173: where pta.source4 = ln_transaction_id
174: and pus.state_code = substr(pta.source1,1,2)
175: and exists(select 'x' from pay_us_state_tax_info_f stif

Line 186: from pay_stat_trans_audit pta

182:
183:
184: CURSOR c_exempt_state_list IS
185: select pus.state_name
186: from pay_stat_trans_audit pta
187: ,pay_us_states pus
188: where pta.source4 = ln_transaction_id
189: and pus.state_code = substr(pta.source1,1,2)
190: and exists(select 'x' from pay_us_state_tax_info_f stif

Line 381: ln_transaction_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;

377: ******************************************************************/
378:
379: l_proc varchar2(80) := gv_package||'check_final_notifier';
380: lv_contact_source VARCHAR2(50);
381: ln_transaction_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;
382: ln_current_assignment_id per_assignments_f.assignment_id%TYPE;
383: lv_contact_user_name VARCHAR2(150);
384: ln_contact_person_id per_people_f.person_id%TYPE;
385: ln_employee_person_id per_people_f.person_id%TYPE;

Line 391: from pay_stat_trans_audit pta

387: -- get the payroll contact
388:
389: CURSOR c_payroll_contact IS
390: select /*+ ordered */ prl.prl_information1 --Bug 3362223
391: from pay_stat_trans_audit pta
392: ,per_assignments_f paf
393: ,pay_payrolls_f prl
394: where prl.payroll_id = paf.payroll_id
395: and prl.prl_information_category = 'US'

Line 415: from pay_stat_trans_audit pta

411: from hr_organization_information org
412: where org.org_information_context || '' = 'Contact Information'
413: and org.organization_id =
414: (select /*+ ordered */ hsc.segment1 --Bug 3362223
415: from pay_stat_trans_audit pta
416: ,per_assignments_f paf
417: ,hr_soft_coding_keyflex hsc
418: where hsc.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
419: and paf.assignment_id = pta.assignment_id

Line 430: ,pay_stat_trans_audit pta

426: /*
427: select org.org_information1
428: from hr_organization_information org
429: ,per_assignments_f paf
430: ,pay_stat_trans_audit pta
431: ,hr_soft_coding_keyflex hsc
432: where org.organization_id = hsc.segment1
433: and hsc.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
434: and paf.assignment_id = pta.assignment_id

Line 556: ln_transaction_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;

552: ******************************************************************/
553: IS
554:
555: l_proc varchar2(61) := gv_package||'get_next_payroll_notifer';
556: ln_transaction_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;
557: ln_current_assignment_id per_assignments_f.assignment_id%TYPE;
558: lv_contact_source VARCHAR2(50);
559: lv_curr_contact_user VARCHAR2(100);
560: lv_next_contact_user VARCHAR2(100);

Line 568: from pay_stat_trans_audit pta

564:
565: CURSOR c_payroll_contact IS
566: select /*+ ordered */ usr.employee_id --Bug 3362223
567: ,pta.assignment_id
568: from pay_stat_trans_audit pta
569: ,per_assignments_f paf
570: ,pay_payrolls_f prl
571: ,fnd_user usr
572: where prl.payroll_id = paf.payroll_id

Line 590: ,pay_stat_trans_audit pta

586: CURSOR c_gre_contact IS
587: select usr.employee_id
588: ,pta.assignment_id
589: from hr_organization_information org
590: ,pay_stat_trans_audit pta
591: ,fnd_user usr
592: where usr.user_name = org.org_information1
593: and pta.assignment_id = ln_current_assignment_id
594: and pta.source4 = ln_transaction_id

Line 738: from pay_stat_trans_audit

734: ,source2
735: ,source2_type
736: ,audit_information2
737: ,audit_information4
738: from pay_stat_trans_audit
739: where source4_type = 'TRANSACTION_ID'
740: and source4 = ln_transaction_id;
741:
742: CURSOR c_fed_allowance_limit is