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 PAY_US_PAYROLL_UTILS

Line 60: call to pay_us_payroll_utils.get_parameter call.

56: use of bind Variable (:payroll_action_id)
57: 07-DEC-2005 sackumar 115.17 4748245 Changed the Range Cursor and Action_creation procedure
58: to improve the performance.
59: Also replaced the pay_us_over_limit_pkg.get_parameter
60: call to pay_us_payroll_utils.get_parameter call.
61: 18-APR-2007 sudedas 115.18 5840569 In case Range Person ID Functionality
62: is disabled where conditions need to
63: be added to action_creation procedure.
64: 29-OCT-2007 vaisriva 115.19 5717518 Cursor c_get_latest_asg has been modified to improve

Line 89: pay_us_payroll_utils.get_parameter('GRE',ppa.legislative_parameters),

85:
86: begin
87: select ppa.legislative_parameters,
88: ppa.business_group_id,
89: pay_us_payroll_utils.get_parameter('GRE',ppa.legislative_parameters),
90: pay_us_payroll_utils.get_parameter('ORG',ppa.legislative_parameters),
91: pay_us_payroll_utils.get_parameter('LOC',ppa.legislative_parameters),
92: pay_us_payroll_utils.get_parameter('AS_OF_DATE',ppa.legislative_parameters)
93: into leg_param,

Line 90: pay_us_payroll_utils.get_parameter('ORG',ppa.legislative_parameters),

86: begin
87: select ppa.legislative_parameters,
88: ppa.business_group_id,
89: pay_us_payroll_utils.get_parameter('GRE',ppa.legislative_parameters),
90: pay_us_payroll_utils.get_parameter('ORG',ppa.legislative_parameters),
91: pay_us_payroll_utils.get_parameter('LOC',ppa.legislative_parameters),
92: pay_us_payroll_utils.get_parameter('AS_OF_DATE',ppa.legislative_parameters)
93: into leg_param,
94: l_bg_id,

Line 91: pay_us_payroll_utils.get_parameter('LOC',ppa.legislative_parameters),

87: select ppa.legislative_parameters,
88: ppa.business_group_id,
89: pay_us_payroll_utils.get_parameter('GRE',ppa.legislative_parameters),
90: pay_us_payroll_utils.get_parameter('ORG',ppa.legislative_parameters),
91: pay_us_payroll_utils.get_parameter('LOC',ppa.legislative_parameters),
92: pay_us_payroll_utils.get_parameter('AS_OF_DATE',ppa.legislative_parameters)
93: into leg_param,
94: l_bg_id,
95: l_gre_id,

Line 92: pay_us_payroll_utils.get_parameter('AS_OF_DATE',ppa.legislative_parameters)

88: ppa.business_group_id,
89: pay_us_payroll_utils.get_parameter('GRE',ppa.legislative_parameters),
90: pay_us_payroll_utils.get_parameter('ORG',ppa.legislative_parameters),
91: pay_us_payroll_utils.get_parameter('LOC',ppa.legislative_parameters),
92: pay_us_payroll_utils.get_parameter('AS_OF_DATE',ppa.legislative_parameters)
93: into leg_param,
94: l_bg_id,
95: l_gre_id,
96: l_org_id,

Line 188: pay_us_payroll_utils.get_parameter('GRE',ppa.legislative_parameters),

184: cursor c_parameters ( pactid number) is
185: select
186: ppa.legislative_parameters,
187: ppa.business_group_id,
188: pay_us_payroll_utils.get_parameter('GRE',ppa.legislative_parameters),
189: pay_us_payroll_utils.get_parameter('ORG',ppa.legislative_parameters),
190: pay_us_payroll_utils.get_parameter('LOC',ppa.legislative_parameters),
191: pay_us_payroll_utils.get_parameter('AS_OF_DATE',ppa.legislative_parameters),
192: pay_us_payroll_utils.get_parameter('TAX_TYPE',ppa.legislative_parameters)

Line 189: pay_us_payroll_utils.get_parameter('ORG',ppa.legislative_parameters),

