APPS.PAY_CA_YEER_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 334: from PER_ALL_ASSIGNMENTS_F paf,

330: begin
331:
332: select count( distinct lkp.meaning )
333: into l_multi_jd
334: from PER_ALL_ASSIGNMENTS_F paf,
335: HR_LOCATIONS_ALL hrl,
336: HR_LOOKUPS lkp
337: where paf.person_id = p_person_id
338: and sv_reporting_year between

Line 2998: from per_all_assignments_f paaf,

2994: cursor cur_rl_qpp_block (cp_bg_id in number,
2995: cp_person_id in number,
2996: cp_effective_date in date ) is
2997: select qpp_exempt_flag
2998: from per_all_assignments_f paaf,
2999: pay_ca_emp_prov_tax_info_f pcefti
3000: where paaf.person_id = cp_person_id
3001: and to_char(cp_effective_date,'YYYY') between
3002: to_char(paaf.effective_start_date,'YYYY') and

Line 3018: from per_all_assignments_f paaf,

3014: cursor cur_rl_qpip_block (cp_bg_id in number,
3015: cp_person_id in number,
3016: cp_effective_date in date ) is
3017: select ppip_exempt_flag
3018: from per_all_assignments_f paaf,
3019: pay_ca_emp_prov_tax_info_f pcefti
3020: where paaf.person_id = cp_person_id
3021: and to_char(cp_effective_date,'YYYY') between
3022: to_char(paaf.effective_start_date,'YYYY') and

Line 3033: from per_all_assignments_f paf,

3029: and pcefti.ppip_exempt_flag = 'Y';
3030:
3031: cursor cur_rl_tax_unit_id( cp_asg_id in number ) is
3032: select nvl(hsck.segment1, hsck.segment11)
3033: from per_all_assignments_f paf,
3034: hr_soft_coding_keyflex hsck
3035: where paf.assignment_id = cp_asg_id
3036: and add_months(trunc(to_date(sv_reporting_year,'YYYY'),'Y'),12)-1 between
3037: paf.effective_start_date and paf.effective_end_date

Line 3459: from per_all_assignments_f paaf, pay_ca_emp_fed_tax_info_f pcefti

3455: cursor cur_cpp_block ( cp_bg_id in number,
3456: cp_person_id in number,
3457: cp_effective_date in date ) is
3458: select cpp_qpp_exempt_flag
3459: from per_all_assignments_f paaf, pay_ca_emp_fed_tax_info_f pcefti
3460: where paaf.person_id = cp_person_id
3461: and to_char(cp_effective_date,'YYYY') between
3462: to_char(paaf.effective_start_date,'YYYY') and
3463: to_char(paaf.effective_end_date, 'YYYY' )

Line 3478: from per_all_assignments_f paaf, pay_ca_emp_fed_tax_info_f pcefti

3474: cursor cur_ei_block ( cp_bg_id in number,
3475: cp_person_id in number,
3476: cp_effective_date in date ) is
3477: select ei_exempt_flag
3478: from per_all_assignments_f paaf, pay_ca_emp_fed_tax_info_f pcefti
3479: where paaf.person_id = cp_person_id
3480: and to_char(cp_effective_date,'YYYY') between
3481: to_char(paaf.effective_start_date,'YYYY') and
3482: to_char(paaf.effective_end_date, 'YYYY' )