DBA Data[Home] [Help]

APPS.PAY_IN_RULES dependencies on PER_ASSIGNMENTS_F

Line 79: ,per_assignments_f paf

75: SELECT hsc.segment2
76: FROM pay_element_entries_f target
77: ,pay_assignment_actions paa
78: ,pay_payroll_actions ppa
79: ,per_assignments_f paf
80: ,hr_soft_coding_keyflex hsc
81: WHERE ppa.payroll_action_id = paa.payroll_action_id
82: AND target.element_entry_id = p_ee_id
83: AND target.assignment_id = paa.assignment_id

Line 98: ,per_assignments_f paf

94: SELECT hsc.segment3
95: FROM pay_element_entries_f target
96: ,pay_assignment_actions paa
97: ,pay_payroll_actions ppa
98: ,per_assignments_f paf
99: ,hr_soft_coding_keyflex hsc
100: WHERE ppa.payroll_action_id = paa.payroll_action_id
101: AND target.element_entry_id = p_ee_id
102: AND target.assignment_id = paa.assignment_id

Line 117: ,per_assignments_f paf

113: SELECT hsc.segment4
114: FROM pay_element_entries_f target
115: ,pay_assignment_actions paa
116: ,pay_payroll_actions ppa
117: ,per_assignments_f paf
118: ,hr_soft_coding_keyflex hsc
119: WHERE ppa.payroll_action_id = paa.payroll_action_id
120: AND target.element_entry_id = p_ee_id
121: AND target.assignment_id = paa.assignment_id

Line 136: ,per_assignments_f paf

132: SELECT nvl(hsc.segment6,hsc.segment5)
133: FROM pay_element_entries_f target
134: ,pay_assignment_actions paa
135: ,pay_payroll_actions ppa
136: ,per_assignments_f paf
137: ,hr_soft_coding_keyflex hsc
138: WHERE ppa.payroll_action_id = paa.payroll_action_id
139: AND target.element_entry_id = p_ee_id
140: AND target.assignment_id = paa.assignment_id

Line 232: ,per_assignments_f paf

228: SELECT hsc.segment3
229: FROM pay_element_entries_f target
230: ,pay_assignment_actions paa
231: ,pay_payroll_actions ppa
232: ,per_assignments_f paf
233: ,hr_soft_coding_keyflex hsc
234: WHERE ppa.payroll_action_id = paa.payroll_action_id
235: AND target.element_entry_id = p_ee_id
236: AND target.assignment_id = paa.assignment_id

Line 251: ,per_assignments_f paf

247: SELECT nvl(hsc.segment6,hsc.segment5)
248: FROM pay_element_entries_f target
249: ,pay_assignment_actions paa
250: ,pay_payroll_actions ppa
251: ,per_assignments_f paf
252: ,hr_soft_coding_keyflex hsc
253: WHERE ppa.payroll_action_id = paa.payroll_action_id
254: AND target.element_entry_id = p_ee_id
255: AND target.assignment_id = paa.assignment_id