[Home] [Help]
122: select tim.start_date,
123: tim.end_date
124: into v_time_period_start_date,
125: v_time_period_end_date
126: from per_time_periods tim
127: where tim.payroll_id = v_payroll_id
128: and p_session_date between tim.start_date
129: and tim.end_date;
130: --
1591: --
1592: select ptp.end_date
1593: into v_element_term_rule_date
1594: from per_all_assignments_f asg,
1595: per_time_periods ptp
1596: where asg.assignment_id = p_assignment_id
1597: and p_session_date between asg.effective_start_date and asg.effective_end_date
1598: and asg.payroll_id = ptp.payroll_id
1599: and v_element_term_rule_date between ptp.start_date and ptp.end_date;
1709: if v_processing_type = 'N' then
1710: begin
1711: select ptp.end_date
1712: into v_element_term_rule_date
1713: from per_time_periods ptp,
1714: per_assignments_f asg
1715: where asg.assignment_id = p_assignment_id
1716: and v_asg_term_date between asg.effective_start_date and asg.effective_end_date
1717: and asg.payroll_id is not null
1742: /*
1743: begin
1744: select ptp.end_date
1745: into v_element_term_rule_date
1746: from per_time_periods ptp,
1747: per_assignments_f asg
1748: where asg.assignment_id = p_assignment_id
1749: and v_asg_term_date
1750: between asg.effective_start_date
2398: p_validation_start_date date,
2399: p_validation_end_date date
2400: ) is
2401: select tp.status
2402: from per_time_periods tp,
2403: per_assignments_f asg
2404: where asg.assignment_id = p_assignment_id
2405: and asg.payroll_id is not null
2406: and asg.effective_start_date <= p_validation_end_date
5307: (select aa.assignment_action_id
5308: from pay_assignment_actions aa,
5309: pay_payroll_actions pa,
5310: per_assignments_f asg,
5311: per_time_periods tim,
5312: pay_payrolls_f pp
5313: where pa.effective_date =
5314: (select max(pa2.effective_date)
5315: from pay_payroll_actions pa2,
6060: t.end_date
6061: into l_payroll_id,
6062: l_start_date,
6063: l_end_date
6064: from per_time_periods t,
6065: per_assignments_f a
6066: where a.assignment_id = p_assignment_id
6067: and p_session_date
6068: between a.effective_start_date