APPS.PAY_KR_YEA_PKG dependencies on PAY_BALANCE_TYPES

Line 3775: pay_balance_types BAL_TYPE,

3771: ) is
3772: select BAL_TYPE.balance_name,
3773: nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)
3774: from pay_balance_feeds_f FEED,
3775: pay_balance_types BAL_TYPE,
3776: pay_run_result_values TARGET,
3777: pay_run_results RR,
3778: pay_payroll_actions PACT,
3779: pay_assignment_actions ASSACT,

Line 3816: l_bal_name pay_balance_types.balance_name%type ;

3812: FEED.effective_end_date
3813: group by
3814: BAL_TYPE.balance_name ;
3815: --
3816: l_bal_name pay_balance_types.balance_name%type ;
3817: l_bal_value number ;
3818: l_fw_tax_reduction_duration number;
3819: function get_globalvalue(p_glbvar in varchar2,p_process_date in date) return number
3820: is

Line 3921: FROM pay_balance_types pbt,

3917:
3918: cursor csr_get_def_bal_id
3919: is
3920: SELECT pdb.defined_balance_id
3921: FROM pay_balance_types pbt,
3922: pay_defined_balances pdb,
3923: pay_balance_dimensions pbd
3924: WHERE pbt.balance_name = p_balance_name
3925: and pbt.legislation_code = 'KR'