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_OVER_LIMIT_TAX_RPT_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 116: l_start_date pay_payroll_actions.start_date%type;

112: ***************************************************************************/
113: AS
114:
115: --------------------- GLOBAL variables ----------------------------------
116: l_start_date pay_payroll_actions.start_date%type;
117: l_end_date pay_payroll_actions.effective_date%type;
118: l_business_group_id pay_payroll_actions.business_group_id%type;
119: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
120: l_effective_date pay_payroll_actions.effective_date%type;

Line 117: l_end_date pay_payroll_actions.effective_date%type;

113: AS
114:
115: --------------------- GLOBAL variables ----------------------------------
116: l_start_date pay_payroll_actions.start_date%type;
117: l_end_date pay_payroll_actions.effective_date%type;
118: l_business_group_id pay_payroll_actions.business_group_id%type;
119: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
120: l_effective_date pay_payroll_actions.effective_date%type;
121: l_action_type pay_payroll_actions.action_type%type;

Line 118: l_business_group_id pay_payroll_actions.business_group_id%type;

114:
115: --------------------- GLOBAL variables ----------------------------------
116: l_start_date pay_payroll_actions.start_date%type;
117: l_end_date pay_payroll_actions.effective_date%type;
118: l_business_group_id pay_payroll_actions.business_group_id%type;
119: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
120: l_effective_date pay_payroll_actions.effective_date%type;
121: l_action_type pay_payroll_actions.action_type%type;
122: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

Line 119: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;

115: --------------------- GLOBAL variables ----------------------------------
116: l_start_date pay_payroll_actions.start_date%type;
117: l_end_date pay_payroll_actions.effective_date%type;
118: l_business_group_id pay_payroll_actions.business_group_id%type;
119: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
120: l_effective_date pay_payroll_actions.effective_date%type;
121: l_action_type pay_payroll_actions.action_type%type;
122: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
123: l_assignment_id pay_assignment_actions.assignment_id%type;

Line 120: l_effective_date pay_payroll_actions.effective_date%type;

116: l_start_date pay_payroll_actions.start_date%type;
117: l_end_date pay_payroll_actions.effective_date%type;
118: l_business_group_id pay_payroll_actions.business_group_id%type;
119: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
120: l_effective_date pay_payroll_actions.effective_date%type;
121: l_action_type pay_payroll_actions.action_type%type;
122: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
123: l_assignment_id pay_assignment_actions.assignment_id%type;
124: l_tax_unit_id hr_organization_units.organization_id%type;

Line 121: l_action_type pay_payroll_actions.action_type%type;

117: l_end_date pay_payroll_actions.effective_date%type;
118: l_business_group_id pay_payroll_actions.business_group_id%type;
119: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
120: l_effective_date pay_payroll_actions.effective_date%type;
121: l_action_type pay_payroll_actions.action_type%type;
122: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
123: l_assignment_id pay_assignment_actions.assignment_id%type;
124: l_tax_unit_id hr_organization_units.organization_id%type;
125: l_gre_name hr_organization_units.name%type;

Line 130: l_leg_param pay_payroll_actions.legislative_parameters%type;--Bug3015312

126: l_organization_id hr_organization_units.organization_id%type;
127: l_org_name hr_organization_units.name%type;
128: l_location_id hr_locations.location_id%type;
129: l_location_code hr_locations.location_code%type;
130: l_leg_param pay_payroll_actions.legislative_parameters%type;--Bug3015312
131: l_leg_start_date date;
132: l_leg_end_date date;
133: t_gre_id number(15);
134: t_payroll_action_id pay_payroll_actions.payroll_action_id%type; --:PACTID

Line 134: t_payroll_action_id pay_payroll_actions.payroll_action_id%type; --:PACTID

130: l_leg_param pay_payroll_actions.legislative_parameters%type;--Bug3015312
131: l_leg_start_date date;
132: l_leg_end_date date;
133: t_gre_id number(15);
134: t_payroll_action_id pay_payroll_actions.payroll_action_id%type; --:PACTID
135: l_row_count number :=0;
136: l_tax_type varchar2(240);
137: l_tax_group hr_organization_information.org_information5%type;
138: l_date_prm varchar2(20);

Line 1441: pay_payroll_actions ppa_arch -- PYUGEN

1437: hr_all_organization_units hou1,
1438: hr_all_organization_units hou,
1439: per_assignments_f paf,
1440: pay_assignment_actions paa, -- PYUGEN
1441: pay_payroll_actions ppa_arch -- PYUGEN
1442: where
1443: -- ppa_arch.payroll_action_id = l_pactid
1444: paa.assignment_action_id = l_aaid
1445: and paa.payroll_action_id = ppa_arch.payroll_action_id

Line 1491: from pay_payroll_actions ppa

1487: l_date_prm,
1488: l_tax_type,
1489: l_ppa_finder,
1490: t_payroll_action_id
1491: from pay_payroll_actions ppa
1492: where ppa.payroll_action_id = pactid;
1493:
1494:
1495: /* the tax type returned is like SDI_EE whereas the value stored