eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PAYJPBON_XMLP_PKG dependencies on PAY_JP_BALANCE_PKG

Line 53: l_legislation_code := pay_jp_balance_pkg.get_legislation_code(p_business_group_id);

49: cp_reported_date_dd := lpad(to_char(l_date_dd),2,'0');
50: cp_reported_date_yymmdd := cp_reported_date_yy||'.'||cp_reported_date_mm||'.'||cp_reported_date_dd;
51:
52:
53: l_legislation_code := pay_jp_balance_pkg.get_legislation_code(p_business_group_id);
54: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_HI_QUALIFY_INFO',p_business_group_id,l_legislation_code);
55: g_hi_qualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'QUALIFY_DATE');
56: g_hi_disqualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_DATE');
57: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_QUALIFY_INFO',p_business_group_id,l_legislation_code);

Line 54: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_HI_QUALIFY_INFO',p_business_group_id,l_legislation_code);

50: cp_reported_date_yymmdd := cp_reported_date_yy||'.'||cp_reported_date_mm||'.'||cp_reported_date_dd;
51:
52:
53: l_legislation_code := pay_jp_balance_pkg.get_legislation_code(p_business_group_id);
54: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_HI_QUALIFY_INFO',p_business_group_id,l_legislation_code);
55: g_hi_qualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'QUALIFY_DATE');
56: g_hi_disqualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_DATE');
57: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_QUALIFY_INFO',p_business_group_id,l_legislation_code);
58: g_wp_qualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'QUALIFY_DATE');

Line 55: g_hi_qualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'QUALIFY_DATE');

51:
52:
53: l_legislation_code := pay_jp_balance_pkg.get_legislation_code(p_business_group_id);
54: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_HI_QUALIFY_INFO',p_business_group_id,l_legislation_code);
55: g_hi_qualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'QUALIFY_DATE');
56: g_hi_disqualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_DATE');
57: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_QUALIFY_INFO',p_business_group_id,l_legislation_code);
58: g_wp_qualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'QUALIFY_DATE');
59: g_wp_disqualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_DATE');

Line 56: g_hi_disqualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_DATE');

52:
53: l_legislation_code := pay_jp_balance_pkg.get_legislation_code(p_business_group_id);
54: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_HI_QUALIFY_INFO',p_business_group_id,l_legislation_code);
55: g_hi_qualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'QUALIFY_DATE');
56: g_hi_disqualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_DATE');
57: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_QUALIFY_INFO',p_business_group_id,l_legislation_code);
58: g_wp_qualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'QUALIFY_DATE');
59: g_wp_disqualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_DATE');
60: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WPF_QUALIFY_INFO',p_business_group_id,l_legislation_code);

Line 57: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_QUALIFY_INFO',p_business_group_id,l_legislation_code);

53: l_legislation_code := pay_jp_balance_pkg.get_legislation_code(p_business_group_id);
54: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_HI_QUALIFY_INFO',p_business_group_id,l_legislation_code);
55: g_hi_qualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'QUALIFY_DATE');
56: g_hi_disqualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_DATE');
57: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_QUALIFY_INFO',p_business_group_id,l_legislation_code);
58: g_wp_qualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'QUALIFY_DATE');
59: g_wp_disqualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_DATE');
60: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WPF_QUALIFY_INFO',p_business_group_id,l_legislation_code);
61: g_wpf_qualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'QUALIFY_DATE');

Line 58: g_wp_qualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'QUALIFY_DATE');

54: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_HI_QUALIFY_INFO',p_business_group_id,l_legislation_code);
55: g_hi_qualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'QUALIFY_DATE');
56: g_hi_disqualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_DATE');
57: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_QUALIFY_INFO',p_business_group_id,l_legislation_code);
58: g_wp_qualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'QUALIFY_DATE');
59: g_wp_disqualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_DATE');
60: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WPF_QUALIFY_INFO',p_business_group_id,l_legislation_code);
61: g_wpf_qualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'QUALIFY_DATE');
62: g_wpf_disqualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_DATE');

