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_SG_SOE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 68: (p_assignment_id in pay_assignment_actions.assignment_id%type,

64: -- Also handy as we only need to pass back the accrual value, not the
65: -- other OUT parameters.
66: ------------------------------------------------------------------------
67: function net_accrual
68: (p_assignment_id in pay_assignment_actions.assignment_id%type,
69: p_plan_id in pay_accrual_plans.accrual_plan_id%type,
70: p_payroll_id in pay_payroll_actions.payroll_id%type,
71: p_business_group_id in pay_accrual_plans.business_group_id%type,
72: p_effective_date in per_time_periods.end_date%type)

Line 104: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

100: the view pay_sg_soe_balances_v */
101:
102: procedure current_and_ytd_balances
103: (p_prepaid_tag in varchar,
104: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
105: p_balance_name in pay_balance_types.balance_name%type,
106: p_person_id in per_all_people_f.person_id%type,
107: p_current_balance out nocopy number,
108: p_ytd_balance out nocopy number)

Line 119: v_pp_assignment_action_id pay_assignment_actions.assignment_action_id%type;

115: v_pp_asg_le_ytd number;
116: v_pp_asg_le_run number;
117: v_pp_per_le_ytd number;
118: v_pp_payments number;
119: v_pp_assignment_action_id pay_assignment_actions.assignment_action_id%type;
120: v_cur_run_id pay_assignment_actions.assignment_action_id%type;
121: l_RUN_ASSIGNMENT_ACTION_ID pay_assignment_actions.assignment_action_id%type;
122:
123: /* Bug 2824397 */

Line 120: v_cur_run_id pay_assignment_actions.assignment_action_id%type;

116: v_pp_asg_le_run number;
117: v_pp_per_le_ytd number;
118: v_pp_payments number;
119: v_pp_assignment_action_id pay_assignment_actions.assignment_action_id%type;
120: v_cur_run_id pay_assignment_actions.assignment_action_id%type;
121: l_RUN_ASSIGNMENT_ACTION_ID pay_assignment_actions.assignment_action_id%type;
122:
123: /* Bug 2824397 */
124:

Line 121: l_RUN_ASSIGNMENT_ACTION_ID pay_assignment_actions.assignment_action_id%type;

117: v_pp_per_le_ytd number;
118: v_pp_payments number;
119: v_pp_assignment_action_id pay_assignment_actions.assignment_action_id%type;
120: v_cur_run_id pay_assignment_actions.assignment_action_id%type;
121: l_RUN_ASSIGNMENT_ACTION_ID pay_assignment_actions.assignment_action_id%type;
122:
123: /* Bug 2824397 */
124:
125: v_assign_count number := 1;

Line 127: v_ass_act_id pay_assignment_actions.assignment_action_id%type;

123: /* Bug 2824397 */
124:
125: v_assign_count number := 1;
126: v_date_earned date;
127: v_ass_act_id pay_assignment_actions.assignment_action_id%type;
128: v_asg_le_value number;
129: v_counter number := 1;
130:
131: TYPE assign_tab is table of per_all_assignments_f.assignment_id%type

Line 143: (c_assignment_action_id pay_assignment_actions.assignment_action_id%type,

139: -- pay_balance_pkg.set_context('JURISDICTION_CODE');
140:
141: /* Bug:2883606. Cursor to get the balance values from pay_balance_pkg.get_value */
142: cursor balance_value
143: (c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
144: c_balance_name pay_balance_types.balance_name%type,
145: c_dimension_name pay_balance_dimensions.dimension_name%type) is
146: select nvl(pay_balance_pkg.get_value(pdb.defined_balance_id,c_assignment_action_id),0)
147: from pay_balance_dimensions pbd,

Line 158: (p_assignment_action_id pay_assignment_actions.assignment_action_id%type) is

154: and pbt.legislation_code = 'SG';
155:
156: /* Bug:2883606. Cursor to get all the locked actions locked by prepayments */
157: cursor run_ids
158: (p_assignment_action_id pay_assignment_actions.assignment_action_id%type) is
159: select LOCKED_ACTION_ID
160: from pay_action_interlocks
161: where LOCKING_ACTION_ID = p_assignment_action_id
162: order by locked_action_id asc;

Line 168: (c_assign_act_id pay_assignment_actions.assignment_action_id%type) is

164: /* Bug#2883606. Included check for costing(C) */
165: /* Bug 6978015, added ORDER BY to get locking assignment_action_id */
166: /* whatever Costing runs after prepayment or before */
167: cursor c_lock_id
168: (c_assign_act_id pay_assignment_actions.assignment_action_id%type) is
169: select pai.locking_action_id
170: from pay_action_interlocks pai,
171: pay_payroll_actions ppa,
172: pay_assignment_actions paa

Line 172: pay_assignment_actions paa

168: (c_assign_act_id pay_assignment_actions.assignment_action_id%type) is
169: select pai.locking_action_id
170: from pay_action_interlocks pai,
171: pay_payroll_actions ppa,
172: pay_assignment_actions paa
173: where pai.locked_action_id = c_assign_act_id
174: and paa.assignment_action_id=pai.locking_action_id
175: and ppa.payroll_action_id=paa.payroll_action_id
176: and ppa.action_type in ('P','U','C')

Line 191: (c_assignment_action_id pay_assignment_actions.assignment_action_id%type) is

187: and effective_start_date <= c_date_earned
188: and assignment_type = 'E';
189:
190: cursor c_date_earned
191: (c_assignment_action_id pay_assignment_actions.assignment_action_id%type) is
192: select ppa.effective_date /* Bug 4267365 */
193: from pay_payroll_actions ppa,
194: pay_assignment_actions pac
195: where pac.payroll_action_id = ppa.payroll_action_id

Line 194: pay_assignment_actions pac

190: cursor c_date_earned
191: (c_assignment_action_id pay_assignment_actions.assignment_action_id%type) is
192: select ppa.effective_date /* Bug 4267365 */
193: from pay_payroll_actions ppa,
194: pay_assignment_actions pac
195: where pac.payroll_action_id = ppa.payroll_action_id
196: and pac.assignment_action_id = c_assignment_action_id;
197:
198: cursor c_max_assign_action

Line 202: from pay_assignment_actions pac,

198: cursor c_max_assign_action
199: (c_assignment_id per_all_assignments_f.assignment_id%type,
200: c_date_earned pay_payroll_actions.date_earned%type ) is
201: select max(pac.assignment_action_id)
202: from pay_assignment_actions pac,
203: per_all_assignments_f paa,
204: pay_payroll_actions ppa
205: where paa.assignment_id = c_assignment_id
206: and paa.assignment_type = 'E'

Line 339: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

335: directly from pay_balance_pkg.get_value instead of retrieving it from
336: the view pay_sg_soe_balances_v */
337:
338: procedure current_and_ytd_balances
339: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
340: p_balance_name in pay_balance_types.balance_name%type,
341: p_person_id in per_all_people_f.person_id%type,
342: p_current_balance out nocopy number,
343: p_ytd_balance out nocopy number)

Line 354: v_pp_assignment_action_id pay_assignment_actions.assignment_action_id%type;

350: v_pp_asg_le_ytd number;
351: v_pp_asg_le_run number;
352: v_pp_per_le_ytd number;
353: v_pp_payments number;
354: v_pp_assignment_action_id pay_assignment_actions.assignment_action_id%type;
355: v_cur_run_id pay_assignment_actions.assignment_action_id%type;
356: l_RUN_ASSIGNMENT_ACTION_ID pay_assignment_actions.assignment_action_id%type;
357:
358: /* Bug 2824397 */

Line 355: v_cur_run_id pay_assignment_actions.assignment_action_id%type;

351: v_pp_asg_le_run number;
352: v_pp_per_le_ytd number;
353: v_pp_payments number;
354: v_pp_assignment_action_id pay_assignment_actions.assignment_action_id%type;
355: v_cur_run_id pay_assignment_actions.assignment_action_id%type;
356: l_RUN_ASSIGNMENT_ACTION_ID pay_assignment_actions.assignment_action_id%type;
357:
358: /* Bug 2824397 */
359:

Line 356: l_RUN_ASSIGNMENT_ACTION_ID pay_assignment_actions.assignment_action_id%type;

352: v_pp_per_le_ytd number;
353: v_pp_payments number;
354: v_pp_assignment_action_id pay_assignment_actions.assignment_action_id%type;
355: v_cur_run_id pay_assignment_actions.assignment_action_id%type;
356: l_RUN_ASSIGNMENT_ACTION_ID pay_assignment_actions.assignment_action_id%type;
357:
358: /* Bug 2824397 */
359:
360: v_assign_count number := 1;

Line 362: v_ass_act_id pay_assignment_actions.assignment_action_id%type;

358: /* Bug 2824397 */
359:
360: v_assign_count number := 1;
361: v_date_earned date;
362: v_ass_act_id pay_assignment_actions.assignment_action_id%type;
363: v_asg_le_value number;
364: v_counter number := 1;
365:
366: TYPE assign_tab is table of per_all_assignments_f.assignment_id%type

Line 377: (c_assignment_action_id pay_assignment_actions.assignment_action_id%type,

373: -- pay_balance_pkg.set_context('JURISDICTION_CODE');
374:
375: /* Bug:2883606. Cursor to get the balance values from pay_balance_pkg.get_value */
376: cursor balance_value
377: (c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
378: c_balance_name pay_balance_types.balance_name%type,
379: c_dimension_name pay_balance_dimensions.dimension_name%type) is
380: select nvl(pay_balance_pkg.get_value(pdb.defined_balance_id,c_assignment_action_id),0)
381: from pay_balance_dimensions pbd,

Line 392: (p_assignment_action_id pay_assignment_actions.assignment_action_id%type) is

388: and pbt.legislation_code = 'SG';
389:
390: /* Bug:2883606. Cursor to get all the locked actions locked by prepayments */
391: cursor run_ids
392: (p_assignment_action_id pay_assignment_actions.assignment_action_id%type) is
393: select LOCKED_ACTION_ID
394: from pay_action_interlocks
395: where LOCKING_ACTION_ID = p_assignment_action_id
396: order by locked_action_id asc;

Line 400: (c_assign_act_id pay_assignment_actions.assignment_action_id%type) is

396: order by locked_action_id asc;
397:
398: /* Bug#2883606. Included check for costing(C) */
399: cursor c_lock_id
400: (c_assign_act_id pay_assignment_actions.assignment_action_id%type) is
401: select pai.locking_action_id
402: from pay_action_interlocks pai,
403: pay_payroll_actions ppa,
404: pay_assignment_actions paa

Line 404: pay_assignment_actions paa

400: (c_assign_act_id pay_assignment_actions.assignment_action_id%type) is
401: select pai.locking_action_id
402: from pay_action_interlocks pai,
403: pay_payroll_actions ppa,
404: pay_assignment_actions paa
405: where pai.locked_action_id = c_assign_act_id
406: and paa.assignment_action_id=pai.locking_action_id
407: and ppa.payroll_action_id=paa.payroll_action_id
408: and ppa.action_type in ('P','U','C');

Line 422: (c_assignment_action_id pay_assignment_actions.assignment_action_id%type) is

418: and effective_start_date <= c_date_earned
419: and assignment_type = 'E';
420:
421: cursor c_date_earned
422: (c_assignment_action_id pay_assignment_actions.assignment_action_id%type) is
423: select ppa.effective_date /* Bug 4267365 */
424: from pay_payroll_actions ppa,
425: pay_assignment_actions pac
426: where pac.payroll_action_id = ppa.payroll_action_id

Line 425: pay_assignment_actions pac

421: cursor c_date_earned
422: (c_assignment_action_id pay_assignment_actions.assignment_action_id%type) is
423: select ppa.effective_date /* Bug 4267365 */
424: from pay_payroll_actions ppa,
425: pay_assignment_actions pac
426: where pac.payroll_action_id = ppa.payroll_action_id
427: and pac.assignment_action_id = c_assignment_action_id;
428:
429: cursor c_max_assign_action

Line 433: from pay_assignment_actions pac,

429: cursor c_max_assign_action
430: (c_assignment_id per_all_assignments_f.assignment_id%type,
431: c_date_earned pay_payroll_actions.date_earned%type ) is
432: select max(pac.assignment_action_id)
433: from pay_assignment_actions pac,
434: per_all_assignments_f paa,
435: pay_payroll_actions ppa
436: where paa.assignment_id = c_assignment_id
437: and paa.assignment_type = 'E'

Line 559: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

555: -- for the SOE window
556: ------------------------------------------------------------------------
557: procedure balance_totals
558: (p_prepaid_tag in varchar,
559: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
560: p_person_id in per_all_people_f.person_id%type,
561: p_gross_pay_current out nocopy number,
562: p_statutory_deductions_current out nocopy number,
563: p_other_deductions_current out nocopy number,

Line 712: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

708: -- rather than 6 separate calls.
709: -- for the Pay Advice report
710: ------------------------------------------------------------------------
711: procedure balance_totals
712: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
713: p_person_id in per_all_people_f.person_id%type,
714: p_gross_pay_current out nocopy number,
715: p_statutory_deductions_current out nocopy number,
716: p_other_deductions_current out nocopy number,

Line 897: FROM pay_assignment_actions

893: function get_tax_id
894: ( p_assignment_action_id number)
895: return number is
896: cursor tax is SELECT tax_unit_id
897: FROM pay_assignment_actions
898: WHERE assignment_action_id = p_assignment_action_id;
899: v_tax_id number;
900: BEGIN
901: open tax;

Line 1022: (c_payroll_id pay_assignment_actions.assignment_action_id%type,

1018:
1019: v_currency_code fnd_currencies.currency_code%type;
1020:
1021: cursor csr_currency_code
1022: (c_payroll_id pay_assignment_actions.assignment_action_id%type,
1023: c_effective_date in pay_payroll_actions.effective_date%type) is
1024: select popm.currency_code
1025: from pay_payrolls_f ppf,
1026: pay_org_payment_methods_f popm

Line 1055: (c_assignment_id pay_assignment_actions.assignment_action_id%type,

1051: v_currency_code fnd_currencies.currency_code%type;
1052: v_payroll_id pay_payrolls_f.payroll_id%type;
1053:
1054: cursor csr_get_payroll_id
1055: (c_assignment_id pay_assignment_actions.assignment_action_id%type,
1056: c_effective_date in pay_payroll_actions.effective_date%type) is
1057: select payroll_id
1058: from per_all_assignments_f
1059: where assignment_id = c_assignment_id