DBA Data[Home] [Help]

APPS.PAY_GB_EOY_ARCHIVE dependencies on PAY_BALANCE_TYPES

Line 2214: pay_balance_types b,

2210: cursor get_defined_balance_id
2211: (p_balance_name VARCHAR2, p_dimension_name VARCHAR2) IS
2212: SELECT defined_balance_id
2213: FROM pay_defined_balances db,
2214: pay_balance_types b,
2215: pay_balance_dimensions d
2216: WHERE b.balance_name = p_balance_name
2217: AND d.dimension_name = p_dimension_name
2218: AND db.balance_type_id = b.balance_type_id

Line 3449: ,pay_balance_types bal

3445: 100*nvl(sum(decode(substr(bal.balance_name,6),'Rebate to Employee',
3446: fnd_number.canonical_to_number(target.result_value) * feed.scale,0)),0)
3447: rebate_emp
3448: FROM pay_balance_feeds_f feed
3449: ,pay_balance_types bal
3450: ,pay_run_result_values target
3451: ,pay_run_results rr
3452: ,pay_element_entry_values_f ev_scon
3453: ,pay_element_entry_values_f ev_cat