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_BALANCE_PKG

Line 99: directly from pay_balance_pkg.get_value instead of retrieving it from

95: -- Sums the Balances for Current and YTD, according to the parameters.
96: -- for the SOE window
97: ------------------------------------------------------------------------
98: /* Bug:2883606. This procedure is modified to retrieve balance values
99: directly from pay_balance_pkg.get_value instead of retrieving it from
100: the view pay_sg_soe_balances_v */
101:
102: procedure current_and_ytd_balances
103: (p_prepaid_tag in varchar,

Line 138: -- pay_balance_pkg.set_context('TAX_UNIT_ID');

134: assignment_table assign_tab;
135:
136: /* Bug 2824397 */
137:
138: -- pay_balance_pkg.set_context('TAX_UNIT_ID');
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

Line 139: -- pay_balance_pkg.set_context('JURISDICTION_CODE');

135:
136: /* Bug 2824397 */
137:
138: -- pay_balance_pkg.set_context('TAX_UNIT_ID');
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,

Line 141: /* Bug:2883606. Cursor to get the balance values from pay_balance_pkg.get_value */

137:
138: -- pay_balance_pkg.set_context('TAX_UNIT_ID');
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

Line 146: select nvl(pay_balance_pkg.get_value(pdb.defined_balance_id,c_assignment_action_id),0)

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,
148: pay_defined_balances pdb,
149: pay_balance_types pbt
150: where pbt.balance_name = c_balance_name

Line 335: directly from pay_balance_pkg.get_value instead of retrieving it from

331: -- Sums the Balances for Current and YTD, according to the parameters.
332: -- for the Pay Advice report
333: ------------------------------------------------------------------------
334: /* Bug:2883606. This procedure is modified to retrieve balance values
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,

Line 372: -- pay_balance_pkg.set_context('TAX_UNIT_ID');

368:
369: assignment_table assign_tab;
370:
371: /* Bug 2824397 */
372: -- pay_balance_pkg.set_context('TAX_UNIT_ID');
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

Line 373: -- pay_balance_pkg.set_context('JURISDICTION_CODE');

369: assignment_table assign_tab;
370:
371: /* Bug 2824397 */
372: -- pay_balance_pkg.set_context('TAX_UNIT_ID');
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,

Line 375: /* Bug:2883606. Cursor to get the balance values from pay_balance_pkg.get_value */

371: /* Bug 2824397 */
372: -- pay_balance_pkg.set_context('TAX_UNIT_ID');
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

Line 380: select nvl(pay_balance_pkg.get_value(pdb.defined_balance_id,c_assignment_action_id),0)

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,
382: pay_defined_balances pdb,
383: pay_balance_types pbt
384: where pbt.balance_name = c_balance_name

Line 608: pay_balance_pkg.set_context('TAX_UNIT_ID',v_tax_id);

604:
605: begin
606: v_tax_id := get_tax_id(p_assignment_action_id);
607:
608: pay_balance_pkg.set_context('TAX_UNIT_ID',v_tax_id);
609: -- Call procedure to get Current and YTD balances for Payment Summary Totals
610: hr_utility.trace('JL pay_sg_soe, p_assignment_action_id:'||p_assignment_action_id);
611: current_and_ytd_balances (p_prepaid_tag => p_prepaid_tag,
612: p_assignment_action_id => p_assignment_action_id,

Line 760: pay_balance_pkg.set_context('TAX_UNIT_ID',v_tax_id);

756: v_tax_id number;
757:
758: begin
759: v_tax_id := get_tax_id(p_assignment_action_id);
760: pay_balance_pkg.set_context('TAX_UNIT_ID',v_tax_id);
761: -- Call procedure to get Current and YTD balances for Payment Summary Totals
762: current_and_ytd_balances (p_assignment_action_id => p_assignment_action_id,
763: p_balance_name => 'Gross Pay',
764: p_person_id => p_person_id,