DBA Data[Home] [Help]

APPS.PAY_GB_EOY_ARCHIVE dependencies on PAY_BALANCE_TYPES

Line 2263: pay_balance_types b,

2259: cursor get_defined_balance_id
2260: (p_balance_name VARCHAR2, p_dimension_name VARCHAR2) IS
2261: SELECT defined_balance_id
2262: FROM pay_defined_balances db,
2263: pay_balance_types b,
2264: pay_balance_dimensions d
2265: WHERE b.balance_name = p_balance_name
2266: AND d.dimension_name = p_dimension_name
2267: AND db.balance_type_id = b.balance_type_id

Line 3584: ,pay_balance_types bal

3580: 100*nvl(sum(decode(substr(bal.balance_name,6),'Rebate to Employee',
3581: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3582: rebate_emp
3583: FROM pay_balance_feeds_f feed
3584: ,pay_balance_types bal
3585: ,pay_run_result_values target
3586: ,pay_run_results rr
3587: ,pay_element_entry_values_f ev_scon
3588: ,pay_element_entry_values_f ev_cat