APPS.PAY_IE_P60XML dependencies on PAY_ACTION_INFORMATION

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

357: ,1,'D',-1,'R',NULL
358: ) Q1_USC_Refund_Deduction
359: ,to_char(nvl(round(to_number(substr(trim(pai_prsi.action_information21),instr(pai_prsi.action_information21,'|',1,1)+1)),2),0),'99999990.00') Q1_Present_USC
360: --14659262
361: FROM pay_action_information pai /*Employee Details Info*/
362: ,pay_action_information pai_prsi /* prsi Details 5657992 */
363: ,pay_action_information pact_ade /*Address Details - for Employer Name -IE Employer Tax Address*/
364: ,pay_payroll_actions ppa35
365: ,pay_assignment_actions paa

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

358: ) Q1_USC_Refund_Deduction
359: ,to_char(nvl(round(to_number(substr(trim(pai_prsi.action_information21),instr(pai_prsi.action_information21,'|',1,1)+1)),2),0),'99999990.00') Q1_Present_USC
360: --14659262
361: FROM pay_action_information pai /*Employee Details Info*/
362: ,pay_action_information pai_prsi /* prsi Details 5657992 */
363: ,pay_action_information pact_ade /*Address Details - for Employer Name -IE Employer Tax Address*/
364: ,pay_payroll_actions ppa35
365: ,pay_assignment_actions paa
366: ,per_assignments_f paf

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

359: ,to_char(nvl(round(to_number(substr(trim(pai_prsi.action_information21),instr(pai_prsi.action_information21,'|',1,1)+1)),2),0),'99999990.00') Q1_Present_USC
360: --14659262
361: FROM pay_action_information pai /*Employee Details Info*/
362: ,pay_action_information pai_prsi /* prsi Details 5657992 */
363: ,pay_action_information pact_ade /*Address Details - for Employer Name -IE Employer Tax Address*/
364: ,pay_payroll_actions ppa35
365: ,pay_assignment_actions paa
366: ,per_assignments_f paf
367: ,per_periods_of_service pps