[Home] [Help]
1317: select
1318: distinct paei.assignment_id , fnd_date.canonical_to_date(paei.AEI_INFORMATION2)
1319: from per_all_assignments_f paaf1, per_all_assignments_f paaf2 ,per_assignment_extra_info paei,
1320: pay_all_payrolls_f pay,
1321: hr_soft_coding_keyflex sck
1322: where paaf1.assignment_id = c_asg_id
1323: and paaf1.person_id = paaf2.person_id
1324: and paaf2.assignment_type = 'E'
1325: and paei.assignment_id = paaf2.assignment_id
3851: from per_all_people_f pap,
3852: per_all_assignments_f asg,
3853: per_assignment_status_types past,
3854: pay_all_payrolls_f pay,
3855: hr_soft_coding_keyflex sck
3856: where pap.person_id between stperson and endperson
3857: and pap.person_id = asg.person_id
3858: and asg.business_group_id +0 = l_business_group_id
3859: and asg.assignment_status_type_id = past.assignment_status_type_id
3933: cursor csr_all_actions_after_fps (asg_id number, p_pact_id number) is
3934: select paa.ASSIGNMENT_ACTION_ID asg_act_id from pay_payroll_actions ppa,pay_assignment_actions paa,
3935: per_all_assignments_f paaf,
3936: pay_all_payrolls_f pay,
3937: hr_soft_coding_keyflex sck
3938: where paa.ASSIGNMENT_ID = asg_id
3939: AND paaf.assignment_id = asg_id
3940: AND pay.payroll_id = paaf.payroll_id
3941: and pay.soft_coding_keyflex_id = sck.soft_coding_keyflex_id
3961: , pay_payroll_actions pact
3962: , per_time_periods ptp,
3963: per_all_assignments_f paaf,
3964: pay_all_payrolls_f pay,
3965: hr_soft_coding_keyflex sck
3966:
3967: WHERE paa.assignment_id = asg_id
3968: AND paaf.assignment_id = asg_id
3969: AND pay.payroll_id = paaf.payroll_id
3989:
3990: cursor csr_all_actions_after_fps_agg (per_id number, p_pact_id number) is
3991: select paa.ASSIGNMENT_ACTION_ID asg_act_id from per_all_assignments_f paaf, pay_payroll_actions ppa,pay_assignment_actions paa,
3992: pay_all_payrolls_f pay,
3993: hr_soft_coding_keyflex sck
3994: where paaf.person_ID = per_id
3995: and paa.assignment_id = paaf.assignment_id
3996: AND pay.payroll_id = paaf.payroll_id
3997: and pay.soft_coding_keyflex_id = sck.soft_coding_keyflex_id
4017: pay_assignment_actions paa
4018: , pay_payroll_actions pact
4019: , per_time_periods ptp,
4020: pay_all_payrolls_f pay,
4021: hr_soft_coding_keyflex sck
4022: WHERE paa.assignment_id = paaf.assignment_id
4023: and paaf.person_id = per_id
4024: AND pay.payroll_id = paaf.payroll_id
4025: and pay.soft_coding_keyflex_id = sck.soft_coding_keyflex_id
4054: pay_assignment_actions paa
4055: , pay_payroll_actions pact
4056: , per_time_periods ptp,
4057: pay_all_payrolls_f pay,
4058: hr_soft_coding_keyflex sck
4059: WHERE paa.assignment_id = paaf.assignment_id
4060: and paaf.person_id = per_id
4061: AND pay.payroll_id = paaf.payroll_id
4062: and pay.soft_coding_keyflex_id = sck.soft_coding_keyflex_id
4091: pay_assignment_actions paa
4092: , pay_payroll_actions pact
4093: , per_time_periods ptp,
4094: pay_all_payrolls_f pay,
4095: hr_soft_coding_keyflex sck
4096: WHERE paa.assignment_id = paaf.assignment_id
4097: and paaf.person_id = per_id
4098: and paaf.assignment_id <> asg_id
4099: AND pay.payroll_id = paaf.payroll_id
4129: select
4130: distinct paei.assignment_id , fnd_date.canonical_to_date(paei.AEI_INFORMATION2)
4131: from per_all_assignments_f paaf1, per_all_assignments_f paaf2 ,per_assignment_extra_info paei,
4132: pay_all_payrolls_f pay,
4133: hr_soft_coding_keyflex sck
4134: where paaf1.assignment_id = c_asg_id
4135: and paaf1.person_id = paaf2.person_id
4136: and paaf2.assignment_type= 'E'
4137: and paei.assignment_id = paaf2.assignment_id
5397: pay_assignment_actions paa
5398: , pay_payroll_actions pact
5399: , per_time_periods ptp,
5400: pay_all_payrolls_f pay,
5401: hr_soft_coding_keyflex sck
5402: WHERE paa.assignment_id = paaf.assignment_id
5403: and paaf.person_id = person_id
5404: AND paa.payroll_action_id = pact.payroll_action_id
5405: AND pact.time_period_id = ptp.time_period_id
5438: from pay_assignment_actions paa,
5439: pay_payroll_actions ppa,
5440: per_all_assignments_f paaf ,
5441: pay_all_payrolls_f pay,
5442: hr_soft_coding_keyflex sck
5443: where paaf.person_id = per_id
5444: AND pay.payroll_id = paaf.payroll_id
5445: and pay.soft_coding_keyflex_id = sck.soft_coding_keyflex_id
5446: and upper(g_tax_ref) = upper(sck.segment1)