APPS.PAY_US_DEPOSIT_ADVICE_PKG dependencies on PAY_US_PAYROLL_UTILS

Line 47: pay_us_payroll_utils.get_parameter instead.

43: function check_if_assignment_paid.
44: 3.Changed query for range_cursor for better
45: performance.
46: 4.Removed function get_parameter and used function
47: pay_us_payroll_utils.get_parameter instead.
48: 5.Added function get_payroll_action which returns
49: payroll_action data.
50: 04-AUG-2004 schauhan 115.3 3512116 Added assignment_set_id in the return list of
51: procedure get_payroll_action.

Line 68: pay_us_payroll_utils.get_parameter()

64: 06-JUN-2005 rsethupa 115.11 4406538 Changed cursor c_paid_actions in
65: archive_action_creation procedure to use the
66: exact names TRANSFER_CONSOLIDATION_SET_ID and
67: TRANSFER_PAYROLL_ID while calling
68: pay_us_payroll_utils.get_parameter()
69: 29-Sep-2005 sackumar 115.12 4631914 Modified the payroll_id join condition in c_paid_actions
70: query in action_creation procedure
71: 06-Oct-2005 sackumar 115.13 4636646 Modified the c_paid_actions cursor query in
72: action_creation procedure for Zero Pay assignment.

Line 142: ln_assignment_set_id := pay_us_payroll_utils.get_parameter(

138: ld_deposit_start_date,
139: ld_deposit_end_date;
140: close c_get_payroll_action;
141:
142: ln_assignment_set_id := pay_us_payroll_utils.get_parameter(
143: 'ASG_SET_ID',
144: lv_legislative_parameters);
145: ln_payroll_id := pay_us_payroll_utils.get_parameter(
146: 'PAYROLL_ID',

Line 145: ln_payroll_id := pay_us_payroll_utils.get_parameter(

141:
142: ln_assignment_set_id := pay_us_payroll_utils.get_parameter(
143: 'ASG_SET_ID',
144: lv_legislative_parameters);
145: ln_payroll_id := pay_us_payroll_utils.get_parameter(
146: 'PAYROLL_ID',
147: lv_legislative_parameters);
148: ln_consolidation_set_id := pay_us_payroll_utils.get_parameter(
149: 'CONSOLIDATION_SET_ID',

Line 148: ln_consolidation_set_id := pay_us_payroll_utils.get_parameter(

144: lv_legislative_parameters);
145: ln_payroll_id := pay_us_payroll_utils.get_parameter(
146: 'PAYROLL_ID',
147: lv_legislative_parameters);
148: ln_consolidation_set_id := pay_us_payroll_utils.get_parameter(
149: 'CONSOLIDATION_SET_ID',
150: lv_legislative_parameters);
151:
152: p_deposit_start_date := ld_deposit_start_date;

Line 202: ln_assignment_set_id := pay_us_payroll_utils.get_parameter(

198: hr_utility.trace('ld_deposit_end_date := ' || TO_CHAR(ld_deposit_end_date));
199:
200: close c_get_payroll_action;
201:
202: ln_assignment_set_id := pay_us_payroll_utils.get_parameter(
203: 'ASSIGNMENT_SET_ID',
204: lv_legislative_parameters);
205: ln_payroll_id := pay_us_payroll_utils.get_parameter(
206: 'PAYROLL_ID',

Line 205: ln_payroll_id := pay_us_payroll_utils.get_parameter(

201:
202: ln_assignment_set_id := pay_us_payroll_utils.get_parameter(
203: 'ASSIGNMENT_SET_ID',
204: lv_legislative_parameters);
205: ln_payroll_id := pay_us_payroll_utils.get_parameter(
206: 'PAYROLL_ID',
207: lv_legislative_parameters);
208: ln_consolidation_set_id := pay_us_payroll_utils.get_parameter(
209: 'CONSOLIDATION_SET_ID',

Line 208: ln_consolidation_set_id := pay_us_payroll_utils.get_parameter(

204: lv_legislative_parameters);
205: ln_payroll_id := pay_us_payroll_utils.get_parameter(
206: 'PAYROLL_ID',
207: lv_legislative_parameters);
208: ln_consolidation_set_id := pay_us_payroll_utils.get_parameter(
209: 'CONSOLIDATION_SET_ID',
210: lv_legislative_parameters);
211:
212: hr_utility.trace('ln_assignment_set_id := ' || ln_assignment_set_id);

Line 526: and pay_us_payroll_utils.get_parameter('TRANSFER_CONSOLIDATION_SET_ID',

522: /* Bug : 7558310
523: and cp_deposit_end_date between ppa_xfr.start_date
524: and ppa_xfr.effective_date */
525: and ppa_xfr.effective_date between cp_deposit_start_date and cp_deposit_end_date
526: and pay_us_payroll_utils.get_parameter('TRANSFER_CONSOLIDATION_SET_ID',
527: ppa_xfr.legislative_parameters)
528: = cp_consolidation_set_id
529: and paa_xfr.payroll_action_id = ppa_xfr.payroll_action_id
530: -- the statement below will make sure only Pre Payment Archive Actions are picked up

Line 535: pay_us_payroll_utils.get_parameter('TRANSFER_PAYROLL_ID',

531: and substr(paa_xfr.serial_number,1,1) not in ('V', 'B')
532: and pai_pre.locking_Action_id = paa_xfr.assignment_action_id
533: and (cp_payroll_id is null
534: or
535: pay_us_payroll_utils.get_parameter('TRANSFER_PAYROLL_ID',
536: ppa_xfr.legislative_parameters)
537: = cp_payroll_id
538: )
539: and paa_xfr.assignment_id between cp_start_person and cp_end_person