APPS.PAY_US_PAYSLIP_SIMULATION_MAIN dependencies on PAY_BALANCE_DIMENSIONS

Line 963: DATABASE_ITEM_SUFFIX column of PAY_BALANCE_DIMENSIONS

959: This is a Generic function that can be used by any
960: Localization and Defined Balance ID can be retrieved
961: using Balance Type ID or Balance Name. Also the Balance
962: Dimension Parameter used here corresponds to the
963: DATABASE_ITEM_SUFFIX column of PAY_BALANCE_DIMENSIONS
964: table.
965: Important :
966: */
967:

Line 987: pay_balance_dimensions pbd,

983: cp_balance_dimension VARCHAR2 )
984: IS
985: SELECT pdb.defined_balance_id
986: FROM pay_defined_balances pdb,
987: pay_balance_dimensions pbd,
988: pay_balance_types pbt
989: WHERE pbt.balance_name = NVL(cp_balance_name,pbt.balance_name)
990: AND pbt.balance_type_id = NVL(cp_balance_type_id,pbt.balance_type_id)
991: AND pbd.database_item_suffix= cp_balance_dimension

Line 1110: lv_dim_dbi_suffix pay_balance_dimensions.database_item_suffix%TYPE;

1106:
1107: ln_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
1108: ln_gross_earnings NUMBER := 0;
1109: lv_balance_name pay_balance_types.balance_name%TYPE := 'Gross Earnings';
1110: lv_dim_dbi_suffix pay_balance_dimensions.database_item_suffix%TYPE;
1111:
1112: BEGIN
1113:
1114: hr_utility.trace('Entering '||gv_package||lv_procedure_name);

Line 3640: lv_run_dimension_suffix pay_balance_dimensions.database_item_suffix%TYPE;

3636: ln_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
3637: ln_payroll_action_id pay_assignment_actions.payroll_action_id%TYPE;
3638:
3639: lv_gross_balance pay_balance_types.balance_name%TYPE;
3640: lv_run_dimension_suffix pay_balance_dimensions.database_item_suffix%TYPE;
3641:
3642: ln_gross_earnings NUMBER;
3643:
3644: lv_archive_balance_info VARCHAR2(2);