eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_YEER_PKG dependencies on PAY_CA_EMP_FED_TAX_INFO_F

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' )