APPS.PAY_FR_GENERAL dependencies on PAY_ASSIGNMENT_ACTIONS

Line 82: , pay_assignment_actions paa

78:
79: cursor pay_asg_act_csr is
80: select paa.assignment_action_id, ppa.effective_date
81: from pay_payroll_actions ppa
82: , pay_assignment_actions paa
83: , pay_run_results prr
84: where ppa.business_group_id = p_business_group_id
85: and ppa.action_type in ('Q','R')
86: and ppa.action_status in ('C','I')

Line 697: from pay_assignment_actions act_child,

693: l_parent_action_id number;
694: --
695: cursor csr_parent_action is
696: select nvl(nvl(act_parent.source_action_id, act_child.source_action_id),act_child.assignment_action_id)
697: from pay_assignment_actions act_child,
698: pay_assignment_actions act_parent
699: where act_child.assignment_action_id = p_asg_action_id
700: and act_parent.assignment_action_id (+) = act_child.source_action_id;
701: begin

Line 698: pay_assignment_actions act_parent

694: --
695: cursor csr_parent_action is
696: select nvl(nvl(act_parent.source_action_id, act_child.source_action_id),act_child.assignment_action_id)
697: from pay_assignment_actions act_child,
698: pay_assignment_actions act_parent
699: where act_child.assignment_action_id = p_asg_action_id
700: and act_parent.assignment_action_id (+) = act_child.source_action_id;
701: begin
702: --