DBA Data[Home] [Help]

APPS.PER_JP_EMPDET_ARCHIVE_PKG dependencies on PAY_JP_BALANCE_PKG

Line 1958: l_emp_hi_num := pay_jp_balance_pkg.get_entry_value_char(c_hi_card_num_iv_id,p_assignment_id,l_effective_date_ass);

1954: hr_utility.trace('l_effective_date_proc : '||to_char(l_effective_date_proc,'YYYY/MM/DD'));
1955: hr_utility.trace('l_hire_date : '||to_char(l_hire_date,'YYYY/MM/DD'));
1956: end if;
1957: --
1958: l_emp_hi_num := pay_jp_balance_pkg.get_entry_value_char(c_hi_card_num_iv_id,p_assignment_id,l_effective_date_ass);
1959: l_emp_wp_num := pay_jp_balance_pkg.get_entry_value_char(c_basic_pension_num_iv_id,p_assignment_id,l_effective_date_ass);
1960: l_emp_wpf_num := pay_jp_balance_pkg.get_entry_value_char(c_wpf_members_num_iv_id,p_assignment_id,l_effective_date_ass);
1961: l_emp_ei_num := pay_jp_balance_pkg.get_entry_value_char(c_ei_num_iv_id,p_assignment_id,l_effective_date_ass);
1962: l_emp_hi_qd := pay_jp_balance_pkg.get_entry_value_date(c_hi_qualify_date_iv_id,p_assignment_id,l_effective_date_ass);

Line 1959: l_emp_wp_num := pay_jp_balance_pkg.get_entry_value_char(c_basic_pension_num_iv_id,p_assignment_id,l_effective_date_ass);

1955: hr_utility.trace('l_hire_date : '||to_char(l_hire_date,'YYYY/MM/DD'));
1956: end if;
1957: --
1958: l_emp_hi_num := pay_jp_balance_pkg.get_entry_value_char(c_hi_card_num_iv_id,p_assignment_id,l_effective_date_ass);
1959: l_emp_wp_num := pay_jp_balance_pkg.get_entry_value_char(c_basic_pension_num_iv_id,p_assignment_id,l_effective_date_ass);
1960: l_emp_wpf_num := pay_jp_balance_pkg.get_entry_value_char(c_wpf_members_num_iv_id,p_assignment_id,l_effective_date_ass);
1961: l_emp_ei_num := pay_jp_balance_pkg.get_entry_value_char(c_ei_num_iv_id,p_assignment_id,l_effective_date_ass);
1962: l_emp_hi_qd := pay_jp_balance_pkg.get_entry_value_date(c_hi_qualify_date_iv_id,p_assignment_id,l_effective_date_ass);
1963: l_emp_wp_qd := pay_jp_balance_pkg.get_entry_value_date(c_wp_qualify_date_iv_id,p_assignment_id,l_effective_date_ass);

Line 1960: l_emp_wpf_num := pay_jp_balance_pkg.get_entry_value_char(c_wpf_members_num_iv_id,p_assignment_id,l_effective_date_ass);

1956: end if;
1957: --
1958: l_emp_hi_num := pay_jp_balance_pkg.get_entry_value_char(c_hi_card_num_iv_id,p_assignment_id,l_effective_date_ass);
1959: l_emp_wp_num := pay_jp_balance_pkg.get_entry_value_char(c_basic_pension_num_iv_id,p_assignment_id,l_effective_date_ass);
1960: l_emp_wpf_num := pay_jp_balance_pkg.get_entry_value_char(c_wpf_members_num_iv_id,p_assignment_id,l_effective_date_ass);
1961: l_emp_ei_num := pay_jp_balance_pkg.get_entry_value_char(c_ei_num_iv_id,p_assignment_id,l_effective_date_ass);
1962: l_emp_hi_qd := pay_jp_balance_pkg.get_entry_value_date(c_hi_qualify_date_iv_id,p_assignment_id,l_effective_date_ass);
1963: l_emp_wp_qd := pay_jp_balance_pkg.get_entry_value_date(c_wp_qualify_date_iv_id,p_assignment_id,l_effective_date_ass);
1964: l_emp_wpf_qd := pay_jp_balance_pkg.get_entry_value_date(c_wpf_qualify_date_iv_id,p_assignment_id,l_effective_date_ass);

