APPS.PAY_PAYJPSMT_XMLP_PKG dependencies on PAY_JP_REPORT_PKG

Line 74: pay_jp_report_pkg.to_era( to_date(to_char(P_DATE_EARNED,'YYYY') || '1001','YYYYMMDD'),

70:
71: G_SANTEI_GEPPEN_MTH_ELM_ID := pay_jp_balance_pkg.get_element_type_id('SAN_GEP_MTH_RSLT',P_BUSINESS_GROUP_ID,l_legislation_code);
72: G_KOUNEN_MTH_IV_ID := pay_jp_balance_pkg.get_input_value_id(G_SANTEI_GEPPEN_MTH_ELM_ID,'WP');
73: IF P_DATE_EARNED < TO_DATE('2003/04/01', 'YYYY/MM/DD') THEN
74: pay_jp_report_pkg.to_era( to_date(to_char(P_DATE_EARNED,'YYYY') || '1001','YYYYMMDD'),
75: l_date_era_code,
76: l_date_year,
77: l_date_month,
78: l_date_day);

Line 80: pay_jp_report_pkg.to_era( to_date(to_char(P_DATE_EARNED,'YYYY') || '0901','YYYYMMDD'),

76: l_date_year,
77: l_date_month,
78: l_date_day);
79: elsif p_date_earned >= TO_DATE('2003/04/01', 'YYYY/MM/DD') THEN
80: pay_jp_report_pkg.to_era( to_date(to_char(P_DATE_EARNED,'YYYY') || '0901','YYYYMMDD'),
81: l_date_era_code,
82: l_date_year,
83: l_date_month,
84: l_date_day);

Line 93: G_WP_MAX_STD_COMP := pay_jp_report_pkg.get_max_value('T_COM_SMR','WP_SMR',l_apply_date);

89: l_apply_date := to_date(to_char(P_DATE_EARNED,'YYYY') || '1001','YYYYMMDD');
90: elsif p_date_earned >= TO_DATE('2003/04/01', 'YYYY/MM/DD') THEN
91: l_apply_date := to_date(to_char(P_DATE_EARNED,'YYYY') || '0901','YYYYMMDD');
92: end if;
93: G_WP_MAX_STD_COMP := pay_jp_report_pkg.get_max_value('T_COM_SMR','WP_SMR',l_apply_date);
94: G_WP_MIN_STD_COMP := pay_jp_report_pkg.get_min_value('T_COM_SMR','WP_SMR',l_apply_date);
95: --file_io.open_magfile;
96:
97: return (TRUE);

Line 94: G_WP_MIN_STD_COMP := pay_jp_report_pkg.get_min_value('T_COM_SMR','WP_SMR',l_apply_date);

90: elsif p_date_earned >= TO_DATE('2003/04/01', 'YYYY/MM/DD') THEN
91: l_apply_date := to_date(to_char(P_DATE_EARNED,'YYYY') || '0901','YYYYMMDD');
92: end if;
93: G_WP_MAX_STD_COMP := pay_jp_report_pkg.get_max_value('T_COM_SMR','WP_SMR',l_apply_date);
94: G_WP_MIN_STD_COMP := pay_jp_report_pkg.get_min_value('T_COM_SMR','WP_SMR',l_apply_date);
95: --file_io.open_magfile;
96:
97: return (TRUE);
98: end;