Line 59: g_wp_disqualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_DATE');

55: g_hi_qualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'QUALIFY_DATE');
56: g_hi_disqualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_DATE');
57: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_QUALIFY_INFO',p_business_group_id,l_legislation_code);
58: g_wp_qualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'QUALIFY_DATE');
59: g_wp_disqualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_DATE');
60: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WPF_QUALIFY_INFO',p_business_group_id,l_legislation_code);
61: g_wpf_qualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'QUALIFY_DATE');
62: g_wpf_disqualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_DATE');
63: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_INFO',p_business_group_id,l_legislation_code);

Line 60: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WPF_QUALIFY_INFO',p_business_group_id,l_legislation_code);

56: g_hi_disqualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_DATE');
57: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_QUALIFY_INFO',p_business_group_id,l_legislation_code);
58: g_wp_qualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'QUALIFY_DATE');
59: g_wp_disqualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_DATE');
60: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WPF_QUALIFY_INFO',p_business_group_id,l_legislation_code);
61: g_wpf_qualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'QUALIFY_DATE');
62: g_wpf_disqualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_DATE');
63: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_INFO',p_business_group_id,l_legislation_code);
64: g_si_sex_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SI_SEX');

Line 61: g_wpf_qualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'QUALIFY_DATE');

57: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WP_QUALIFY_INFO',p_business_group_id,l_legislation_code);
58: g_wp_qualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'QUALIFY_DATE');
59: g_wp_disqualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_DATE');
60: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WPF_QUALIFY_INFO',p_business_group_id,l_legislation_code);
61: g_wpf_qualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'QUALIFY_DATE');
62: g_wpf_disqualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_DATE');
63: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_INFO',p_business_group_id,l_legislation_code);
64: g_si_sex_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SI_SEX');
65: g_bon_hi_std_prem_elm_id := pay_jp_balance_pkg.get_element_type_id('BON_HI_STD_BON',p_business_group_id,l_legislation_code);

Line 62: g_wpf_disqualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_DATE');

58: g_wp_qualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'QUALIFY_DATE');
59: g_wp_disqualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_DATE');
60: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WPF_QUALIFY_INFO',p_business_group_id,l_legislation_code);
61: g_wpf_qualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'QUALIFY_DATE');
62: g_wpf_disqualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_DATE');
63: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_INFO',p_business_group_id,l_legislation_code);
64: g_si_sex_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SI_SEX');
65: g_bon_hi_std_prem_elm_id := pay_jp_balance_pkg.get_element_type_id('BON_HI_STD_BON',p_business_group_id,l_legislation_code);
66: g_earn_sj_hi_prem_iv_id := pay_jp_balance_pkg.get_input_value_id(g_bon_hi_std_prem_elm_id,'ERN_MONEY');

Line 63: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_INFO',p_business_group_id,l_legislation_code);

59: g_wp_disqualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_DATE');
60: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WPF_QUALIFY_INFO',p_business_group_id,l_legislation_code);
61: g_wpf_qualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'QUALIFY_DATE');
62: g_wpf_disqualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_DATE');
63: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_INFO',p_business_group_id,l_legislation_code);
64: g_si_sex_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SI_SEX');
65: g_bon_hi_std_prem_elm_id := pay_jp_balance_pkg.get_element_type_id('BON_HI_STD_BON',p_business_group_id,l_legislation_code);
66: g_earn_sj_hi_prem_iv_id := pay_jp_balance_pkg.get_input_value_id(g_bon_hi_std_prem_elm_id,'ERN_MONEY');
67: g_earn_kind_sj_hi_prem_iv_id := pay_jp_balance_pkg.get_input_value_id(g_bon_hi_std_prem_elm_id,'ERN_KIND');

Line 64: g_si_sex_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SI_SEX');

