DBA Data[Home] [Help]

APPS.PAY_DK_RULES dependencies on PAY_ACTION_INFORMATION

Line 45: FROM pay_action_information pai

41: pai.action_information27 a27, pai1.action_information27 aa27,
42: pai.action_information28 a28, pai1.action_information28 aa28,
43: pai.action_information29 a29, pai1.action_information29 aa29,
44: pai.action_information30 a30, pai1.action_information30 aa30
45: FROM pay_action_information pai
46: ,pay_action_information pai1
47: ,pay_assignment_actions paa
48: WHERE pai.action_context_type = 'PA'
49: AND pai.action_information_category = p_pa_category

Line 46: ,pay_action_information pai1

42: pai.action_information28 a28, pai1.action_information28 aa28,
43: pai.action_information29 a29, pai1.action_information29 aa29,
44: pai.action_information30 a30, pai1.action_information30 aa30
45: FROM pay_action_information pai
46: ,pay_action_information pai1
47: ,pay_assignment_actions paa
48: WHERE pai.action_context_type = 'PA'
49: AND pai.action_information_category = p_pa_category
50: AND pai1.action_context_type = 'AAP'

Line 116: FROM pay_action_information pai

112: pai.action_information27 a27, pai1.action_information27 aa27,
113: pai.action_information28 a28, pai1.action_information28 aa28,
114: pai.action_information29 a29, pai1.action_information29 aa29,
115: pai.action_information30 a30, pai1.action_information30 aa30
116: FROM pay_action_information pai
117: ,pay_action_information pai1
118: ,pay_assignment_actions paa
119: WHERE pai.action_context_type = 'PA'
120: AND pai.action_information_category = p_pa_category

Line 117: ,pay_action_information pai1

113: pai.action_information28 a28, pai1.action_information28 aa28,
114: pai.action_information29 a29, pai1.action_information29 aa29,
115: pai.action_information30 a30, pai1.action_information30 aa30
116: FROM pay_action_information pai
117: ,pay_action_information pai1
118: ,pay_assignment_actions paa
119: WHERE pai.action_context_type = 'PA'
120: AND pai.action_information_category = p_pa_category
121: AND pai1.action_context_type = 'AAP'