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 481: , pay_defined_balances pdb_ptd

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
483: WHERE pbt.balance_name IN (''GROSS_PAY''
484: , ''MANDATORY_DEDUCTIONS''
485: , ''INVOLUNTARY_DEDUCTIONS''

Line 482: , pay_defined_balances pdb_ytd

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
483: WHERE pbt.balance_name IN (''GROSS_PAY''
484: , ''MANDATORY_DEDUCTIONS''
485: , ''INVOLUNTARY_DEDUCTIONS''
486: , ''VOLUNTARY_DEDUCTIONS''

Line 729: FROM pay_defined_balances pdb

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