[Home] [Help]
31: -- Declare cursor
32: --
33: cursor csr_sec_grp is
34: select pbg.security_group_id
35: from per_business_groups pbg
36: , pay_action_information aif
37: , pay_assignment_actions act
38: , pay_payroll_actions pct
39: where aif.action_information_id = p_action_information_id
42: and act.assignment_action_id = aif.action_context_id
43: and aif.action_context_type in ('AAP', 'AAC')
44: union all
45: select pbg.security_group_id
46: from per_business_groups pbg
47: , pay_action_information aif
48: , pay_payroll_actions pct
49: where aif.action_information_id = p_action_information_id
50: and pbg.business_group_id = pct.business_group_id
105: -- Declare cursor
106: --
107: cursor csr_leg_code is
108: select pbg.legislation_code
109: from per_business_groups pbg
110: , pay_action_information aif
111: , pay_assignment_actions act
112: , pay_payroll_actions pct
113: where aif.action_information_id = p_action_information_id
116: and act.assignment_action_id = aif.action_context_id
117: and aif.action_context_type in ('AAP', 'AAC')
118: union all
119: select pbg.legislation_code
120: from per_business_groups pbg
121: , pay_action_information aif
122: , pay_payroll_actions pct
123: where aif.action_information_id = p_action_information_id
124: and pbg.business_group_id = pct.business_group_id
193: -- Declare cursor
194: --
195: cursor csr_aa_leg_code is
196: select pbg.legislation_code
197: from per_business_groups pbg
198: , pay_assignment_actions act
199: , pay_payroll_actions pct
200: where act.assignment_action_id = p_action_context_id
201: and act.payroll_action_id = pct.payroll_action_id
202: and pct.business_group_id = pbg.business_group_id;
203: --
204: cursor csr_pa_leg_code is
205: select pbg.legislation_code
206: from per_business_groups pbg
207: , pay_payroll_actions pct
208: where pct.payroll_action_id = p_action_context_id
209: and pct.business_group_id = pbg.business_group_id;
210: --