APPS.PAY_CA_YEER_PKG dependencies on PER_ALL_PEOPLE_F

Line 178: per_all_people_f table.

174: 20-SEP-2012 sgotlasw 115.61 10163858 Fixed code to avoid displaying multiple headers
175: in the output.
176: 20-SEP-2012 sgotlasw 115.62 10316246 Modified cursor 'cur_asg_act' to avoid picking same
177: employee twice due to the multiple records in
178: per_all_people_f table.
179: 20-SEP-2012 sgotlasw 115.63 Replaced '!=' with '<>' to resolve GSCC errors.
180: 24-SEP-2012 sbachu 115.64 6773615 The message "Invalid Social Insurance Number" should
181: not be shown if employee has not been assigned any SIN.
182: 13542043 Modified cursor cur_cpp_date_block to avoid multiple

Line 186: per_all_people_f table.

182: 13542043 Modified cursor cur_cpp_date_block to avoid multiple
183: CPP Election Date or CPP Revocation Date messages
184: 24-SEP-2012 sbachu 115.65 10316246 Modified cursor 'cur_rl_asg_act' to avoid picking same
185: employee twice due to the multiple records in
186: per_all_people_f table.
187: 26-SEP-2012 sbachu 115.66 13542043 Modifed cursor cur_cpp_date_block so that it does
188: does not fetch the future year dates.
189: 27-SEP-2012 sgotlasw 115.67 4142751 Added Address line length validation when report
190: is run for RL2 PRE.

Line 3305: per_all_people_f ppf

3301: paa.serial_number person_id,
3302: paa.action_status
3303: from pay_assignment_actions paa,
3304: pay_payroll_actions ppa,
3305: per_all_people_f ppf
3306: where paa.payroll_action_id = cp_pactid
3307: and ppa.payroll_action_id = paa.payroll_action_id
3308: and ppa.business_group_id = fp_b_g_id
3309: and ppa.effective_date between ppf.effective_start_date /*10316246 sbachu*/

Line 3347: from per_all_people_f ppf

3343: cursor cur_rl_dob ( cp_person_id in number,
3344: cp_effective_date in date ) is
3345: select ppf.date_of_birth,
3346: ppf.original_date_of_hire
3347: from per_all_people_f ppf
3348: where ppf.person_id = cp_person_id
3349: and cp_effective_date between ppf.effective_start_date
3350: and ppf.effective_end_date;
3351:

Line 3859: per_all_people_f ppf

3855: paa.action_status,
3856: ppf.last_name,ppf.first_name,ppf.middle_names
3857: from pay_assignment_actions paa,
3858: pay_payroll_actions ppa,
3859: per_all_people_f ppf
3860: where paa.payroll_action_id = cp_pactid
3861: and ppa.payroll_action_id = paa.payroll_action_id
3862: and ppa.business_group_id = fp_b_g_id
3863: and ppa.effective_date between ppf.effective_start_date

Line 3904: from per_all_people_f ppf

3900: cursor cur_dob ( cp_person_id in number,
3901: cp_effective_date in date ) is
3902: select ppf.date_of_birth,
3903: ppf.original_date_of_hire
3904: from per_all_people_f ppf
3905: where ppf.person_id = cp_person_id
3906: and cp_effective_date between ppf.effective_start_date
3907: and ppf.effective_end_date;
3908: