APPS.PAY_HK_SOE_PKG dependencies on PAY_DEFINED_BALANCES

Line 52: return pay_defined_balances.defined_balance_id%type

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:
55: p_defined_balance_id pay_defined_balances.defined_balance_id%type;
56:

Line 55: p_defined_balance_id pay_defined_balances.defined_balance_id%type;

51: p_dimension_name in pay_balance_dimensions.dimension_name%type)
52: return pay_defined_balances.defined_balance_id%type
53: is
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

Line 63: pay_defined_balances pdb,

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
67: and pbd.dimension_name = c_dimension_name

Line 119: pay_defined_balances pdb

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'
122: , 'INVOLUNTARY_DEDUCTIONS'
123: , 'VOLUNTARY_DEDUCTIONS'

Line 482: , pay_defined_balances pdb_ptd

478: , fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL18
479: FROM pay_balance_types pbt
480: , pay_balance_dimensions pbd_ptd
481: , pay_balance_dimensions pbd_ytd
482: , pay_defined_balances pdb_ptd
483: , pay_defined_balances pdb_ytd
484: WHERE pbt.balance_name IN (''GROSS_PAY''
485: , ''MANDATORY_DEDUCTIONS''
486: , ''INVOLUNTARY_DEDUCTIONS''

Line 483: , pay_defined_balances pdb_ytd

479: FROM pay_balance_types pbt
480: , pay_balance_dimensions pbd_ptd
481: , pay_balance_dimensions pbd_ytd
482: , pay_defined_balances pdb_ptd
483: , pay_defined_balances pdb_ytd
484: WHERE pbt.balance_name IN (''GROSS_PAY''
485: , ''MANDATORY_DEDUCTIONS''
486: , ''INVOLUNTARY_DEDUCTIONS''
487: , ''VOLUNTARY_DEDUCTIONS''

Line 730: FROM pay_defined_balances pdb

726: , fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(l_date_earned) || ''')
727: , NULL
728: , NULL)
729: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
730: FROM pay_defined_balances pdb
731: , hr_organization_information_v org
732: WHERE org.organization_id = ' || l_business_group_id || '
733: AND org.org_information_context = ''Business Group:SOE Detail''
734: AND org.org_information1 = ''BALANCE''