APPS.PAY_ISB_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 209: from per_all_assignments_f asg,

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,
210: pay_all_payrolls_f pay
211: where asg.payroll_id = pay.payroll_id
212: and asg.assignment_id = p_assignment_id;
213: l_period_type pay_all_payrolls.period_type%type;

Line 239: , per_all_assignments_f paf

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;
243: --

Line 301: , per_all_assignments_f paf

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;
305: --

Line 493: (p_base_table_name => 'per_all_assignments_f'

489: );
490: --
491: If ((nvl(p_assignment_id, hr_api.g_number) <> hr_api.g_number) and
492: NOT (dt_api.check_min_max_dates
493: (p_base_table_name => 'per_all_assignments_f'
494: ,p_base_key_column => 'ASSIGNMENT_ID'
495: ,p_base_key_value => p_assignment_id
496: ,p_from_date => p_validation_start_date
497: ,p_to_date => p_validation_end_date))) Then