DBA Data[Home] [Help]

APPS.PAY_YEAR_END_EXTRACT dependencies on PAY_BALANCE_TYPES

Line 363: pay_balance_types b,

359: (p_balance_name varchar2, p_dimension_name varchar2) is
360: --
361: select defined_balance_id
362: from pay_defined_balances db,
363: pay_balance_types b,
364: pay_balance_dimensions d
365: where b.balance_name = p_balance_name
366: and d.dimension_name = p_dimension_name
367: and db.balance_type_id = b.balance_type_id

Line 472: ,pay_balance_types BAL

468: fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0) CO_able,
469: 100*nvl(sum(decode(substr(bal.balance_name,6),'CO',
470: fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0) CO
471: from pay_balance_feeds_f FEED
472: ,pay_balance_types BAL
473: ,pay_run_result_values TARGET
474: ,pay_run_results RR
475: ,pay_element_entry_values_f EV_SCON
476: ,pay_element_entries_f E_NI