APPS.PAY_EOSY_AC_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 46: leg_param pay_payroll_actions.legislative_parameters%type;

42: --------------------------- range_cursor ---------------------------------
43: PROCEDURE range_cursor (pactid in number,
44: sqlstr out nocopy varchar2) is
45: l_payroll_id number;
46: leg_param pay_payroll_actions.legislative_parameters%type;
47: l_package varchar2(70);
48:
49: Begin
50:

Line 57: from pay_payroll_actions ppa, -- pyugen

53: hr_utility.set_location('Entering.. ' || l_package,10);
54:
55: sqlstr:=
56: 'select distinct paf.person_id
57: from pay_payroll_actions ppa, -- pyugen
58: per_gen_hierarchy_nodes pghn,
59: per_assignments_f paf,
60: per_assignment_status_types past,
61: per_jobs pj,

Line 135: pay_payroll_actions ppa,

131: paf.person_id,
132: paa.tax_unit_id,
133: paf.location_id
134: FROM pay_assignment_actions paa,
135: pay_payroll_actions ppa,
136: per_assignments_f paf,
137: per_jobs pj,
138: per_gen_hierarchy_nodes pghn,
139: -- per_assignment_status_types past, -- BUG3886008

Line 150: pay_payroll_actions ppa2,

146: AND paa.action_status = 'C'
147: AND paa.action_sequence IN (
148: SELECT MAX(paa2.action_sequence)
149: FROM pay_action_classifications pac,
150: pay_payroll_actions ppa2,
151: pay_assignment_actions paa2,
152: per_assignments_f paf1
153: WHERE paf1.person_id = paf.person_id
154: AND paa2.assignment_id = paf1.assignment_id

Line 216: FROM pay_payroll_actions

212: SELECT start_date,
213: effective_date,
214: pay_eosy_ac_pkg.get_parameter('HI_VER_ID',legislative_parameters),
215: pay_eosy_ac_pkg.get_parameter('EST_ID',legislative_parameters)
216: FROM pay_payroll_actions
217: WHERE payroll_action_id=pactid;
218:
219: lockingactid number;
220: lockedactid number;

Line 327: token_val pay_payroll_actions.legislative_parameters%type;

323: RETURN VARCHAR2
324: IS
325: start_ptr number;
326: end_ptr number;
327: token_val pay_payroll_actions.legislative_parameters%type;
328: par_value pay_payroll_actions.legislative_parameters%type;
329: BEGIN
330:
331: token_val := name || '=';

Line 328: par_value pay_payroll_actions.legislative_parameters%type;

324: IS
325: start_ptr number;
326: end_ptr number;
327: token_val pay_payroll_actions.legislative_parameters%type;
328: par_value pay_payroll_actions.legislative_parameters%type;
329: BEGIN
330:
331: token_val := name || '=';
332: