APPS.HR_ENTRY dependencies on PER_TIME_PERIODS

Line 118: from per_time_periods tim

114: select tim.start_date,
115: tim.end_date
116: into v_time_period_start_date,
117: v_time_period_end_date
118: from per_time_periods tim
119: where tim.payroll_id = v_payroll_id
120: and p_session_date between tim.start_date
121: and tim.end_date;
122: --

Line 1395: per_time_periods ptp

1391: --
1392: select ptp.end_date
1393: into v_element_term_rule_date
1394: from per_all_assignments_f asg,
1395: per_time_periods ptp
1396: where asg.assignment_id = p_assignment_id
1397: and p_session_date between asg.effective_start_date and asg.effective_end_date
1398: and asg.payroll_id = ptp.payroll_id
1399: and v_element_term_rule_date between ptp.start_date and ptp.end_date;

Line 1505: from per_time_periods ptp,

1501: if v_processing_type = 'N' then
1502: begin
1503: select ptp.end_date
1504: into v_element_term_rule_date
1505: from per_time_periods ptp,
1506: per_assignments_f asg
1507: where asg.assignment_id = p_assignment_id
1508: and v_asg_term_date between asg.effective_start_date and asg.effective_end_date
1509: and asg.payroll_id is not null

Line 1538: from per_time_periods ptp,

1534: /*
1535: begin
1536: select ptp.end_date
1537: into v_element_term_rule_date
1538: from per_time_periods ptp,
1539: per_assignments_f asg
1540: where asg.assignment_id = p_assignment_id
1541: and v_asg_term_date
1542: between asg.effective_start_date

Line 2159: from per_time_periods tp,

2155: p_validation_start_date date,
2156: p_validation_end_date date
2157: ) is
2158: select tp.status
2159: from per_time_periods tp,
2160: per_assignments_f asg
2161: where asg.assignment_id = p_assignment_id
2162: and asg.payroll_id is not null
2163: and asg.effective_start_date <= p_validation_end_date

Line 4935: per_time_periods tim,

4931: (select aa.assignment_action_id
4932: from pay_assignment_actions aa,
4933: pay_payroll_actions pa,
4934: per_assignments_f asg,
4935: per_time_periods tim,
4936: pay_payrolls_f pp
4937: where pa.effective_date =
4938: (select max(pa2.effective_date)
4939: from pay_payroll_actions pa2,

Line 5675: from per_time_periods t,

5671: t.end_date
5672: into l_payroll_id,
5673: l_start_date,
5674: l_end_date
5675: from per_time_periods t,
5676: per_assignments_f a
5677: where a.assignment_id = p_assignment_id
5678: and p_session_date
5679: between a.effective_start_date