APPS.PAY_CA_YEER_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 429: from PER_ALL_ASSIGNMENTS_F paf,

425: begin
426:
427: select count( distinct lkp.meaning )
428: into l_multi_jd
429: from PER_ALL_ASSIGNMENTS_F paf,
430: HR_LOCATIONS_ALL hrl,
431: HR_LOOKUPS lkp
432: where paf.person_id = p_person_id
433: and sv_reporting_year between

Line 3367: from per_all_assignments_f paaf,

3363: cursor cur_rl_qpp_block (cp_bg_id in number,
3364: cp_person_id in number,
3365: cp_effective_date in date ) is
3366: select qpp_exempt_flag
3367: from per_all_assignments_f paaf,
3368: pay_ca_emp_prov_tax_info_f pcefti
3369: where paaf.person_id = cp_person_id
3370: and to_char(cp_effective_date,'YYYY') between
3371: to_char(paaf.effective_start_date,'YYYY') and

Line 3387: from per_all_assignments_f paaf,

3383: cursor cur_rl_qpip_block (cp_bg_id in number,
3384: cp_person_id in number,
3385: cp_effective_date in date ) is
3386: select ppip_exempt_flag
3387: from per_all_assignments_f paaf,
3388: pay_ca_emp_prov_tax_info_f pcefti
3389: where paaf.person_id = cp_person_id
3390: and to_char(cp_effective_date,'YYYY') between
3391: to_char(paaf.effective_start_date,'YYYY') and

Line 3402: from per_all_assignments_f paf,

3398: and pcefti.ppip_exempt_flag = 'Y';
3399:
3400: cursor cur_rl_tax_unit_id( cp_asg_id in number ) is
3401: select nvl(hsck.segment1, hsck.segment11)
3402: from per_all_assignments_f paf,
3403: hr_soft_coding_keyflex hsck
3404: where paf.assignment_id = cp_asg_id
3405: and add_months(trunc(to_date(sv_reporting_year,'YYYY'),'Y'),12)-1 between
3406: paf.effective_start_date and paf.effective_end_date

Line 3924: from per_all_assignments_f paaf, pay_ca_emp_fed_tax_info_f pcefti

3920: cursor cur_cpp_block ( cp_bg_id in number,
3921: cp_person_id in number,
3922: cp_effective_date in date ) is
3923: select cpp_qpp_exempt_flag
3924: from per_all_assignments_f paaf, pay_ca_emp_fed_tax_info_f pcefti
3925: where paaf.person_id = cp_person_id
3926: and to_char(cp_effective_date,'YYYY') between
3927: to_char(paaf.effective_start_date,'YYYY') and
3928: to_char(paaf.effective_end_date, 'YYYY' )

Line 3943: from per_all_assignments_f paaf, pay_ca_emp_fed_tax_info_f pcefti

3939: cp_person_id in number,
3940: cp_effective_date in date ) is
3941: select distinct pcefti.CPP_ELECTION_DATE, /*Bug 13542043 sbachu*/
3942: pcefti.CPP_REVOCATION_DATE
3943: from per_all_assignments_f paaf, pay_ca_emp_fed_tax_info_f pcefti
3944: where paaf.person_id = cp_person_id
3945: and to_char(cp_effective_date,'YYYY') between
3946: to_char(paaf.effective_start_date,'YYYY') and
3947: to_char(paaf.effective_end_date, 'YYYY' )

Line 3970: from per_all_assignments_f paaf, pay_ca_emp_fed_tax_info_f pcefti

3966: cursor cur_ei_block ( cp_bg_id in number,
3967: cp_person_id in number,
3968: cp_effective_date in date ) is
3969: select ei_exempt_flag
3970: from per_all_assignments_f paaf, pay_ca_emp_fed_tax_info_f pcefti
3971: where paaf.person_id = cp_person_id
3972: and to_char(cp_effective_date,'YYYY') between
3973: to_char(paaf.effective_start_date,'YYYY') and
3974: to_char(paaf.effective_end_date, 'YYYY' )