DBA Data[Home] [Help]

APPS.PAY_AIF_BUS dependencies on PAY_ACTION_INFORMATION

Line 36: , pay_action_information aif

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
40: and pbg.business_group_id = pct.business_group_id

Line 47: , pay_action_information aif

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
51: and pct.payroll_action_id = aif.action_context_id

Line 110: , pay_action_information aif

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
114: and pbg.business_group_id = pct.business_group_id

Line 121: , pay_action_information aif

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
125: and pct.payroll_action_id = aif.action_context_id