APPS.PAY_AIF_BUS dependencies on PAY_PAYROLL_ACTIONS

Line 38: , pay_payroll_actions pct

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
40: and pbg.business_group_id = pct.business_group_id
41: and act.payroll_action_id = pct.payroll_action_id
42: and act.assignment_action_id = aif.action_context_id

Line 48: , pay_payroll_actions pct

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
51: and pct.payroll_action_id = aif.action_context_id
52: and aif.action_context_type = 'PA';

Line 112: , pay_payroll_actions pct

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
114: and pbg.business_group_id = pct.business_group_id
115: and act.payroll_action_id = pct.payroll_action_id
116: and act.assignment_action_id = aif.action_context_id

Line 122: , pay_payroll_actions pct

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
125: and pct.payroll_action_id = aif.action_context_id
126: and aif.action_context_type = 'PA';

Line 199: , pay_payroll_actions pct

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: --

Line 207: , pay_payroll_actions pct

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: --
211: -- Declare local variables

Line 568: from pay_payroll_actions

564: ) is
565: --
566: cursor csr_pact_exists is
567: select 'X'
568: from pay_payroll_actions
569: where payroll_action_id = p_action_context_id;
570: --
571: cursor csr_aact_exists is
572: select 'X'