[Home] [Help]
40: , p_assignment_action_id number
41: , p_effective_date date) is
42: select ptp.time_period_id
43: from pay_payroll_actions act
44: , per_time_periods ptp
45: where payroll_action_id = p_payroll_action_id
46: and act.date_earned between ptp.start_date and ptp.end_date
47: and act.payroll_id = ptp.payroll_id
48: and act.effective_date = p_effective_date;
109: cursor csr_user_span_start(p_frequency number, p_span_start varchar2) is
110: select hr_nz_routes.span_start ( bptp.regular_payment_date
111: , p_frequency
112: , p_span_start )
113: from per_time_periods bptp
114: , pay_payroll_actions bact
115: where bact.payroll_action_id = p_user_payroll_action_id
116: and bact.effective_date = p_user_effective_date
117: and bact.payroll_id = bptp.payroll_id
118: and bact.date_earned between bptp.start_date and bptp.end_date;
119: --
120: cursor csr_owner_start is
121: select pptp.regular_payment_date
122: from per_time_periods pptp
123: , pay_payroll_actions pact
124: where pact.payroll_action_id = p_owner_payroll_action_id
125: and pact.effective_date = p_owner_effective_date
126: and pact.payroll_id = pptp.payroll_id