60: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_WPF_QUALIFY_INFO',p_business_group_id,l_legislation_code);
61: g_wpf_qualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'QUALIFY_DATE');
62: g_wpf_disqualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_DATE');
63: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_INFO',p_business_group_id,l_legislation_code);
64: g_si_sex_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SI_SEX');
65: g_bon_hi_std_prem_elm_id := pay_jp_balance_pkg.get_element_type_id('BON_HI_STD_BON',p_business_group_id,l_legislation_code);
66: g_earn_sj_hi_prem_iv_id := pay_jp_balance_pkg.get_input_value_id(g_bon_hi_std_prem_elm_id,'ERN_MONEY');
67: g_earn_kind_sj_hi_prem_iv_id := pay_jp_balance_pkg.get_input_value_id(g_bon_hi_std_prem_elm_id,'ERN_KIND');
68: g_bon_wp_std_prem_elm_id := pay_jp_balance_pkg.get_element_type_id('BON_WP_STD_BON',p_business_group_id,l_legislation_code);

Line 65: g_bon_hi_std_prem_elm_id := pay_jp_balance_pkg.get_element_type_id('BON_HI_STD_BON',p_business_group_id,l_legislation_code);

61: g_wpf_qualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'QUALIFY_DATE');
62: g_wpf_disqualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_DATE');
63: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_INFO',p_business_group_id,l_legislation_code);
64: g_si_sex_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SI_SEX');
65: g_bon_hi_std_prem_elm_id := pay_jp_balance_pkg.get_element_type_id('BON_HI_STD_BON',p_business_group_id,l_legislation_code);
66: g_earn_sj_hi_prem_iv_id := pay_jp_balance_pkg.get_input_value_id(g_bon_hi_std_prem_elm_id,'ERN_MONEY');
67: g_earn_kind_sj_hi_prem_iv_id := pay_jp_balance_pkg.get_input_value_id(g_bon_hi_std_prem_elm_id,'ERN_KIND');
68: g_bon_wp_std_prem_elm_id := pay_jp_balance_pkg.get_element_type_id('BON_WP_STD_BON',p_business_group_id,l_legislation_code);
69: g_earn_sj_wp_prem_iv_id := pay_jp_balance_pkg.get_input_value_id(g_bon_wp_std_prem_elm_id,'ERN_MONEY');

Line 66: g_earn_sj_hi_prem_iv_id := pay_jp_balance_pkg.get_input_value_id(g_bon_hi_std_prem_elm_id,'ERN_MONEY');

62: g_wpf_disqualified_date_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'DISQUALIFY_DATE');
63: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_INFO',p_business_group_id,l_legislation_code);
64: g_si_sex_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SI_SEX');
65: g_bon_hi_std_prem_elm_id := pay_jp_balance_pkg.get_element_type_id('BON_HI_STD_BON',p_business_group_id,l_legislation_code);
66: g_earn_sj_hi_prem_iv_id := pay_jp_balance_pkg.get_input_value_id(g_bon_hi_std_prem_elm_id,'ERN_MONEY');
67: g_earn_kind_sj_hi_prem_iv_id := pay_jp_balance_pkg.get_input_value_id(g_bon_hi_std_prem_elm_id,'ERN_KIND');
68: g_bon_wp_std_prem_elm_id := pay_jp_balance_pkg.get_element_type_id('BON_WP_STD_BON',p_business_group_id,l_legislation_code);
69: g_earn_sj_wp_prem_iv_id := pay_jp_balance_pkg.get_input_value_id(g_bon_wp_std_prem_elm_id,'ERN_MONEY');
70: g_earn_kind_sj_wp_prem_iv_id := pay_jp_balance_pkg.get_input_value_id(g_bon_wp_std_prem_elm_id,'ERN_KIND');

Line 67: g_earn_kind_sj_hi_prem_iv_id := pay_jp_balance_pkg.get_input_value_id(g_bon_hi_std_prem_elm_id,'ERN_KIND');

