APPS.PAY_IE_BIK dependencies on PAY_IE_BIK

Line 1: package BODY pay_ie_bik as

1: package BODY pay_ie_bik as
2: /* $Header: pyiebik.pkb 120.2.12010000.3 2009/04/03 08:05:07 abraghun ship $ */
3:
4: /* This function is used to fetch the specified interest rates for various type
5: of loans given, which are defined as globals.*/

Line 21: l_proc varchar2(72) := 'pay_ie_bik.get_global_value';

17:
18: l_global_value ff_globals_f.global_value%type;
19: l_effective_start_date DATE;
20: l_effective_end_date date;
21: l_proc varchar2(72) := 'pay_ie_bik.get_global_value';
22:
23: BEGIN
24: hr_utility.set_location('Entering ' || l_proc, 20);
25: open c_global_value_cursor;

Line 55: l_proc varchar2(72) := 'pay_ie_bik.get_max_start_date';

51: and to_char(PACTION.DATE_EARNED,'YYYY')=to_char(TPERIOD.END_DATE,'YYYY');
52:
53: l_max_start_date DATE;
54: l_first_period_start_date DATE;
55: l_proc varchar2(72) := 'pay_ie_bik.get_max_start_date';
56:
57: BEGIN
58:
59: hr_utility.set_location('Entering ' || l_proc, 20);

Line 95: l_proc varchar2(72) := 'pay_ie_bik.get_least_date';

91: AND ppa.DATE_EARNED between ptp.start_date and ptp.end_date;
92:
93: l_least_date date;
94: l_least date;
95: l_proc varchar2(72) := 'pay_ie_bik.get_least_date';
96: begin
97: open csr_least_date;
98: fetch csr_least_date into l_least_date;
99: close csr_least_date;

Line 156: c_maximum_start_date and pay_ie_bik.get_least_date(p_payroll_action_id,

152: WHERE ppa.payroll_action_id=p_payroll_action_id
153: AND ptp.payroll_id=ppa.payroll_id
154: AND ptp.period_type = tptype.period_type
155: AND ptp.end_date between
156: c_maximum_start_date and pay_ie_bik.get_least_date(p_payroll_action_id,
157: c_end_date);
158:
159:
160: l_proc varchar2(72) := 'pay_ie_bik.get_max_no_of_periods';

Line 160: l_proc varchar2(72) := 'pay_ie_bik.get_max_no_of_periods';

156: c_maximum_start_date and pay_ie_bik.get_least_date(p_payroll_action_id,
157: c_end_date);
158:
159:
160: l_proc varchar2(72) := 'pay_ie_bik.get_max_no_of_periods';
161: l_periods get_periods%rowtype;
162: l_cumulative_periods get_cumulative_periods%rowtype;
163: --l_end_date get_end_date%rowtype;
164: l_end_date date;

Line 235: l_proc varchar2(72) := 'pay_ie_bik.get_balance_values';

231: and pbd.dimension_name='_ELEMENT_YTD'
232: and pbd.legislation_code='IE';
233:
234: l_get_values csr_get_values%rowtype;
235: l_proc varchar2(72) := 'pay_ie_bik.get_balance_values';
236:
237: begin
238: hr_utility.set_location('Entering ' || l_proc, 20);
239:

Line 266: l_proc varchar2(72) := 'pay_ie_bik.get_address';

262: type l_address_refcur_type is ref
263:
264: cursor return l_address_rec;
265: l_address_refcur l_address_refcur_type;
266: l_proc varchar2(72) := 'pay_ie_bik.get_address';
267: begin
268: hr_utility.set_location('Entering ' || l_proc, 20);
269: if l_address_type='address_line1' then
270: open l_address_refcur for select address_line1

Line 322: l_proc varchar2(72) := 'pay_ie_bik.get_landlord_address';

318:
319: type l_landlord_refcur_type is ref cursor return l_landlord_rec;
320: l_landlord_refcur l_landlord_refcur_type;
321:
322: l_proc varchar2(72) := 'pay_ie_bik.get_landlord_address';
323: begin
324:
325: hr_utility.set_location('Entering ' || l_proc, 20);
326:

Line 581: end pay_ie_bik;

577: RETURN rating;
578: end get_fiscal_rating;
579:
580:
581: end pay_ie_bik;