[Home] [Help]
39: ( p_payroll_action_id number
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
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
127: and pact.date_earned between pptp.start_date and pptp.end_date;
131: l_date_dd_mm varchar2(11);
132: l_fy_user_span_start date;
133: l_frequency number;
134: l_dimension_name pay_balance_dimensions.dimension_name%type := upper(p_dimension_name);
135: l_business_group_id pay_payroll_actions.business_group_id%type;
136: --
137: begin
138: --
139: -- select the start span for the using action.