Line 1961: l_emp_ei_num := pay_jp_balance_pkg.get_entry_value_char(c_ei_num_iv_id,p_assignment_id,l_effective_date_ass);

1957: --
1958: l_emp_hi_num := pay_jp_balance_pkg.get_entry_value_char(c_hi_card_num_iv_id,p_assignment_id,l_effective_date_ass);
1959: l_emp_wp_num := pay_jp_balance_pkg.get_entry_value_char(c_basic_pension_num_iv_id,p_assignment_id,l_effective_date_ass);
1960: l_emp_wpf_num := pay_jp_balance_pkg.get_entry_value_char(c_wpf_members_num_iv_id,p_assignment_id,l_effective_date_ass);
1961: l_emp_ei_num := pay_jp_balance_pkg.get_entry_value_char(c_ei_num_iv_id,p_assignment_id,l_effective_date_ass);
1962: l_emp_hi_qd := pay_jp_balance_pkg.get_entry_value_date(c_hi_qualify_date_iv_id,p_assignment_id,l_effective_date_ass);
1963: l_emp_wp_qd := pay_jp_balance_pkg.get_entry_value_date(c_wp_qualify_date_iv_id,p_assignment_id,l_effective_date_ass);
1964: l_emp_wpf_qd := pay_jp_balance_pkg.get_entry_value_date(c_wpf_qualify_date_iv_id,p_assignment_id,l_effective_date_ass);
1965: l_emp_ei_qd := pay_jp_balance_pkg.get_entry_value_date(c_ei_qualify_date_iv_id,p_assignment_id,l_effective_date_ass);

Line 1962: l_emp_hi_qd := pay_jp_balance_pkg.get_entry_value_date(c_hi_qualify_date_iv_id,p_assignment_id,l_effective_date_ass);

1958: l_emp_hi_num := pay_jp_balance_pkg.get_entry_value_char(c_hi_card_num_iv_id,p_assignment_id,l_effective_date_ass);
1959: l_emp_wp_num := pay_jp_balance_pkg.get_entry_value_char(c_basic_pension_num_iv_id,p_assignment_id,l_effective_date_ass);
1960: l_emp_wpf_num := pay_jp_balance_pkg.get_entry_value_char(c_wpf_members_num_iv_id,p_assignment_id,l_effective_date_ass);
1961: l_emp_ei_num := pay_jp_balance_pkg.get_entry_value_char(c_ei_num_iv_id,p_assignment_id,l_effective_date_ass);
1962: l_emp_hi_qd := pay_jp_balance_pkg.get_entry_value_date(c_hi_qualify_date_iv_id,p_assignment_id,l_effective_date_ass);
1963: l_emp_wp_qd := pay_jp_balance_pkg.get_entry_value_date(c_wp_qualify_date_iv_id,p_assignment_id,l_effective_date_ass);
1964: l_emp_wpf_qd := pay_jp_balance_pkg.get_entry_value_date(c_wpf_qualify_date_iv_id,p_assignment_id,l_effective_date_ass);
1965: l_emp_ei_qd := pay_jp_balance_pkg.get_entry_value_date(c_ei_qualify_date_iv_id,p_assignment_id,l_effective_date_ass);
1966: --

Line 1963: l_emp_wp_qd := pay_jp_balance_pkg.get_entry_value_date(c_wp_qualify_date_iv_id,p_assignment_id,l_effective_date_ass);

