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_API dependencies on PAY_US_EMP_FED_TAX_RULES_F

Line 427: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;

423: ln_business_group_id per_people_f.business_group_id%TYPE;
424: ln_parent_audit_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;
425: ln_assignment_id per_assignments_f.assignment_id%TYPE;
426: ln_gre_id hr_organization_units.organization_id%TYPE;
427: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
428: ln_ovn pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
429: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
430: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
431: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

Line 428: ln_ovn pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;

424: ln_parent_audit_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;
425: ln_assignment_id per_assignments_f.assignment_id%TYPE;
426: ln_gre_id hr_organization_units.organization_id%TYPE;
427: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
428: ln_ovn pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
429: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
430: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
431: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
432: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;

Line 429: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

425: ln_assignment_id per_assignments_f.assignment_id%TYPE;
426: ln_gre_id hr_organization_units.organization_id%TYPE;
427: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
428: ln_ovn pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
429: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
430: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
431: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
432: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
433: lv_state_filing_status_code pay_us_emp_state_tax_rules_f.filing_status_code%TYPE;

Line 430: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

426: ln_gre_id hr_organization_units.organization_id%TYPE;
427: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
428: ln_ovn pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
429: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
430: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
431: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
432: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
433: lv_state_filing_status_code pay_us_emp_state_tax_rules_f.filing_status_code%TYPE;
434: lv_context pay_stat_trans_audit.audit_information_category%TYPE;

Line 431: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

427: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
428: ln_ovn pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
429: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
430: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
431: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
432: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
433: lv_state_filing_status_code pay_us_emp_state_tax_rules_f.filing_status_code%TYPE;
434: lv_context pay_stat_trans_audit.audit_information_category%TYPE;
435: ln_dummy NUMBER(15);

Line 432: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;

428: ln_ovn pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
429: ld_old_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
430: ld_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
431: ld_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
432: lv_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
433: lv_state_filing_status_code pay_us_emp_state_tax_rules_f.filing_status_code%TYPE;
434: lv_context pay_stat_trans_audit.audit_information_category%TYPE;
435: ln_dummy NUMBER(15);
436: lv_datetrack_mode VARCHAR2(30);

Line 452: from pay_us_emp_fed_tax_rules_f ftr, per_assignments_f paf,

448: ftr.object_version_number,
449: ftr.effective_start_date,
450: paf.assignment_id,
451: hsck.segment1
452: from pay_us_emp_fed_tax_rules_f ftr, per_assignments_f paf,
453: hr_soft_coding_keyflex hsck
454: where paf.person_id = p_person_id
455: and paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
456: and paf.assignment_id = ftr.assignment_id

Line 854: from pay_us_emp_fed_tax_rules_f prtf,

850: l_proc VARCHAR2(80) := g_package || 'chk_w4_allowed';
851:
852: CURSOR c_tax_defaulting IS
853: select 'x'
854: from pay_us_emp_fed_tax_rules_f prtf,
855: per_assignments_f paf
856: where paf.person_id = p_person_id
857: and decode(l_primary_only,'Y',paf.primary_flag,'Y') = 'Y'
858: and prtf.assignment_id = paf.assignment_id

Line 877: pay_us_emp_fed_tax_rules_f ftr

873:
874: CURSOR c_excess_over_fed IS
875: select 'x'
876: from per_assignments_f paf,
877: pay_us_emp_fed_tax_rules_f ftr
878: where paf.person_id = p_person_id
879: and ftr.assignment_id = paf.assignment_id
880: and paf.assignment_type = 'E'
881: and decode(l_primary_only,'Y',paf.primary_flag,'Y') = 'Y'

Line 928: pay_us_emp_fed_tax_rules_f ftr

924:
925: CURSOR c_future_fed_recs IS
926: select 'x'
927: from per_assignments_f paf,
928: pay_us_emp_fed_tax_rules_f ftr
929: where paf.person_id = p_person_id
930: and paf.assignment_type = 'E'
931: and ftr.assignment_id = paf.assignment_id
932: and decode(l_primary_only,'Y',paf.primary_flag,'Y') = 'Y'