63: l_element_type_id := pay_jp_balance_pkg.get_element_type_id('COM_SI_INFO',p_business_group_id,l_legislation_code);
64: g_si_sex_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SI_SEX');
65: g_bon_hi_std_prem_elm_id := pay_jp_balance_pkg.get_element_type_id('BON_HI_STD_BON',p_business_group_id,l_legislation_code);
66: g_earn_sj_hi_prem_iv_id := pay_jp_balance_pkg.get_input_value_id(g_bon_hi_std_prem_elm_id,'ERN_MONEY');
67: g_earn_kind_sj_hi_prem_iv_id := pay_jp_balance_pkg.get_input_value_id(g_bon_hi_std_prem_elm_id,'ERN_KIND');
68: g_bon_wp_std_prem_elm_id := pay_jp_balance_pkg.get_element_type_id('BON_WP_STD_BON',p_business_group_id,l_legislation_code);
69: g_earn_sj_wp_prem_iv_id := pay_jp_balance_pkg.get_input_value_id(g_bon_wp_std_prem_elm_id,'ERN_MONEY');
70: g_earn_kind_sj_wp_prem_iv_id := pay_jp_balance_pkg.get_input_value_id(g_bon_wp_std_prem_elm_id,'ERN_KIND');
71: return (TRUE);

Line 68: g_bon_wp_std_prem_elm_id := pay_jp_balance_pkg.get_element_type_id('BON_WP_STD_BON',p_business_group_id,l_legislation_code);

64: g_si_sex_iv_id := pay_jp_balance_pkg.get_input_value_id(l_element_type_id,'SI_SEX');
65: g_bon_hi_std_prem_elm_id := pay_jp_balance_pkg.get_element_type_id('BON_HI_STD_BON',p_business_group_id,l_legislation_code);
66: g_earn_sj_hi_prem_iv_id := pay_jp_balance_pkg.get_input_value_id(g_bon_hi_std_prem_elm_id,'ERN_MONEY');
67: g_earn_kind_sj_hi_prem_iv_id := pay_jp_balance_pkg.get_input_value_id(g_bon_hi_std_prem_elm_id,'ERN_KIND');
68: g_bon_wp_std_prem_elm_id := pay_jp_balance_pkg.get_element_type_id('BON_WP_STD_BON',p_business_group_id,l_legislation_code);
69: g_earn_sj_wp_prem_iv_id := pay_jp_balance_pkg.get_input_value_id(g_bon_wp_std_prem_elm_id,'ERN_MONEY');
70: g_earn_kind_sj_wp_prem_iv_id := pay_jp_balance_pkg.get_input_value_id(g_bon_wp_std_prem_elm_id,'ERN_KIND');
71: return (TRUE);
72: end;

Line 69: g_earn_sj_wp_prem_iv_id := pay_jp_balance_pkg.get_input_value_id(g_bon_wp_std_prem_elm_id,'ERN_MONEY');

65: g_bon_hi_std_prem_elm_id := pay_jp_balance_pkg.get_element_type_id('BON_HI_STD_BON',p_business_group_id,l_legislation_code);
66: g_earn_sj_hi_prem_iv_id := pay_jp_balance_pkg.get_input_value_id(g_bon_hi_std_prem_elm_id,'ERN_MONEY');
67: g_earn_kind_sj_hi_prem_iv_id := pay_jp_balance_pkg.get_input_value_id(g_bon_hi_std_prem_elm_id,'ERN_KIND');
68: g_bon_wp_std_prem_elm_id := pay_jp_balance_pkg.get_element_type_id('BON_WP_STD_BON',p_business_group_id,l_legislation_code);
69: g_earn_sj_wp_prem_iv_id := pay_jp_balance_pkg.get_input_value_id(g_bon_wp_std_prem_elm_id,'ERN_MONEY');
70: g_earn_kind_sj_wp_prem_iv_id := pay_jp_balance_pkg.get_input_value_id(g_bon_wp_std_prem_elm_id,'ERN_KIND');
71: return (TRUE);
72: end;
73:

Line 70: g_earn_kind_sj_wp_prem_iv_id := pay_jp_balance_pkg.get_input_value_id(g_bon_wp_std_prem_elm_id,'ERN_KIND');

