APPS.PAY_US_PAYSLIP_SIMULATION_MAIN dependencies on PAY_BALANCE_TYPES

Line 988: pay_balance_types pbt

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
992: AND pbt.balance_type_id = pdb.balance_type_id

Line 1109: lv_balance_name pay_balance_types.balance_name%TYPE := 'Gross Earnings';

1105: lv_procedure_name VARCHAR2(100) := '.gross_earnings';
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:

Line 2398: ,pay_balance_types pbt

2394: pet.processing_priority
2395: FROM pay_assignment_actions paa
2396: ,pay_element_classifications pec
2397: ,pay_element_types_f pet
2398: ,pay_balance_types pbt
2399: ,pay_defined_balances pdb
2400: ,pay_run_balances prb
2401: ,pay_element_types_f_tl petl
2402: WHERE paa.assignment_id = cp_assignment_id

Line 3639: lv_gross_balance pay_balance_types.balance_name%TYPE;

3635: ln_assignment_id pay_assignment_actions.assignment_id%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: