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_PKG dependencies on PER_ASSIGNMENTS_F

Line 35: per_assignments_f table in the

31: 19-MAR-2001 meshah 115.6 2262842 Added business_group_id checking
32: in the range and actio_creation
33: cursor.
34: 2261018 Changed the date checking on the
35: per_assignments_f table in the
36: action_creation cursor.
37: 06-AUG-2002 rmonge 115.7 2447123 Changed action_type to varchar2(30)
38: 12-SEP-2002 irgonzal 115.8 2453584 Split action creation cursor in
39: several cursors to avoid reading

Line 130: per_assignments_f paf

126: distinct paf.person_id
127: from
128: pay_payroll_actions ppa,
129: pay_assignment_actions paa,
130: per_assignments_f paf
131: where :payroll_action_id is not null
132: and paa.payroll_action_id = ppa.payroll_action_id
133: and paa.action_status=''C''
134: and ppa.action_type in (''B'', ''I'', ''R'', ''Q'', ''V'')

Line 159: l_org_id per_assignments_f.organization_id%type;

155: action_type varchar2(30);
156: l_as_of_date varchar2(240);
157: -- l_date_prm varchar2(50);
158: l_gre_id pay_assignment_actions.tax_unit_id%type;
159: l_org_id per_assignments_f.organization_id%type;
160: l_loc_id per_assignments_f.location_id%type;
161: l_bg_id per_assignments_f.business_group_id%type;
162: l_tax_type varchar2(100);
163:

Line 160: l_loc_id per_assignments_f.location_id%type;

156: l_as_of_date varchar2(240);
157: -- l_date_prm varchar2(50);
158: l_gre_id pay_assignment_actions.tax_unit_id%type;
159: l_org_id per_assignments_f.organization_id%type;
160: l_loc_id per_assignments_f.location_id%type;
161: l_bg_id per_assignments_f.business_group_id%type;
162: l_tax_type varchar2(100);
163:
164: l_per_id per_assignments_f.person_id%type;

Line 161: l_bg_id per_assignments_f.business_group_id%type;

157: -- l_date_prm varchar2(50);
158: l_gre_id pay_assignment_actions.tax_unit_id%type;
159: l_org_id per_assignments_f.organization_id%type;
160: l_loc_id per_assignments_f.location_id%type;
161: l_bg_id per_assignments_f.business_group_id%type;
162: l_tax_type varchar2(100);
163:
164: l_per_id per_assignments_f.person_id%type;
165: l_ssn per_people_f.national_identifier%type;

Line 164: l_per_id per_assignments_f.person_id%type;

160: l_loc_id per_assignments_f.location_id%type;
161: l_bg_id per_assignments_f.business_group_id%type;
162: l_tax_type varchar2(100);
163:
164: l_per_id per_assignments_f.person_id%type;
165: l_ssn per_people_f.national_identifier%type;
166: l_state_code pay_us_states.state_code%type;
167: l_state_abbrev pay_us_states.state_abbrev%type;
168:

Line 350: from per_assignments_f paf,

346:
347: lv_sqlstr := 'select distinct paf.person_id person_id,
348: paf.assignment_id,
349: paa.tax_unit_id
350: from per_assignments_f paf,
351: pay_assignment_actions paa,
352: pay_payroll_actions ppa,
353: PAY_POPULATION_RANGES ppr
354: where ppr.payroll_action_id = '|| pactid ||'

Line 397: from per_assignments_f paf,

393: index(paf PER_ASSIGNMENTS_N12) */
394: distinct paf.person_id person_id,
395: paf.assignment_id,
396: paa.tax_unit_id
397: from per_assignments_f paf,
398: pay_assignment_actions paa,
399: pay_payroll_actions ppa
400: where paf.person_id between '|| stperson ||' and '|| endperson ||'
401: and paf.assignment_type = ''E''