DBA Data[Home] [Help]

APPS.PAY_IE_EOY_INCOMELEVY_REPORT dependencies on PER_ALL_PEOPLE_F

Line 389: ,c_person_id per_all_people_f.person_id%type) is

385:
386: /*
387: CURSOR cur_assignment_action_till_apr(c_ppsn varchar2
388: ,c_assignment_id per_all_assignments.assignment_id%type
389: ,c_person_id per_all_people_f.person_id%type) is
390: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
391: paa.assignment_action_id),16))
392: FROM pay_assignment_actions paa,pay_payroll_actions ppa
393: WHERE ((c_ppsn is null and paa.assignment_id=c_assignment_id)

Line 449: ,c_person_id per_all_people_f.person_id%type) IS

445: and pbt.legislation_code='IE'
446: and pdb.legislation_code='IE';
447:
448: CURSOR cur_paye_ref(c_assignment_id per_all_assignments.assignment_id%type
449: ,c_person_id per_all_people_f.person_id%type) IS
450: SELECT scl.segment4 paye_ref
451: FROM per_all_assignments_f paaf,
452: pay_all_payrolls_f papf,
453: hr_soft_coding_keyflex scl