[Home] [Help]
46: ------------------------------------------------------------------------
47: -- Sums the Balances for This Pay and YTD, according to the parameters.
48: ------------------------------------------------------------------------
49: function get_balance_id
50: (p_balance_name in pay_balance_types.balance_name%type,
51: p_dimension_name in pay_balance_dimensions.dimension_name%type)
52: return pay_defined_balances.defined_balance_id%type
53: is
54:
54:
55: p_defined_balance_id pay_defined_balances.defined_balance_id%type;
56:
57: cursor balance_id
58: (c_balance_name pay_balance_types.balance_name%type,
59: c_dimension_name pay_balance_dimensions.dimension_name%type) is
60: select
61: pdb.defined_balance_id
62: from pay_balance_types pbt,
58: (c_balance_name pay_balance_types.balance_name%type,
59: c_dimension_name pay_balance_dimensions.dimension_name%type) is
60: select
61: pdb.defined_balance_id
62: from pay_balance_types pbt,
63: pay_defined_balances pdb,
64: pay_balance_dimensions pbd
65: where pbt.balance_type_id = pdb.balance_type_id
66: and pdb.balance_dimension_id = pbd.balance_dimension_id
113: , 'NET',5
114: , 'DIRECT_PAYMENTS',6
115: , 'TOTAL_PAYMENTS',7) sort_index,
116: pdb.defined_balance_id defined_balance_id
117: FROM pay_balance_types pbt,
118: pay_balance_dimensions pbd,
119: pay_defined_balances pdb
120: WHERE pbt.balance_name IN ('GROSS_PAY'
121: , 'MANDATORY_DEDUCTIONS'
474: , fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(l_date_earned) || ''')
475: , NULL
476: , NULL)
477: , fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL18
478: FROM pay_balance_types pbt
479: , pay_balance_dimensions pbd_ptd
480: , pay_balance_dimensions pbd_ytd
481: , pay_defined_balances pdb_ptd
482: , pay_defined_balances pdb_ytd