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_PSD_XML dependencies on PAY_US_STATES

Line 370: l_state_code pay_us_states.state_code%type;

366: p_period_start IN OUT NOCOPY DATE,
367: p_period_end IN OUT NOCOPY DATE,
368: p_tax_coll_dist_code IN OUT NOCOPY VARCHAR2
369: ) IS
370: l_state_code pay_us_states.state_code%type;
371: l_period_start varchar2(200);
372: l_period_end varchar2(200);
373: BEGIN
374: hr_utility.set_location('pay_us_psd_xml.get_report_parameters', 10);

Line 399: from pay_us_states pus

395: FROM pay_payroll_actions ppa
396: WHERE ppa.payroll_action_id = p_pactid;
397: --
398: select state_code into l_state_code
399: from pay_us_states pus
400: where pus.state_abbrev = p_state_abbrev;
401:
402: p_state_code := l_state_code;
403: /* SELECT fnd_date.canonical_to_date(pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,

Line 1172: l_state_abbrev pay_us_states.state_abbrev%type;

1168: IS
1169: l_year_start DATE;
1170: l_year_end DATE;
1171: l_business_group_id NUMBER;
1172: l_state_abbrev pay_us_states.state_abbrev%type;
1173: l_state_code pay_us_states.state_code%type;
1174: l_report_type VARCHAR2(200);
1175: l_period_type VARCHAR2(200);
1176: l_period_start DATE;

Line 1173: l_state_code pay_us_states.state_code%type;

1169: l_year_start DATE;
1170: l_year_end DATE;
1171: l_business_group_id NUMBER;
1172: l_state_abbrev pay_us_states.state_abbrev%type;
1173: l_state_code pay_us_states.state_code%type;
1174: l_report_type VARCHAR2(200);
1175: l_period_type VARCHAR2(200);
1176: l_period_start DATE;
1177: l_period_end DATE;

Line 1551: l_state_abbrev pay_us_states.state_abbrev%type;

1547:
1548:
1549: l_year_start DATE;
1550: l_year_end DATE;
1551: l_state_abbrev pay_us_states.state_abbrev%type;
1552: l_state_code pay_us_states.state_code%type;
1553: l_report_type VARCHAR2(30);
1554: l_period_type VARCHAR2(200);
1555: l_range_person BOOLEAN;

Line 1552: l_state_code pay_us_states.state_code%type;

1548:
1549: l_year_start DATE;
1550: l_year_end DATE;
1551: l_state_abbrev pay_us_states.state_abbrev%type;
1552: l_state_code pay_us_states.state_code%type;
1553: l_report_type VARCHAR2(30);
1554: l_period_type VARCHAR2(200);
1555: l_range_person BOOLEAN;
1556: -- l_transfer_gre_id number;

Line 2160: l_state_abbrev pay_us_states.state_abbrev%type;

2156:
2157: l_year_start DATE;
2158: l_year_end DATE;
2159: l_business_group_id NUMBER;
2160: l_state_abbrev pay_us_states.state_abbrev%type;
2161: l_state_code pay_us_states.state_code%type;
2162: l_report_type VARCHAR2(200);
2163: l_period_type VARCHAR2(200);
2164: l_period_start DATE;

Line 2161: l_state_code pay_us_states.state_code%type;

2157: l_year_start DATE;
2158: l_year_end DATE;
2159: l_business_group_id NUMBER;
2160: l_state_abbrev pay_us_states.state_abbrev%type;
2161: l_state_code pay_us_states.state_code%type;
2162: l_report_type VARCHAR2(200);
2163: l_period_type VARCHAR2(200);
2164: l_period_start DATE;
2165: l_period_end DATE;

Line 2174: from pay_us_states

2170: /* get the state code for the 'PA' */
2171:
2172: select state_code
2173: into l_state_code
2174: from pay_us_states
2175: where state_abbrev =
2176: (select pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,
2177: 'TRANSFER_STATE')
2178: from pay_payroll_actions ppa

Line 2454: pay_us_states pus,

2450: into l_value1,
2451: l_value2,
2452: l_value3
2453: from pay_state_rules rules,
2454: pay_us_states pus,
2455: hr_organization_information target
2456: where substr(rules.jurisdiction_code, 1, 2) =l_state_code
2457: and target.organization_id = p_tax_unit_id
2458: and target.org_information_context || '' = 'State Tax Rules'

Line 2594: l_state_abbrev pay_us_states.state_abbrev%type;

2590:
2591: l_year_start DATE;
2592: l_year_end DATE;
2593: l_business_group_id NUMBER;
2594: l_state_abbrev pay_us_states.state_abbrev%type;
2595: l_state_code pay_us_states.state_code%type;
2596: l_report_type VARCHAR2(200);
2597: l_period_type VARCHAR2(200);
2598: l_period_start DATE;

Line 2595: l_state_code pay_us_states.state_code%type;

2591: l_year_start DATE;
2592: l_year_end DATE;
2593: l_business_group_id NUMBER;
2594: l_state_abbrev pay_us_states.state_abbrev%type;
2595: l_state_code pay_us_states.state_code%type;
2596: l_report_type VARCHAR2(200);
2597: l_period_type VARCHAR2(200);
2598: l_period_start DATE;
2599: l_period_end DATE;

Line 2784: l_state_abbrev pay_us_states.state_abbrev%type;

2780:
2781: l_year_start DATE;
2782: l_year_end DATE;
2783: l_business_group_id NUMBER;
2784: l_state_abbrev pay_us_states.state_abbrev%type;
2785: l_state_code pay_us_states.state_code%type;
2786: l_report_type VARCHAR2(200);
2787: l_period_type VARCHAR2(200);
2788: l_period_start DATE;

Line 2785: l_state_code pay_us_states.state_code%type;

2781: l_year_start DATE;
2782: l_year_end DATE;
2783: l_business_group_id NUMBER;
2784: l_state_abbrev pay_us_states.state_abbrev%type;
2785: l_state_code pay_us_states.state_code%type;
2786: l_report_type VARCHAR2(200);
2787: l_period_type VARCHAR2(200);
2788: l_period_start DATE;
2789: l_period_end DATE;