DBA Data[Home] [Help]

APPS.PAY_US_OVER_LIMIT_TAX_RPT_PKG dependencies on PAY_US_EMP_STATE_TAX_RULES_F

Line 755: pay_us_emp_state_tax_rules_f pest,

751: pus.state_abbrev,
752: pest.state_code,
753: pest.jurisdiction_code
754: from
755: pay_us_emp_state_tax_rules_f pest,
756: pay_us_states pus
757: where
758: pest.assignment_id = p_asg_id
759: and p_as_of_date between pest.effective_start_date

Line 773: l_jurisdiction_code pay_us_emp_state_tax_rules_f.jurisdiction_code%type;

769: l_state_tax_type varchar2(240);
770: l_state_tax_limit number;
771: l_state_taxable_value number;
772:
773: l_jurisdiction_code pay_us_emp_state_tax_rules_f.jurisdiction_code%type;
774:
775: -- #2938556
776: l_assignment_number per_assignments_f.assignment_number%type;
777: l_person_id per_assignments_f.person_id%type;