APPS.PAY_ISB_BUS dependencies on PAY_IE_SOCIAL_BENEFITS_F

Line 24: from pay_ie_social_benefits_f isb

20: p_absence_start_date date,
21: p_absence_end_date date) is
22: cursor c_absence_dates is
23: select social_benefit_id
24: from pay_ie_social_benefits_f isb
25: where isb.assignment_id = p_assignment_id
26: and (p_absence_start_date
27: between isb.absence_start_date and isb.absence_end_date
28: or p_absence_end_date

Line 50: procedure chk_calculation_option(p_calculation_option in pay_ie_social_benefits_f.calculation_option%type) is

46: --
47: -- ----------------------------------------------------------------------------
48: -- |------------------------< chk_calculation_option >------------------------|
49: -- ----------------------------------------------------------------------------
50: procedure chk_calculation_option(p_calculation_option in pay_ie_social_benefits_f.calculation_option%type) is
51: cursor c_calculation_option is
52: select 1
53: from hr_lookups
54: where lookup_type = 'IE_CALC_OPTION'

Line 77: procedure chk_benefit_type(p_benefit_type in pay_ie_social_benefits_f.benefit_type%type) is

73: --
74: -- ----------------------------------------------------------------------------
75: -- |---------------------------< chk_benefit_type >---------------------------|
76: -- ----------------------------------------------------------------------------
77: procedure chk_benefit_type(p_benefit_type in pay_ie_social_benefits_f.benefit_type%type) is
78: cursor c_benefit_type is
79: select 1
80: from hr_lookups
81: where lookup_type = 'IE_BENEFIT_TYPE'

Line 205: function get_payroll_period_type(p_assignment_id pay_ie_social_benefits_f.assignment_id%type)

201: -- ----------------------------------------------------------------------------
202: -- |----------------------< get_payroll_period_type >-------------------------|
203: -- ----------------------------------------------------------------------------
204: --
205: function get_payroll_period_type(p_assignment_id pay_ie_social_benefits_f.assignment_id%type)
206: return varchar2 is
207: cursor c_payroll_period_type is
208: select pay.period_type period_type
209: from per_all_assignments_f asg,

Line 238: , pay_ie_social_benefits_f isb

234: --
235: cursor csr_sec_grp is
236: select pbg.security_group_id
237: from per_business_groups pbg
238: , pay_ie_social_benefits_f isb
239: , per_all_assignments_f paf
240: where isb.social_benefit_id = p_social_benefit_id
241: and pbg.business_group_id = paf.business_group_id
242: and isb.assignment_id = paf.assignment_id;

Line 300: , pay_ie_social_benefits_f isb

296: --
297: cursor csr_leg_code is
298: select pbg.legislation_code
299: from per_business_groups pbg
300: , pay_ie_social_benefits_f isb
301: , per_all_assignments_f paf
302: where isb.social_benefit_id = p_social_benefit_id
303: and pbg.business_group_id = paf.business_group_id
304: and paf.assignment_id = isb.assignment_id;