APPS.PAY_US_SOE_BALANCES_PKG dependencies on PAY_US_STATE_TAXES_V

Line 1665: l_juris_code pay_us_state_taxes_v.jurisdiction_code%type;

1661: p_dedn_tab out nocopy dedn)
1662: IS
1663:
1664: -- Declare Local Variables
1665: l_juris_code pay_us_state_taxes_v.jurisdiction_code%type;
1666:
1667: l_count number;
1668: l_run_amount number;
1669: l_curr_amount number;

Line 1671: l_tax_type pay_us_state_taxes_v.tax_type_code%type;

1667: l_count number;
1668: l_run_amount number;
1669: l_curr_amount number;
1670: l_ytd_amount number;
1671: l_tax_type pay_us_state_taxes_v.tax_type_code%type;
1672:
1673: start_cnt number;
1674: end_cnt number;
1675: i number := 0;

Line 1683: l_state_abbrev pay_us_state_taxes_v.state_abbrev%type;

1679: l_pos number;
1680:
1681: l_ytd_value number;
1682: l_master_action_id number;
1683: l_state_abbrev pay_us_state_taxes_v.state_abbrev%type;
1684:
1685: l_rep_name pay_us_state_taxes_v.user_reporting_name%TYPE;
1686: l_run_val number;
1687: l_ytd_val number;

Line 1685: l_rep_name pay_us_state_taxes_v.user_reporting_name%TYPE;

1681: l_ytd_value number;
1682: l_master_action_id number;
1683: l_state_abbrev pay_us_state_taxes_v.state_abbrev%type;
1684:
1685: l_rep_name pay_us_state_taxes_v.user_reporting_name%TYPE;
1686: l_run_val number;
1687: l_ytd_val number;
1688: l_procedure varchar2(22);
1689:

Line 1703: from pay_us_state_taxes_v

1699: run_val,
1700: tax_type_code,
1701: jurisdiction_code,
1702: ytd_val
1703: from pay_us_state_taxes_v
1704: where ee_or_er_code = 'EE'
1705: and assignment_action_id = l_assignment_action_id
1706: order by user_reporting_name;
1707:

Line 1715: from pay_us_state_taxes_v pt

1711: select state_abbrev,
1712: user_reporting_name,
1713: sum(run_val),
1714: tax_type_code
1715: from pay_us_state_taxes_v pt
1716: where pt.ee_or_er_code = 'EE'
1717: and pt.assignment_action_id = cp_run_action_id
1718: group by user_reporting_name, state_abbrev,tax_type_code
1719: order by user_reporting_name;

Line 1728: from pay_us_state_taxes_v pt

1724: select sum(pt.ytd_val),
1725: user_reporting_name,
1726: tax_type_code,
1727: state_abbrev
1728: from pay_us_state_taxes_v pt
1729: where pt.ee_or_er_code = 'EE'
1730: and pt.assignment_action_id = cp_master_action_id
1731: group by user_reporting_name, state_abbrev,tax_type_code
1732: order by user_reporting_name;

Line 1791: PROCEDURE get_position_state (p_rep_name in pay_us_state_taxes_v.user_reporting_name%TYPE ,

1787: -- Procedure to get the position of the state deductions in the plsql table
1788: -- If the element exists it will return the position otherwise will return
1789: -- new index where new element will be stored. The reporting name with the
1790: -- same state name are grouped to get the final deduction value.
1791: PROCEDURE get_position_state (p_rep_name in pay_us_state_taxes_v.user_reporting_name%TYPE ,
1792: p_tax_type_code in pay_us_state_taxes_v.user_reporting_name%TYPE ,
1793: p_state_abbrev in pay_us_state_taxes_v.state_abbrev%type,
1794: p_found out nocopy boolean,
1795: p_index out nocopy number)

Line 1792: p_tax_type_code in pay_us_state_taxes_v.user_reporting_name%TYPE ,

1788: -- If the element exists it will return the position otherwise will return
1789: -- new index where new element will be stored. The reporting name with the
1790: -- same state name are grouped to get the final deduction value.
1791: PROCEDURE get_position_state (p_rep_name in pay_us_state_taxes_v.user_reporting_name%TYPE ,
1792: p_tax_type_code in pay_us_state_taxes_v.user_reporting_name%TYPE ,
1793: p_state_abbrev in pay_us_state_taxes_v.state_abbrev%type,
1794: p_found out nocopy boolean,
1795: p_index out nocopy number)
1796: IS

Line 1793: p_state_abbrev in pay_us_state_taxes_v.state_abbrev%type,

1789: -- new index where new element will be stored. The reporting name with the
1790: -- same state name are grouped to get the final deduction value.
1791: PROCEDURE get_position_state (p_rep_name in pay_us_state_taxes_v.user_reporting_name%TYPE ,
1792: p_tax_type_code in pay_us_state_taxes_v.user_reporting_name%TYPE ,
1793: p_state_abbrev in pay_us_state_taxes_v.state_abbrev%type,
1794: p_found out nocopy boolean,
1795: p_index out nocopy number)
1796: IS
1797:

Line 2140: l_juris_code pay_us_state_taxes_v.jurisdiction_code%type;

2136:
2137: l_school_code pay_us_school_dsts.school_dst_code%type;
2138: l_school_name pay_us_school_dsts.school_dst_name%type;
2139: l_school_jd pay_us_local_taxes_v.jurisdiction_code%type;
2140: l_juris_code pay_us_state_taxes_v.jurisdiction_code%type;
2141:
2142: l_count number;
2143: l_run_amount number;
2144: l_curr_amount number;