1959: l_emp_wp_num := pay_jp_balance_pkg.get_entry_value_char(c_basic_pension_num_iv_id,p_assignment_id,l_effective_date_ass);
1960: l_emp_wpf_num := pay_jp_balance_pkg.get_entry_value_char(c_wpf_members_num_iv_id,p_assignment_id,l_effective_date_ass);
1961: l_emp_ei_num := pay_jp_balance_pkg.get_entry_value_char(c_ei_num_iv_id,p_assignment_id,l_effective_date_ass);
1962: l_emp_hi_qd := pay_jp_balance_pkg.get_entry_value_date(c_hi_qualify_date_iv_id,p_assignment_id,l_effective_date_ass);
1963: l_emp_wp_qd := pay_jp_balance_pkg.get_entry_value_date(c_wp_qualify_date_iv_id,p_assignment_id,l_effective_date_ass);
1964: l_emp_wpf_qd := pay_jp_balance_pkg.get_entry_value_date(c_wpf_qualify_date_iv_id,p_assignment_id,l_effective_date_ass);
1965: l_emp_ei_qd := pay_jp_balance_pkg.get_entry_value_date(c_ei_qualify_date_iv_id,p_assignment_id,l_effective_date_ass);
1966: --
1967: if g_debug

Line 1964: l_emp_wpf_qd := pay_jp_balance_pkg.get_entry_value_date(c_wpf_qualify_date_iv_id,p_assignment_id,l_effective_date_ass);

1960: l_emp_wpf_num := pay_jp_balance_pkg.get_entry_value_char(c_wpf_members_num_iv_id,p_assignment_id,l_effective_date_ass);
1961: l_emp_ei_num := pay_jp_balance_pkg.get_entry_value_char(c_ei_num_iv_id,p_assignment_id,l_effective_date_ass);
1962: l_emp_hi_qd := pay_jp_balance_pkg.get_entry_value_date(c_hi_qualify_date_iv_id,p_assignment_id,l_effective_date_ass);
1963: l_emp_wp_qd := pay_jp_balance_pkg.get_entry_value_date(c_wp_qualify_date_iv_id,p_assignment_id,l_effective_date_ass);
1964: l_emp_wpf_qd := pay_jp_balance_pkg.get_entry_value_date(c_wpf_qualify_date_iv_id,p_assignment_id,l_effective_date_ass);
1965: l_emp_ei_qd := pay_jp_balance_pkg.get_entry_value_date(c_ei_qualify_date_iv_id,p_assignment_id,l_effective_date_ass);
1966: --
1967: if g_debug
1968: and g_detail_debug = 'Y' then

Line 1965: l_emp_ei_qd := pay_jp_balance_pkg.get_entry_value_date(c_ei_qualify_date_iv_id,p_assignment_id,l_effective_date_ass);

1961: l_emp_ei_num := pay_jp_balance_pkg.get_entry_value_char(c_ei_num_iv_id,p_assignment_id,l_effective_date_ass);
1962: l_emp_hi_qd := pay_jp_balance_pkg.get_entry_value_date(c_hi_qualify_date_iv_id,p_assignment_id,l_effective_date_ass);
1963: l_emp_wp_qd := pay_jp_balance_pkg.get_entry_value_date(c_wp_qualify_date_iv_id,p_assignment_id,l_effective_date_ass);
1964: l_emp_wpf_qd := pay_jp_balance_pkg.get_entry_value_date(c_wpf_qualify_date_iv_id,p_assignment_id,l_effective_date_ass);
1965: l_emp_ei_qd := pay_jp_balance_pkg.get_entry_value_date(c_ei_qualify_date_iv_id,p_assignment_id,l_effective_date_ass);
1966: --
1967: if g_debug
1968: and g_detail_debug = 'Y' then
1969: l_archive_step := 2;

Line 2011: l_trm_amt := pay_jp_balance_pkg.get_balance_value(c_b_trm_ern_bal_run_db_id,l_trm_assact_id);

2007: end if;
2008: --
2009: if l_trm_assact_id is not null then
2010: --
2011: l_trm_amt := pay_jp_balance_pkg.get_balance_value(c_b_trm_ern_bal_run_db_id,l_trm_assact_id);
2012: --
2013: end if;
2014: --
2015: if g_debug