eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IE_P30LOCK dependencies on PAY_ACTION_INFORMATION

Line 154: ,pay_action_information pai --12943478

150: pay_action_interlocks pai_pre,
151: pay_assignment_actions paa_run,
152: pay_payroll_actions ppa_run,
153: pay_all_payrolls_f pap
154: ,pay_action_information pai --12943478
155: where pp1.payroll_action_id = pactid
156: and asg.business_group_id = pp1.business_group_id
157: and asg.person_id between stperson and endperson
158: and asg.assignment_id = paa.assignment_id

Line 355: pay_action_information pact_er,

351: pay_assignment_actions paa_arc,
352: pay_action_interlocks pai_arc,
353: pay_assignment_actions paa_prepay,
354: pay_action_interlocks pai_prepay,
355: pay_action_information pact_er,
356: pay_action_information pact_ee
357: -- pay_pre_payments ppp -- Bug Fix 3725003
358: WHERE ppa_p30.payroll_action_id = c_p30_data_lock_process
359: AND ppa_p30.payroll_action_id = paa_p30.payroll_action_id

Line 356: pay_action_information pact_ee

352: pay_action_interlocks pai_arc,
353: pay_assignment_actions paa_prepay,
354: pay_action_interlocks pai_prepay,
355: pay_action_information pact_er,
356: pay_action_information pact_ee
357: -- pay_pre_payments ppp -- Bug Fix 3725003
358: WHERE ppa_p30.payroll_action_id = c_p30_data_lock_process
359: AND ppa_p30.payroll_action_id = paa_p30.payroll_action_id
360: AND paa_p30.assignment_action_id = pai_p30.locking_action_id

Line 410: FROM pay_action_information pai

406: ,substr(pai.action_information7,1,30) employer_tax_addr3
407: ,substr(pai.action_information26,1,30) employer_tax_contact
408: ,substr(pai.action_information27,1,12) employer_tax_ref_phone
409: ,substr(pai.action_information28,1,30) employer_tax_rep_name
410: FROM pay_action_information pai
411: WHERE pai.action_context_id = c_payroll_action_id
412: AND pai.action_context_type = 'PA'
413: AND pai.action_information_category = 'ADDRESS DETAILS'
414: AND pai.action_information14 = 'IE Employer Tax Address';

Line 429: pay_action_information pact_ytdbal,

425: SELECT pact_ytdbal.action_information4 Balance_Value
426: FROM pay_assignment_actions paa_p30,
427: pay_action_interlocks pai_p30,
428: pay_assignment_actions paa_arc,
429: pay_action_information pact_ytdbal,
430: pay_defined_balances pdb_ytdbal,
431: pay_balance_types pbt_ytdbal,
432: pay_balance_dimensions pbd_ytdbal,
433: pay_assignment_actions paa_src,

Line 503: pay_action_information pact_ytdbal,

499: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa_run.action_sequence,15,'0')||pact_ytdbal.ACTION_CONTEXT_ID),16))
500: FROM pay_assignment_actions paa_p30,
501: pay_action_interlocks pai_p30,
502: pay_assignment_actions paa_arc,
503: pay_action_information pact_ytdbal,
504: pay_action_interlocks pai_arc,
505: pay_assignment_actions paa_run,
506: pay_payroll_actions ppa_run
507: -- ,pay_pre_payments ppp --Bug Fix 4049831 Added join with pay_pre_payments table

Line 624: --Fetch Curr PAYE YTD Balance from PAY ACTION INFORMATION

