[Home] [Help]
1016: CURSOR c_eoy_qbin IS
1017: SELECT ASG.person_id person_id,
1018: ASG.assignment_id assignment_id,
1019: ASG.effective_end_date effective_end_date
1020: FROM per_all_assignments_f ASG,
1021: pay_all_payrolls_f PPY,
1022: hr_soft_coding_keyflex SCL
1023: WHERE ASG.business_group_id + 0 = l_bus_group_id
1024: AND ASG.person_id between stperson and endperson
1054: CURSOR c_eoy_qbin IS
1055: SELECT asg.person_id person_id,
1056: asg.assignment_id assignment_id,
1057: asg.effective_end_date effective_end_date
1058: FROM per_all_assignments_f asg,
1059: pay_assignment_actions paa,
1060: pay_payroll_actions ppa
1061: WHERE ppa.effective_date between l_period_start
1062: and l_period_end
1093: /* Get the primary assignment for the given person_id */
1094:
1095: CURSOR c_get_asg_id (p_person_id number) IS
1096: SELECT assignment_id
1097: from per_all_assignments_f paf
1098: where person_id = p_person_id
1099: and primary_flag = 'Y'
1100: and assignment_type = 'E'
1101: and paf.effective_start_date <= l_period_end
1109: cp_period_start date,
1110: cp_period_end date) IS
1111: select paa.assignment_action_id
1112: from pay_assignment_actions paa,
1113: per_all_assignments_f paf,
1114: per_all_people_f ppf,
1115: pay_payroll_actions ppa,
1116: pay_action_classifications pac
1117: where ppf.person_id = cp_person_id
2168: cursor c_all_gres_for_person(cp_asg_id number,cp_eff_date date) is
2169: select distinct paa.tax_unit_id
2170: from pay_assignment_actions paa,
2171: pay_payroll_actions ppa,
2172: per_all_assignments_f paf
2173: where paa.assignment_id = cp_asg_id
2174: and paf.assignment_id = cp_asg_id
2175: and paf.assignment_id = paa.assignment_id
2176: and paa.action_status = 'C'
2253: , pay_assignment_actions run_paa
2254: , pay_payroll_actions run_ppa
2255: , pay_assignment_actions arch_paa
2256: , pay_payroll_actions arch_ppa
2257: , per_all_assignments_f arch_paf
2258: , per_all_assignments_f all_paf
2259: , hr_all_organization_units hou
2260: , hr_organization_information hoi
2261: where arch_paa.assignment_action_id = cp_asgactid
2254: , pay_payroll_actions run_ppa
2255: , pay_assignment_actions arch_paa
2256: , pay_payroll_actions arch_ppa
2257: , per_all_assignments_f arch_paf
2258: , per_all_assignments_f all_paf
2259: , hr_all_organization_units hou
2260: , hr_organization_information hoi
2261: where arch_paa.assignment_action_id = cp_asgactid
2262: and arch_ppa.payroll_action_id = arch_paa.payroll_action_id
2336: cp_period_end date
2337: ) IS
2338: select paa.assignment_action_id
2339: from pay_assignment_actions paa,
2340: per_all_assignments_f paf,
2341: per_all_people_f ppf,
2342: pay_payroll_actions ppa,
2343: pay_action_classifications pac,
2344: pay_action_contexts pac1,
2368: cp_period_start date,
2369: cp_period_end date) IS
2370: select paa.assignment_action_id
2371: from pay_assignment_actions paa,
2372: per_all_assignments_f paf,
2373: per_all_people_f ppf,
2374: pay_payroll_actions ppa,
2375: pay_action_classifications pac
2376: where ppf.person_id = cp_person_id
3701: l_date_of_birth,
3702: l_national_identifier,
3703: l_pre_name_adjunct,
3704: l_employee_phone_no
3705: from per_all_assignments_f ASSIGN
3706: ,per_all_people_f PEOPLE
3707: ,per_person_types PTYPE
3708: ,per_phones PHONE
3709: ,fnd_sessions SES
3738: l_employee_number,
3739: l_date_of_birth,
3740: l_national_identifier,
3741: l_pre_name_adjunct
3742: from per_all_assignments_f ASSIGN
3743: ,per_all_people_f PEOPLE
3744: where ASSIGN.assignment_id =l_asgid
3745: and PEOPLE.person_id = ASSIGN.person_id
3746: -- code fix started for 6440125
4094: sqlstr := 'select distinct asg.person_id
4095: from pay_all_payrolls_f ppy,
4096: pay_payroll_actions ppa,
4097: pay_assignment_actions paa,
4098: per_all_assignments_f asg,
4099: pay_payroll_actions ppa1
4100: where ppa1.payroll_action_id = :payroll_action_id
4101: and ppa.effective_date between
4102: fnd_date.canonical_to_date('''||