APPS.PAY_US_TAX_WF dependencies on PAY_STAT_TRANS_AUDIT

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

63:
64: end set_custom_wf_globals;
65:
66:
67: PROCEDURE start_wf(p_transaction_id IN pay_stat_trans_audit.stat_trans_audit_id%TYPE,
68: p_process IN VARCHAR2
69: )
70: /******************************************************************
71: **

Line 128: from pay_stat_trans_audit

124: lv_status_code VARCHAR2(30);
125:
126: CURSOR c_transaction IS
127: select *
128: from pay_stat_trans_audit
129: where stat_trans_audit_id = ln_transaction_id;
130:
131: CURSOR c_state_list IS
132: select pus.state_name

Line 133: from pay_stat_trans_audit pta

129: where stat_trans_audit_id = ln_transaction_id;
130:
131: CURSOR c_state_list IS
132: select pus.state_name
133: from pay_stat_trans_audit pta
134: ,pay_us_states pus
135: where pta.transaction_parent_id = ln_transaction_id
136: and pus.state_code = substr(pta.source1,1,2)
137: and exists(select 'x' from pay_us_state_tax_info_f stif

Line 302: ln_transaction_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;

298: ******************************************************************/
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;

Line 310: from pay_stat_trans_audit pta

306: ln_employee_person_id per_people_f.person_id%TYPE;
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'

Line 326: from pay_stat_trans_audit pta

322: order by pta.assignment_id asc;
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

Line 444: ln_transaction_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;

440: ******************************************************************/
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);

Line 456: from pay_stat_trans_audit pta

452:
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

Line 475: from pay_stat_trans_audit pta

471:
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

Line 618: from pay_stat_trans_audit

614: ,source1
615: ,source1_type
616: ,audit_information2
617: ,audit_information4
618: from pay_stat_trans_audit
619: where stat_trans_audit_id = ln_transaction_id;
620:
621: CURSOR c_fed_allowance_limit is
622: select fed_information1