66: g_earn_sj_hi_prem_iv_id := pay_jp_balance_pkg.get_input_value_id(g_bon_hi_std_prem_elm_id,'ERN_MONEY');
67: g_earn_kind_sj_hi_prem_iv_id := pay_jp_balance_pkg.get_input_value_id(g_bon_hi_std_prem_elm_id,'ERN_KIND');
68: g_bon_wp_std_prem_elm_id := pay_jp_balance_pkg.get_element_type_id('BON_WP_STD_BON',p_business_group_id,l_legislation_code);
69: g_earn_sj_wp_prem_iv_id := pay_jp_balance_pkg.get_input_value_id(g_bon_wp_std_prem_elm_id,'ERN_MONEY');
70: g_earn_kind_sj_wp_prem_iv_id := pay_jp_balance_pkg.get_input_value_id(g_bon_wp_std_prem_elm_id,'ERN_KIND');
71: return (TRUE);
72: end;
73:
74: function cf_dataformula(sort_order in varchar2, si_type in number,date_of_birth in date,

Line 141: l_bon_comp := pay_jp_balance_pkg.get_result_value_number(g_bon_hi_std_prem_elm_id,g_earn_sj_hi_prem_iv_id,assignment_action_id);

137: cp_bon_payment_date_yymmdd := null;
138: end if;
139:
140: if sort_order = 'HI_NUMBER' then
141: l_bon_comp := pay_jp_balance_pkg.get_result_value_number(g_bon_hi_std_prem_elm_id,g_earn_sj_hi_prem_iv_id,assignment_action_id);
142: l_bon_mtr_comp := pay_jp_balance_pkg.get_result_value_number(g_bon_hi_std_prem_elm_id,g_earn_kind_sj_hi_prem_iv_id,assignment_action_id);
143: else
144: l_bon_comp := pay_jp_balance_pkg.get_result_value_number(g_bon_wp_std_prem_elm_id,g_earn_sj_wp_prem_iv_id,assignment_action_id);
145: l_bon_mtr_comp := pay_jp_balance_pkg.get_result_value_number(g_bon_wp_std_prem_elm_id,g_earn_kind_sj_wp_prem_iv_id,assignment_action_id);

Line 142: l_bon_mtr_comp := pay_jp_balance_pkg.get_result_value_number(g_bon_hi_std_prem_elm_id,g_earn_kind_sj_hi_prem_iv_id,assignment_action_id);

138: end if;
139:
140: if sort_order = 'HI_NUMBER' then
141: l_bon_comp := pay_jp_balance_pkg.get_result_value_number(g_bon_hi_std_prem_elm_id,g_earn_sj_hi_prem_iv_id,assignment_action_id);
142: l_bon_mtr_comp := pay_jp_balance_pkg.get_result_value_number(g_bon_hi_std_prem_elm_id,g_earn_kind_sj_hi_prem_iv_id,assignment_action_id);
143: else
144: l_bon_comp := pay_jp_balance_pkg.get_result_value_number(g_bon_wp_std_prem_elm_id,g_earn_sj_wp_prem_iv_id,assignment_action_id);
145: l_bon_mtr_comp := pay_jp_balance_pkg.get_result_value_number(g_bon_wp_std_prem_elm_id,g_earn_kind_sj_wp_prem_iv_id,assignment_action_id);
146: end if;

Line 144: l_bon_comp := pay_jp_balance_pkg.get_result_value_number(g_bon_wp_std_prem_elm_id,g_earn_sj_wp_prem_iv_id,assignment_action_id);

140: if sort_order = 'HI_NUMBER' then
141: l_bon_comp := pay_jp_balance_pkg.get_result_value_number(g_bon_hi_std_prem_elm_id,g_earn_sj_hi_prem_iv_id,assignment_action_id);
142: l_bon_mtr_comp := pay_jp_balance_pkg.get_result_value_number(g_bon_hi_std_prem_elm_id,g_earn_kind_sj_hi_prem_iv_id,assignment_action_id);
143: else
144: l_bon_comp := pay_jp_balance_pkg.get_result_value_number(g_bon_wp_std_prem_elm_id,g_earn_sj_wp_prem_iv_id,assignment_action_id);
145: l_bon_mtr_comp := pay_jp_balance_pkg.get_result_value_number(g_bon_wp_std_prem_elm_id,g_earn_kind_sj_wp_prem_iv_id,assignment_action_id);
146: end if;
147: cp_bon_comp := to_char(l_bon_comp);
148: cp_bon_mtr_comp := to_char(l_bon_mtr_comp);

Line 145: l_bon_mtr_comp := pay_jp_balance_pkg.get_result_value_number(g_bon_wp_std_prem_elm_id,g_earn_kind_sj_wp_prem_iv_id,assignment_action_id);

141: l_bon_comp := pay_jp_balance_pkg.get_result_value_number(g_bon_hi_std_prem_elm_id,g_earn_sj_hi_prem_iv_id,assignment_action_id);
142: l_bon_mtr_comp := pay_jp_balance_pkg.get_result_value_number(g_bon_hi_std_prem_elm_id,g_earn_kind_sj_hi_prem_iv_id,assignment_action_id);
143: else
144: l_bon_comp := pay_jp_balance_pkg.get_result_value_number(g_bon_wp_std_prem_elm_id,g_earn_sj_wp_prem_iv_id,assignment_action_id);
145: l_bon_mtr_comp := pay_jp_balance_pkg.get_result_value_number(g_bon_wp_std_prem_elm_id,g_earn_kind_sj_wp_prem_iv_id,assignment_action_id);
146: end if;
147: cp_bon_comp := to_char(l_bon_comp);
148: cp_bon_mtr_comp := to_char(l_bon_mtr_comp);
149:

Line 158: cp_si_sex_code := pay_jp_balance_pkg.get_entry_value_char(g_si_sex_iv_id,assignment_id,effective_date);

154: else
155: cp_d_bon_comp_total := to_char(floor(l_bon_comp_total/1000));
156: end if;
157:
158: cp_si_sex_code := pay_jp_balance_pkg.get_entry_value_char(g_si_sex_iv_id,assignment_id,effective_date);
159:
160: cp_full_name := last_name||' '||first_name;
161:
162:

Line 172: l_legislation_code := pay_jp_balance_pkg.get_legislation_code(p_business_group_id);

168: function AfterPForm return boolean is
169: l_where_clause_for_assid varchar2(150);
170: l_legislation_code per_business_groups_perf.legislation_code%type;
171: begin
172: l_legislation_code := pay_jp_balance_pkg.get_legislation_code(p_business_group_id);
173:
174: l_where_clause_for_assid := pay_jp_report_pkg.get_concatenated_numbers(
175: to_number(p_assignment_id1),
176: to_number(p_assignment_id2),

Line 198: l_qualified_date := pay_jp_balance_pkg.get_entry_value_date(p_qualified_date_iv_id,assignment_id,effective_date);

194: l_disqualified_date date;
195:
196: begin
197:
198: l_qualified_date := pay_jp_balance_pkg.get_entry_value_date(p_qualified_date_iv_id,assignment_id,effective_date);
199: l_disqualified_date := pay_jp_balance_pkg.get_entry_value_date(p_disqualified_date_iv_id,assignment_id,effective_date);
200:
201: if l_qualified_date is null then
202: if l_disqualified_date is null then

Line 199: l_disqualified_date := pay_jp_balance_pkg.get_entry_value_date(p_disqualified_date_iv_id,assignment_id,effective_date);

195:
196: begin
197:
198: l_qualified_date := pay_jp_balance_pkg.get_entry_value_date(p_qualified_date_iv_id,assignment_id,effective_date);
199: l_disqualified_date := pay_jp_balance_pkg.get_entry_value_date(p_disqualified_date_iv_id,assignment_id,effective_date);
200:
201: if l_qualified_date is null then
202: if l_disqualified_date is null then
203: l_qualified_date := g_eot;