APPS.PAY_AIF_BUS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 37: , pay_assignment_actions act

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
41: and act.payroll_action_id = pct.payroll_action_id

Line 111: , pay_assignment_actions act

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
115: and act.payroll_action_id = pct.payroll_action_id

Line 198: , pay_assignment_actions act

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;

Line 573: from pay_assignment_actions

569: where payroll_action_id = p_action_context_id;
570: --
571: cursor csr_aact_exists is
572: select 'X'
573: from pay_assignment_actions
574: where assignment_action_id = p_action_context_id;
575: --
576: l_proc varchar2(72) := g_package || 'chk_action_context_id';
577: l_dummy varchar2(1);