[Home] [Help]
27: cursor csr_run_type_period_name(p_run_type_period in number) is
28: select run_type_name||'-'||ptp.period_name||'-'||ppa.payroll_action_id run_type_period_name
29: from pay_payroll_actions ppa,
30: pay_payroll_actions rppa,
31: pay_assignment_actions paa,
32: pay_assignment_actions rpaa,
33: pay_action_interlocks pai,
34: pay_run_types_f prt,
35: per_time_periods ptp
28: select run_type_name||'-'||ptp.period_name||'-'||ppa.payroll_action_id run_type_period_name
29: from pay_payroll_actions ppa,
30: pay_payroll_actions rppa,
31: pay_assignment_actions paa,
32: pay_assignment_actions rpaa,
33: pay_action_interlocks pai,
34: pay_run_types_f prt,
35: per_time_periods ptp
36: where ppa.payroll_action_id = p_run_type_period
47: and rpaa.run_type_id = prt.run_type_id
48: and rppa.time_period_id = ptp.time_period_id
49: and ppa.payroll_action_id = paa.payroll_action_id
50: and rpaa.assignment_action_id = (select max(paa_locked.assignment_action_id)
51: from pay_assignment_actions paa_locked,
52: pay_action_interlocks pai_locking
53: where pai_locking.locking_action_id =
54: (select max(paa1.assignment_action_id)
55: from pay_assignment_actions paa1
51: from pay_assignment_actions paa_locked,
52: pay_action_interlocks pai_locking
53: where pai_locking.locking_action_id =
54: (select max(paa1.assignment_action_id)
55: from pay_assignment_actions paa1
56: where paa1.payroll_action_id = ppa.payroll_action_Id)
57: and paa_locked.assignment_action_id = pai_locking.locked_action_id)
58: and ppa.effective_date between prt.effective_start_date and prt.effective_end_date
59: and rppa.effective_date between ptp.start_date and ptp.end_date;
201: cursor asg_info_cur
202: is
203: select count(paa.assignment_action_id) ASG_COUNT,
204: paa.action_status ASG_STATUS
205: from pay_assignment_actions paa,
206: pay_payroll_actions ppa,
207: per_business_groups pbg
208: where paa.payroll_action_id = ppa.payroll_action_id
209: and ppa.request_id = ln_req_id