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 349: pay_action_information pact_er,

345: pay_assignment_actions paa_arc,
346: pay_action_interlocks pai_arc,
347: pay_assignment_actions paa_prepay,
348: pay_action_interlocks pai_prepay,
349: pay_action_information pact_er,
350: pay_action_information pact_ee
351: -- pay_pre_payments ppp -- Bug Fix 3725003
352: WHERE ppa_p30.payroll_action_id = c_p30_data_lock_process
353: AND ppa_p30.payroll_action_id = paa_p30.payroll_action_id

Line 350: pay_action_information pact_ee

346: pay_action_interlocks pai_arc,
347: pay_assignment_actions paa_prepay,
348: pay_action_interlocks pai_prepay,
349: pay_action_information pact_er,
350: pay_action_information pact_ee
351: -- pay_pre_payments ppp -- Bug Fix 3725003
352: WHERE ppa_p30.payroll_action_id = c_p30_data_lock_process
353: AND ppa_p30.payroll_action_id = paa_p30.payroll_action_id
354: AND paa_p30.assignment_action_id = pai_p30.locking_action_id

Line 404: FROM pay_action_information pai

400: ,substr(pai.action_information7,1,30) employer_tax_addr3
401: ,substr(pai.action_information26,1,30) employer_tax_contact
402: ,substr(pai.action_information27,1,12) employer_tax_ref_phone
403: ,substr(pai.action_information28,1,30) employer_tax_rep_name
404: FROM pay_action_information pai
405: WHERE pai.action_context_id = c_payroll_action_id
406: AND pai.action_context_type = 'PA'
407: AND pai.action_information_category = 'ADDRESS DETAILS'
408: AND pai.action_information14 = 'IE Employer Tax Address';

Line 423: pay_action_information pact_ytdbal,

419: SELECT pact_ytdbal.action_information4 Balance_Value
420: FROM pay_assignment_actions paa_p30,
421: pay_action_interlocks pai_p30,
422: pay_assignment_actions paa_arc,
423: pay_action_information pact_ytdbal,
424: pay_defined_balances pdb_ytdbal,
425: pay_balance_types pbt_ytdbal,
426: pay_balance_dimensions pbd_ytdbal,
427: pay_assignment_actions paa_src,

Line 497: pay_action_information pact_ytdbal,

493: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa_run.action_sequence,15,'0')||pact_ytdbal.ACTION_CONTEXT_ID),16))
494: FROM pay_assignment_actions paa_p30,
495: pay_action_interlocks pai_p30,
496: pay_assignment_actions paa_arc,
497: pay_action_information pact_ytdbal,
498: pay_action_interlocks pai_arc,
499: pay_assignment_actions paa_run,
500: pay_payroll_actions ppa_run
501: -- ,pay_pre_payments ppp --Bug Fix 4049831 Added join with pay_pre_payments table

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

614: FETCH get_action_context INTO v_action_context_id;
615: CLOSE get_action_context;
616: -- SR 17318286.6 rbhardwa changes end here
617:
618: --Fetch Curr PAYE YTD Balance from PAY ACTION INFORMATION
619: OPEN YTD_Balances(v_cur_employer_info.report_id
620: ,v_cur_employer_info.assignment_id
621: ,'IE Net Tax'
622: ,'_ASG_YTD'

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

625: FETCH YTD_Balances INTO v_Curr_YTD_Balances;
626: CLOSE YTD_Balances;
627: l_PAYE_YTD := NVL(v_Curr_YTD_Balances.Balance_Value,0);
628: v_Curr_YTD_Balances.Balance_Value := NULL;
629: --Fetch Curr EE PRSI YTD Balance from PAY ACTION INFORMATION
630: OPEN YTD_Balances(v_cur_employer_info.report_id
631: ,v_cur_employer_info.assignment_id
632: ,'IE PRSI Employee'
633: ,'_ASG_YTD'

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

659: CLOSE YTD_Balances;
660: l_EE_PRSI_YTD := l_EE_PRSI_YTD + NVL(v_Curr_YTD_Balances.Balance_Value,0);
661: v_Curr_YTD_Balances.Balance_Value := NULL;
662: -- Total PRSI Employee figure has been evaluated above
663: --Fetch Curr ER PRSI YTD Balance from PAY ACTION INFORMATION
664: OPEN YTD_Balances(v_cur_employer_info.report_id
665: ,v_cur_employer_info.assignment_id
666: ,'IE PRSI Employer'
667: ,'_ASG_YTD'

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

713: CLOSE get_action_context;
714: -- SR 17318286.6 rbhardwa changes end here
715:
716:
717: --Fetch Prev PAYE YTD Balance from PAY ACTION INFORMATION of Prev P30 Run
718: 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);
719: FETCH YTD_Balances INTO v_Prev_YTD_Balances;
720: CLOSE YTD_Balances;
721: l_PAYE_PTD := l_PAYE_YTD - NVL(v_Prev_YTD_Balances.Balance_Value,0);

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

720: CLOSE YTD_Balances;
721: l_PAYE_PTD := l_PAYE_YTD - NVL(v_Prev_YTD_Balances.Balance_Value,0);
722: v_Prev_YTD_Balances.Balance_Value := NULL;
723:
724: --Fetch Prev EE PRSI YTD Balance from PAY ACTION INFORMATION of Prev P30 Run
725: 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);
726: FETCH YTD_Balances INTO v_Prev_YTD_Balances;
727: CLOSE YTD_Balances;
728: l_EE_PRSI_PTD := l_EE_PRSI_YTD - NVL(v_Prev_YTD_Balances.Balance_Value,0);

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

741: CLOSE YTD_Balances;
742: l_EE_PRSI_PTD := l_EE_PRSI_PTD - NVL(v_Prev_YTD_Balances.Balance_Value,0);
743: v_Prev_YTD_Balances.Balance_Value := NULL;
744:
745: --Fetch Prev ER PRSI YTD Balance from PAY ACTION INFORMATION of Prev P30
746: 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);
747: FETCH YTD_Balances INTO v_Prev_YTD_Balances;
748: CLOSE YTD_Balances;
749: l_ER_PRSI_PTD := l_ER_PRSI_YTD - NVL(v_Prev_YTD_Balances.Balance_Value,0);