185: select
186: ppa.legislative_parameters,
187: ppa.business_group_id,
188: pay_us_payroll_utils.get_parameter('GRE',ppa.legislative_parameters),
189: pay_us_payroll_utils.get_parameter('ORG',ppa.legislative_parameters),
190: pay_us_payroll_utils.get_parameter('LOC',ppa.legislative_parameters),
191: pay_us_payroll_utils.get_parameter('AS_OF_DATE',ppa.legislative_parameters),
192: pay_us_payroll_utils.get_parameter('TAX_TYPE',ppa.legislative_parameters)
193: from pay_payroll_actions ppa

Line 190: pay_us_payroll_utils.get_parameter('LOC',ppa.legislative_parameters),

186: ppa.legislative_parameters,
187: ppa.business_group_id,
188: pay_us_payroll_utils.get_parameter('GRE',ppa.legislative_parameters),
189: pay_us_payroll_utils.get_parameter('ORG',ppa.legislative_parameters),
190: pay_us_payroll_utils.get_parameter('LOC',ppa.legislative_parameters),
191: pay_us_payroll_utils.get_parameter('AS_OF_DATE',ppa.legislative_parameters),
192: pay_us_payroll_utils.get_parameter('TAX_TYPE',ppa.legislative_parameters)
193: from pay_payroll_actions ppa
194: where ppa.payroll_action_id = pactid;

Line 191: pay_us_payroll_utils.get_parameter('AS_OF_DATE',ppa.legislative_parameters),

187: ppa.business_group_id,
188: pay_us_payroll_utils.get_parameter('GRE',ppa.legislative_parameters),
189: pay_us_payroll_utils.get_parameter('ORG',ppa.legislative_parameters),
190: pay_us_payroll_utils.get_parameter('LOC',ppa.legislative_parameters),
191: pay_us_payroll_utils.get_parameter('AS_OF_DATE',ppa.legislative_parameters),
192: pay_us_payroll_utils.get_parameter('TAX_TYPE',ppa.legislative_parameters)
193: from pay_payroll_actions ppa
194: where ppa.payroll_action_id = pactid;
195:

Line 192: pay_us_payroll_utils.get_parameter('TAX_TYPE',ppa.legislative_parameters)

188: pay_us_payroll_utils.get_parameter('GRE',ppa.legislative_parameters),
189: pay_us_payroll_utils.get_parameter('ORG',ppa.legislative_parameters),
190: pay_us_payroll_utils.get_parameter('LOC',ppa.legislative_parameters),
191: pay_us_payroll_utils.get_parameter('AS_OF_DATE',ppa.legislative_parameters),
192: pay_us_payroll_utils.get_parameter('TAX_TYPE',ppa.legislative_parameters)
193: from pay_payroll_actions ppa
194: where ppa.payroll_action_id = pactid;
195:
196: l_prev_person_id per_people_f.person_id%type;

Line 462: pay_us_payroll_utils.get_parameter('SORT1',ppa.legislative_parameters),

458:
459: cursor c_parameters ( pactid number) is
460: select
461: ppa.legislative_parameters,
462: pay_us_payroll_utils.get_parameter('SORT1',ppa.legislative_parameters),
463: pay_us_payroll_utils.get_parameter('SORT2',ppa.legislative_parameters),
464: pay_us_payroll_utils.get_parameter('SORT3',ppa.legislative_parameters)
465: from pay_payroll_actions ppa
466: where ppa.payroll_action_id = pactid;

Line 463: pay_us_payroll_utils.get_parameter('SORT2',ppa.legislative_parameters),

459: cursor c_parameters ( pactid number) is
460: select
461: ppa.legislative_parameters,
462: pay_us_payroll_utils.get_parameter('SORT1',ppa.legislative_parameters),
463: pay_us_payroll_utils.get_parameter('SORT2',ppa.legislative_parameters),
464: pay_us_payroll_utils.get_parameter('SORT3',ppa.legislative_parameters)
465: from pay_payroll_actions ppa
466: where ppa.payroll_action_id = pactid;
467: --

Line 464: pay_us_payroll_utils.get_parameter('SORT3',ppa.legislative_parameters)

460: select
461: ppa.legislative_parameters,
462: pay_us_payroll_utils.get_parameter('SORT1',ppa.legislative_parameters),
463: pay_us_payroll_utils.get_parameter('SORT2',ppa.legislative_parameters),
464: pay_us_payroll_utils.get_parameter('SORT3',ppa.legislative_parameters)
465: from pay_payroll_actions ppa
466: where ppa.payroll_action_id = pactid;
467: --
468: begin