620: FETCH get_action_context INTO v_action_context_id;
621: CLOSE get_action_context;
622: -- SR 17318286.6 rbhardwa changes end here
623:
624: --Fetch Curr PAYE YTD Balance from PAY ACTION INFORMATION
625: OPEN YTD_Balances(v_cur_employer_info.report_id
626: ,v_cur_employer_info.assignment_id
627: ,'IE Net Tax'
628: ,'_ASG_YTD'

Line 635: --Fetch Curr EE PRSI YTD Balance from PAY ACTION INFORMATION

631: FETCH YTD_Balances INTO v_Curr_YTD_Balances;
632: CLOSE YTD_Balances;
633: l_PAYE_YTD := NVL(v_Curr_YTD_Balances.Balance_Value,0);
634: v_Curr_YTD_Balances.Balance_Value := NULL;
635: --Fetch Curr EE PRSI YTD Balance from PAY ACTION INFORMATION
636: OPEN YTD_Balances(v_cur_employer_info.report_id
637: ,v_cur_employer_info.assignment_id
638: ,'IE PRSI Employee'
639: ,'_ASG_YTD'

Line 669: --Fetch Curr ER PRSI YTD Balance from PAY ACTION INFORMATION

665: CLOSE YTD_Balances;
666: l_EE_PRSI_YTD := l_EE_PRSI_YTD + NVL(v_Curr_YTD_Balances.Balance_Value,0);
667: v_Curr_YTD_Balances.Balance_Value := NULL;
668: -- Total PRSI Employee figure has been evaluated above
669: --Fetch Curr ER PRSI YTD Balance from PAY ACTION INFORMATION
670: OPEN YTD_Balances(v_cur_employer_info.report_id
671: ,v_cur_employer_info.assignment_id
672: ,'IE PRSI Employer'
673: ,'_ASG_YTD'

Line 783: --Fetch Prev PAYE YTD Balance from PAY ACTION INFORMATION of Prev P30 Run

779: CLOSE get_action_context;
780: -- SR 17318286.6 rbhardwa changes end here
781:
782:
783: --Fetch Prev PAYE YTD Balance from PAY ACTION INFORMATION of Prev P30 Run
784: OPEN YTD_Balances(v_prev_data_lock_id,v_cur_employer_info.assignment_id,'IE Net Tax','_ASG_YTD',v_action_context_id,v_pre_date_eff_date);
785: FETCH YTD_Balances INTO v_Prev_YTD_Balances;
786: CLOSE YTD_Balances;
787: l_PAYE_PTD := l_PAYE_YTD - NVL(v_Prev_YTD_Balances.Balance_Value,0);

Line 790: --Fetch Prev EE PRSI YTD Balance from PAY ACTION INFORMATION of Prev P30 Run

786: CLOSE YTD_Balances;
787: l_PAYE_PTD := l_PAYE_YTD - NVL(v_Prev_YTD_Balances.Balance_Value,0);
788: v_Prev_YTD_Balances.Balance_Value := NULL;
789:
790: --Fetch Prev EE PRSI YTD Balance from PAY ACTION INFORMATION of Prev P30 Run
791: OPEN YTD_Balances(v_prev_data_lock_id,v_cur_employer_info.assignment_id,'IE PRSI Employee','_ASG_YTD',v_action_context_id,v_pre_date_eff_date);
792: FETCH YTD_Balances INTO v_Prev_YTD_Balances;
793: CLOSE YTD_Balances;
794: l_EE_PRSI_PTD := l_EE_PRSI_YTD - NVL(v_Prev_YTD_Balances.Balance_Value,0);

Line 811: --Fetch Prev ER PRSI YTD Balance from PAY ACTION INFORMATION of Prev P30

807: CLOSE YTD_Balances;
808: l_EE_PRSI_PTD := l_EE_PRSI_PTD - NVL(v_Prev_YTD_Balances.Balance_Value,0);
809: v_Prev_YTD_Balances.Balance_Value := NULL;
810:
811: --Fetch Prev ER PRSI YTD Balance from PAY ACTION INFORMATION of Prev P30
812: OPEN YTD_Balances(v_prev_data_lock_id,v_cur_employer_info.assignment_id,'IE PRSI Employer','_ASG_YTD',v_action_context_id,v_pre_date_eff_date);
813: FETCH YTD_Balances INTO v_Prev_YTD_Balances;
814: CLOSE YTD_Balances;
815: l_ER_PRSI_PTD := l_ER_PRSI_YTD - NVL(v_Prev_YTD_Balances.Balance_Value,0);