[Home] [Help]
22: g_grd_assignment_id number;
23: --
24: type t_valact_rec is record
25: (
26: assignment_id pay_assignment_actions.assignment_id%type,
27: proc_not_exist_date date,
28: proc_exist_date date
29: );
30: --
133:
134: CURSOR c_time_period IS
135: SELECT ptp.start_date start_date,
136: ptp.end_date end_date
137: FROM pay_assignment_actions paa,
138: pay_payroll_actions ppa,
139: per_time_periods ptp
140: WHERE paa.assignment_action_id = p_assignment_action_id
141: AND paa.payroll_action_id = ppa.payroll_action_id
165:
166: CURSOR c_legislation_code IS
167: SELECT pbg.legislation_code legislation_code,
168: pbg.business_group_id business_group_id
169: FROM pay_assignment_actions paa,
170: pay_payroll_actions ppa,
171: per_business_groups_perf pbg
172: WHERE paa.assignment_action_id = p_assignment_action_id
173: AND paa.payroll_action_id = ppa.payroll_action_id
546: -- Date Earned is used while determining the Proration Group id.
547:
548: SELECT ppa.date_earned
549: INTO l_date_earned
550: FROM pay_assignment_actions paa,
551: pay_payroll_actions ppa
552: WHERE paa.assignment_action_id = p_assignment_action_id
553: AND paa.payroll_action_id = ppa.payroll_action_id ;
554:
1342: into l_dummy
1343: from dual
1344: where exists (select ''
1345: from pay_payroll_actions ppa,
1346: pay_assignment_actions paa
1347: where paa.assignment_id = p_assignment_id
1348: and ppa.payroll_action_id = paa.payroll_action_id
1349: and ppa.action_type in ('R', 'Q', 'B', 'V')
1350: and (ppa.effective_date >= p_effective_date
2026: )
2027: is
2028: select ptp_td.start_date
2029: from per_time_periods ptp_td,
2030: pay_assignment_actions paa,
2031: pay_payroll_actions ppa,
2032: per_time_periods ptp_ppa
2033: where ptp_td.time_definition_id = p_time_def
2034: and paa.assignment_action_id = p_asg_act
2315:
2316: -- The following cursor selects the assignment Id for a given assignment_action_id.
2317: CURSOR c_ass_act_id IS
2318: SELECT assignment_id
2319: FROM pay_assignment_actions
2320: WHERE assignment_action_id = p_assignment_action_id;
2321:
2322: CURSOR c_mixed(p_event_update_id IN NUMBER) IS
2323: SELECT a.dated_table_id table_id ,
3479:
3480: PROCEDURE extra_tests_dbt_df
3481: (
3482: p_element_entry_id IN pay_element_entries.element_entry_id%type,
3483: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type,
3484: p_business_group_id IN per_business_groups.business_group_id%type,
3485: p_assignment_id IN per_all_assignments_f.assignment_id%type,
3486: p_mode IN VARCHAR2,
3487: p_process IN VARCHAR2,
3668:
3669: PROCEDURE extra_tests_dbt_u_e
3670: (
3671: p_element_entry_id IN pay_element_entries.element_entry_id%type,
3672: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type,
3673: p_business_group_id IN per_business_groups.business_group_id%type,
3674: p_assignment_id IN per_all_assignments_f.assignment_id%type,
3675: p_process_mode IN VARCHAR2,
3676: p_event_group_id IN pay_event_groups.event_group_id%type,
4219: ---------------------------------------------------------- */
4220: PROCEDURE extra_tests_dyt_pkg_u
4221: (
4222: p_element_entry_id IN pay_element_entries.element_entry_id%type,
4223: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type,
4224: p_business_group_id IN per_business_groups.business_group_id%type,
4225: p_assignment_id IN per_all_assignments_f.assignment_id%type,
4226: p_process_mode IN VARCHAR2,
4227: p_event_group_id IN pay_event_groups.event_group_id%type,
6226:
6227: -- Local variables declaration.
6228:
6229: l_assignment_id per_all_assignments_f.assignment_id%TYPE ;
6230: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE ;
6231: t_dynamic_sql t_dynamic_sql_tab ;
6232: t_proration_dates_temp t_proration_dates_table_type ;
6233: t_proration_change_type_temp t_proration_type_table_type;
6234: t_proration_type_temp t_proration_type_table_type;
6267: );
6268: --
6269: select assignment_action_id
6270: into l_assignment_action_id
6271: from pay_assignment_actions
6272: where assignment_id = p_assignment_id
6273: and rownum = 1;
6274: --
6275: -- Empty all results, this stops accidental