DBA Data[Home] [Help]

APPS.PAY_IE_EOY_INCOMELEVY_REPORT dependencies on PAY_ACTION_INFORMATION

Line 273: FROM pay_action_information pai /*Employee Details Info*/

269: ,substr(trim(pai.action_information21),1,30) emp_Address1 /* 9160076 */
270: ,substr(trim(pai.action_information22),1,30) emp_Address2
271: ,rpad(substr(trim(pai.action_information23),1,30) ,30,' ') emp_County
272: ,pai_prsi.action_information26 asg_location_id -- 10277535
273: FROM pay_action_information pai /*Employee Details Info*/
274: ,pay_action_information pai_prsi /* prsi Details 5657992 */
275: ,pay_action_information pact_ade /*Address Details - for Employer Name -IE Employer Tax Address*/
276: ,pay_payroll_actions ppa35
277: ,pay_assignment_actions paa

Line 274: ,pay_action_information pai_prsi /* prsi Details 5657992 */

270: ,substr(trim(pai.action_information22),1,30) emp_Address2
271: ,rpad(substr(trim(pai.action_information23),1,30) ,30,' ') emp_County
272: ,pai_prsi.action_information26 asg_location_id -- 10277535
273: FROM pay_action_information pai /*Employee Details Info*/
274: ,pay_action_information pai_prsi /* prsi Details 5657992 */
275: ,pay_action_information pact_ade /*Address Details - for Employer Name -IE Employer Tax Address*/
276: ,pay_payroll_actions ppa35
277: ,pay_assignment_actions paa
278: ,per_assignments_f paf

Line 275: ,pay_action_information pact_ade /*Address Details - for Employer Name -IE Employer Tax Address*/

271: ,rpad(substr(trim(pai.action_information23),1,30) ,30,' ') emp_County
272: ,pai_prsi.action_information26 asg_location_id -- 10277535
273: FROM pay_action_information pai /*Employee Details Info*/
274: ,pay_action_information pai_prsi /* prsi Details 5657992 */
275: ,pay_action_information pact_ade /*Address Details - for Employer Name -IE Employer Tax Address*/
276: ,pay_payroll_actions ppa35
277: ,pay_assignment_actions paa
278: ,per_assignments_f paf
279: ,per_periods_of_service pps