APPS.PAY_HK_SOE_PKG dependencies on PAY_BALANCE_PKG

Line 12: p_balance_value_tab_payment pay_balance_pkg.t_balance_value_tab;

8: ------------------------------------------------------------------------
9: -- Define global variable to store defined_balance_id's and the
10: -- corresponding balance values for BBR.
11: ------------------------------------------------------------------------
12: p_balance_value_tab_payment pay_balance_pkg.t_balance_value_tab;
13: p_balance_value_tab_ytd pay_balance_pkg.t_balance_value_tab;
14: p_context_table pay_balance_pkg.t_context_tab;
15: p_result_table pay_balance_pkg.t_detailed_bal_out_tab;
16:

Line 13: p_balance_value_tab_ytd pay_balance_pkg.t_balance_value_tab;

9: -- Define global variable to store defined_balance_id's and the
10: -- corresponding balance values for BBR.
11: ------------------------------------------------------------------------
12: p_balance_value_tab_payment pay_balance_pkg.t_balance_value_tab;
13: p_balance_value_tab_ytd pay_balance_pkg.t_balance_value_tab;
14: p_context_table pay_balance_pkg.t_context_tab;
15: p_result_table pay_balance_pkg.t_detailed_bal_out_tab;
16:
17: ------------------------------------------------------------------------

Line 14: p_context_table pay_balance_pkg.t_context_tab;

10: -- corresponding balance values for BBR.
11: ------------------------------------------------------------------------
12: p_balance_value_tab_payment pay_balance_pkg.t_balance_value_tab;
13: p_balance_value_tab_ytd pay_balance_pkg.t_balance_value_tab;
14: p_context_table pay_balance_pkg.t_context_tab;
15: p_result_table pay_balance_pkg.t_detailed_bal_out_tab;
16:
17: ------------------------------------------------------------------------
18: -- Returns the Currency Code for the Business Group.

Line 15: p_result_table pay_balance_pkg.t_detailed_bal_out_tab;

11: ------------------------------------------------------------------------
12: p_balance_value_tab_payment pay_balance_pkg.t_balance_value_tab;
13: p_balance_value_tab_ytd pay_balance_pkg.t_balance_value_tab;
14: p_context_table pay_balance_pkg.t_context_tab;
15: p_result_table pay_balance_pkg.t_detailed_bal_out_tab;
16:
17: ------------------------------------------------------------------------
18: -- Returns the Currency Code for the Business Group.
19: ------------------------------------------------------------------------

Line 177: pay_balance_pkg.get_value(p_assignment_action_id => p_assignment_action_id

173: p_context_table(1).tax_unit_id := p_tax_unit_id;
174:
175: /* get the balances using BBR. Bug 3609072 */
176:
177: pay_balance_pkg.get_value(p_assignment_action_id => p_assignment_action_id
178: ,p_defined_balance_lst=>p_balance_value_tab_payment
179: ,p_context_lst => p_context_table
180: ,p_output_table=> p_result_table);
181:

Line 219: pay_balance_pkg.get_value(p_assignment_action_id => p_assignment_action_id,

215: end if;
216:
217: /* get the balances using BBR. Bug 3609072 */
218:
219: pay_balance_pkg.get_value(p_assignment_action_id => p_assignment_action_id,
220: p_defined_balance_lst=>p_balance_value_tab_ytd,
221: p_context_lst =>p_context_table,
222: p_output_table=>p_result_table);
223:

Line 456: , TO_CHAR(pay_balance_pkg.get_value( pdb_ptd.defined_balance_id

452: FETCH csr_get_date_earned INTO l_date_earned, l_tax_unit_id;
453: CLOSE csr_get_date_earned;
454:
455: g_sql := 'SELECT /*+ USE_NL(pbt) */ NVL(pbt.reporting_name, pbt.balance_name) COL04
456: , TO_CHAR(pay_balance_pkg.get_value( pdb_ptd.defined_balance_id
457: , ' || l_assignment_action_id || '
458: , ' || l_tax_unit_id || '
459: , NULL
460: , NULL

Line 467: , TO_CHAR(pay_balance_pkg.get_value( pdb_ytd.defined_balance_id

463: , fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(l_date_earned) || ''')
464: , NULL
465: , NULL)
466: , fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
467: , TO_CHAR(pay_balance_pkg.get_value( pdb_ytd.defined_balance_id
468: , ' || l_assignment_action_id || '
469: , ' || l_tax_unit_id || '
470: , NULL
471: , NULL

Line 718: , TO_CHAR(pay_balance_pkg.get_value( pdb.defined_balance_id

714: FETCH csr_get_date_earned INTO l_date_earned, l_business_group_id, l_tax_unit_id;
715: CLOSE csr_get_date_earned;
716:
717: g_sql := 'SELECT org.org_information7 COL02
718: , TO_CHAR(pay_balance_pkg.get_value( pdb.defined_balance_id
719: , ' || l_assignment_action_id || '
720: , ' || l_tax_unit_id || '
721: , NULL
722: , NULL

Line 736: AND pay_balance_pkg.get_value( pdb.defined_balance_id

732: AND org.org_information_context = ''Business Group:SOE Detail''
733: AND org.org_information1 = ''BALANCE''
734: AND pdb.balance_type_id = org.org_information4
735: AND pdb.balance_dimension_id = org.org_information5
736: AND pay_balance_pkg.get_value( pdb.defined_balance_id
737: , ' || l_assignment_action_id || '
738: , ' || l_tax_unit_id || '
739: , NULL
740: , NULL