43: begin
44: --
45: if g_business_group_id is null or p_business_group_id <> g_business_group_id then
46: g_business_group_id := p_business_group_id;
47: g_legislation_code := pay_kr_report_pkg.legislation_code(p_business_group_id);
48: end if;
49: --
50: if p_balance_type_id is null then
51: open csr_balance;
71: begin
72: --
73: if g_business_group_id is null or p_business_group_id <> g_business_group_id then
74: g_business_group_id := p_business_group_id;
75: g_legislation_code := pay_kr_report_pkg.legislation_code(p_business_group_id);
76: end if;
77: --
78: if p_user_entity_id is null then
79: open csr_user_entity;
108: -- get_balance_type_id('RTAX_WO_ADJ',p_business_group_id,g_rtax_wo_adj_bal_id);
109: -- get_balance_type_id('STAX',p_business_group_id,g_stax_bal_id);
110: -- get_balance_type_id('STAX_WO_ADJ',p_business_group_id,g_stax_wo_adj_bal_id);
111: ----
112: -- l_itax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_itax_bal_id);
113: -- l_itax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_itax_wo_adj_bal_id);
114: -- l_rtax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_rtax_bal_id);
115: -- l_rtax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_rtax_wo_adj_bal_id);
116: -- l_stax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_stax_bal_id);
109: -- get_balance_type_id('STAX',p_business_group_id,g_stax_bal_id);
110: -- get_balance_type_id('STAX_WO_ADJ',p_business_group_id,g_stax_wo_adj_bal_id);
111: ----
112: -- l_itax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_itax_bal_id);
113: -- l_itax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_itax_wo_adj_bal_id);
114: -- l_rtax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_rtax_bal_id);
115: -- l_rtax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_rtax_wo_adj_bal_id);
116: -- l_stax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_stax_bal_id);
117: -- l_stax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_stax_wo_adj_bal_id);
110: -- get_balance_type_id('STAX_WO_ADJ',p_business_group_id,g_stax_wo_adj_bal_id);
111: ----
112: -- l_itax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_itax_bal_id);
113: -- l_itax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_itax_wo_adj_bal_id);
114: -- l_rtax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_rtax_bal_id);
115: -- l_rtax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_rtax_wo_adj_bal_id);
116: -- l_stax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_stax_bal_id);
117: -- l_stax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_stax_wo_adj_bal_id);
118: ----
111: ----
112: -- l_itax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_itax_bal_id);
113: -- l_itax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_itax_wo_adj_bal_id);
114: -- l_rtax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_rtax_bal_id);
115: -- l_rtax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_rtax_wo_adj_bal_id);
116: -- l_stax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_stax_bal_id);
117: -- l_stax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_stax_wo_adj_bal_id);
118: ----
119: -- p_itax_adj := l_itax - l_itax_wo_adj;
112: -- l_itax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_itax_bal_id);
113: -- l_itax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_itax_wo_adj_bal_id);
114: -- l_rtax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_rtax_bal_id);
115: -- l_rtax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_rtax_wo_adj_bal_id);
116: -- l_stax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_stax_bal_id);
117: -- l_stax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_stax_wo_adj_bal_id);
118: ----
119: -- p_itax_adj := l_itax - l_itax_wo_adj;
120: -- p_rtax_adj := l_rtax - l_rtax_wo_adj;
113: -- l_itax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_itax_wo_adj_bal_id);
114: -- l_rtax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_rtax_bal_id);
115: -- l_rtax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_rtax_wo_adj_bal_id);
116: -- l_stax := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_stax_bal_id);
117: -- l_stax_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_stax_wo_adj_bal_id);
118: ----
119: -- p_itax_adj := l_itax - l_itax_wo_adj;
120: -- p_rtax_adj := l_rtax - l_rtax_wo_adj;
121: -- p_stax_adj := l_stax - l_stax_wo_adj;
124: get_user_entity_id('X_YEA_ITAX_ADJ',p_business_group_id,g_itax_ue_id);
125: get_user_entity_id('X_YEA_RTAX_ADJ',p_business_group_id,g_rtax_ue_id);
126: get_user_entity_id('X_YEA_STAX_ADJ',p_business_group_id,g_stax_ue_id);
127: --
128: p_itax_adj := fnd_number.canonical_to_number(pay_kr_report_pkg.get_archive_items(p_assignment_action_id,g_itax_ue_id));
129: p_rtax_adj := fnd_number.canonical_to_number(pay_kr_report_pkg.get_archive_items(p_assignment_action_id,g_rtax_ue_id));
130: p_stax_adj := fnd_number.canonical_to_number(pay_kr_report_pkg.get_archive_items(p_assignment_action_id,g_stax_ue_id));
131: --
132: return l_dummy;
125: get_user_entity_id('X_YEA_RTAX_ADJ',p_business_group_id,g_rtax_ue_id);
126: get_user_entity_id('X_YEA_STAX_ADJ',p_business_group_id,g_stax_ue_id);
127: --
128: p_itax_adj := fnd_number.canonical_to_number(pay_kr_report_pkg.get_archive_items(p_assignment_action_id,g_itax_ue_id));
129: p_rtax_adj := fnd_number.canonical_to_number(pay_kr_report_pkg.get_archive_items(p_assignment_action_id,g_rtax_ue_id));
130: p_stax_adj := fnd_number.canonical_to_number(pay_kr_report_pkg.get_archive_items(p_assignment_action_id,g_stax_ue_id));
131: --
132: return l_dummy;
133: --
126: get_user_entity_id('X_YEA_STAX_ADJ',p_business_group_id,g_stax_ue_id);
127: --
128: p_itax_adj := fnd_number.canonical_to_number(pay_kr_report_pkg.get_archive_items(p_assignment_action_id,g_itax_ue_id));
129: p_rtax_adj := fnd_number.canonical_to_number(pay_kr_report_pkg.get_archive_items(p_assignment_action_id,g_rtax_ue_id));
130: p_stax_adj := fnd_number.canonical_to_number(pay_kr_report_pkg.get_archive_items(p_assignment_action_id,g_stax_ue_id));
131: --
132: return l_dummy;
133: --
134: end get_iyea_tax_adj;
154: -- get_balance_type_id('HI_PREM_EE_WO_ADJ',p_business_group_id,g_hi_prem_ee_wo_adj_bal_id);
155: -- get_balance_type_id('HI_PREM_ER',p_business_group_id,g_hi_prem_er_bal_id);
156: -- get_balance_type_id('HI_PREM_ER_WO_ADJ',p_business_group_id,g_hi_prem_er_wo_adj_bal_id);
157: ----
158: -- l_hi_prem_ee := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_ee_bal_id);
159: -- l_hi_prem_ee_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_ee_wo_adj_bal_id);
160: -- l_hi_prem_er := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_er_bal_id);
161: -- l_hi_prem_er_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_er_wo_adj_bal_id);
162: ----
155: -- get_balance_type_id('HI_PREM_ER',p_business_group_id,g_hi_prem_er_bal_id);
156: -- get_balance_type_id('HI_PREM_ER_WO_ADJ',p_business_group_id,g_hi_prem_er_wo_adj_bal_id);
157: ----
158: -- l_hi_prem_ee := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_ee_bal_id);
159: -- l_hi_prem_ee_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_ee_wo_adj_bal_id);
160: -- l_hi_prem_er := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_er_bal_id);
161: -- l_hi_prem_er_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_er_wo_adj_bal_id);
162: ----
163: -- p_hi_prem_ee_adj := l_hi_prem_ee - l_hi_prem_ee_wo_adj;
156: -- get_balance_type_id('HI_PREM_ER_WO_ADJ',p_business_group_id,g_hi_prem_er_wo_adj_bal_id);
157: ----
158: -- l_hi_prem_ee := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_ee_bal_id);
159: -- l_hi_prem_ee_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_ee_wo_adj_bal_id);
160: -- l_hi_prem_er := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_er_bal_id);
161: -- l_hi_prem_er_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_er_wo_adj_bal_id);
162: ----
163: -- p_hi_prem_ee_adj := l_hi_prem_ee - l_hi_prem_ee_wo_adj;
164: -- p_hi_prem_er_adj := l_hi_prem_er - l_hi_prem_er_wo_adj;
157: ----
158: -- l_hi_prem_ee := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_ee_bal_id);
159: -- l_hi_prem_ee_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_ee_wo_adj_bal_id);
160: -- l_hi_prem_er := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_er_bal_id);
161: -- l_hi_prem_er_wo_adj := pay_kr_report_pkg.get_balance_value_asg_run(p_assignment_action_id,g_hi_prem_er_wo_adj_bal_id);
162: ----
163: -- p_hi_prem_ee_adj := l_hi_prem_ee - l_hi_prem_ee_wo_adj;
164: -- p_hi_prem_er_adj := l_hi_prem_er - l_hi_prem_er_wo_adj;
165: */
166: --
167: get_user_entity_id('A_HEALTH_INS_SEP_ADJ_EMPLOYEE_CHARGE_ASG_YTD',p_business_group_id,g_hi_prem_ee_ue_id);
168: get_user_entity_id('A_HEALTH_INS_SEP_ADJ_EMPLOYER_CHARGE_ASG_YTD',p_business_group_id,g_hi_prem_er_ue_id);
169: --
170: p_hi_prem_ee_adj := fnd_number.canonical_to_number(pay_kr_report_pkg.get_archive_items(p_assignment_action_id,g_hi_prem_ee_ue_id));
171: p_hi_prem_er_adj := fnd_number.canonical_to_number(pay_kr_report_pkg.get_archive_items(p_assignment_action_id,g_hi_prem_er_ue_id));
172: --
173: return l_dummy;
174: --
167: get_user_entity_id('A_HEALTH_INS_SEP_ADJ_EMPLOYEE_CHARGE_ASG_YTD',p_business_group_id,g_hi_prem_ee_ue_id);
168: get_user_entity_id('A_HEALTH_INS_SEP_ADJ_EMPLOYER_CHARGE_ASG_YTD',p_business_group_id,g_hi_prem_er_ue_id);
169: --
170: p_hi_prem_ee_adj := fnd_number.canonical_to_number(pay_kr_report_pkg.get_archive_items(p_assignment_action_id,g_hi_prem_ee_ue_id));
171: p_hi_prem_er_adj := fnd_number.canonical_to_number(pay_kr_report_pkg.get_archive_items(p_assignment_action_id,g_hi_prem_er_ue_id));
172: --
173: return l_dummy;
174: --
175: end get_ihia_prem_adj;