APPS.PAY_ES_CALC_SS_EARNINGS dependencies on PAY_BALANCE_PKG

Line 165: l_Days := pay_balance_pkg.get_value(l_def_bal_id,p_assignment_id,p_virtal_date);

161: --
162: BEGIN
163: l_def_bal_id := get_defined_bal_id(p_balance_name, p_database_item_suffix);
164: BEGIN
165: l_Days := pay_balance_pkg.get_value(l_def_bal_id,p_assignment_id,p_virtal_date);
166: EXCEPTION
167: WHEN no_data_found THEN
168: l_Days := 0;
169: END;

Line 175: l_span_days := pay_balance_pkg.get_value(l_def_bal_id,p_assignment_id,l_span_back_date);

171: l_ne_span := p_span_years * 12;
172: l_span_back_date := ADD_MONTHS(p_virtal_date, -1 * FLOOR(l_ne_span)) - ( l_ne_span - FLOOR(l_ne_span)) * 30 + 1;
173: --
174: BEGIN
175: l_span_days := pay_balance_pkg.get_value(l_def_bal_id,p_assignment_id,l_span_back_date);
176: EXCEPTION
177: WHEN no_data_found THEN
178: l_span_days := 0;
179: END;

Line 1164: l_Contri_Base_PU := pay_balance_pkg.get_value(l_def_bal_id_PU, p_assignment_id, p_PU_start_date);

1160: l_prev_date := to_date('01-01-0001','dd-mm-yyyy');
1161: l_amt := 0;
1162: --
1163: BEGIN
1164: l_Contri_Base_PU := pay_balance_pkg.get_value(l_def_bal_id_PU, p_assignment_id, p_PU_start_date);
1165: EXCEPTION
1166: WHEN no_data_found THEN
1167: l_Contri_Base_PU := 0;
1168: END;

Line 1176: p_ss_days := p_ss_days + pay_balance_pkg.get_value (l_def_bal_id_SS, i.assignment_action_id);

1172: IF l_prev_date <> i.start_date THEN
1173: --
1174: l_num := l_num + 1;
1175: IF l_ctr = 0 THEN
1176: p_ss_days := p_ss_days + pay_balance_pkg.get_value (l_def_bal_id_SS, i.assignment_action_id);
1177: END IF;
1178: --
1179: IF p_span_days <= p_ss_days THEN
1180: --

Line 1182: l_Contri_Base_180 := pay_balance_pkg.get_value (l_def_bal_id_PU,i.assignment_action_id);-- p_assignment_id, i.start_date);

1178: --
1179: IF p_span_days <= p_ss_days THEN
1180: --
1181: BEGIN
1182: l_Contri_Base_180 := pay_balance_pkg.get_value (l_def_bal_id_PU,i.assignment_action_id);-- p_assignment_id, i.start_date);
1183: EXCEPTION
1184: WHEN no_data_found THEN
1185: l_Contri_Base_180 := 0;
1186: END;