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_NO_EMP_CONT dependencies on PAY_PAYROLL_ACTIONS

Line 89: from pay_payroll_actions ppa

85:
86: -- Cursor to get the payroll_action_id
87: /* cursor csr_payroll_action_id (p_payroll_id pay_all_payrolls_f.PAYROLL_ID%type ,p_date_earned DATE ) is
88: select ppa.PAYROLL_ACTION_ID
89: from pay_payroll_actions ppa
90: ,pay_run_types_f prt
91: where ppa.PAYROLL_ID = p_payroll_id
92: and prt.LEGISLATION_CODE = 'NO'
93: and prt.RUN_TYPE_NAME <> 'Employer Contributions'

Line 103: from pay_payroll_actions ppa

99: --Bug Fix 4465274, modified the cursor
100: /*
101: cursor csr_payroll_action_id (p_date_earned DATE ) is
102: select ppa.PAYROLL_ACTION_ID
103: from pay_payroll_actions ppa
104: ,pay_run_types_f prt
105: where prt.LEGISLATION_CODE = 'NO'
106: and prt.RUN_TYPE_NAME <> 'Employer Contributions'
107: and prt.RUN_TYPE_ID = ppa.RUN_TYPE_ID

Line 117: from pay_payroll_actions ppa

113: --Bug Fix 5042861, modified the cursor for performance fix to remove TABLE ACCESS FULL (SQL ID:16539845)
114:
115: cursor csr_payroll_action_id (p_date_earned DATE ) is
116: select ppa.PAYROLL_ACTION_ID
117: from pay_payroll_actions ppa
118: ,pay_run_types_f prt
119: where ppa.RUN_TYPE_ID = prt.RUN_TYPE_ID
120: and prt.LEGISLATION_CODE = 'NO'
121: and prt.RUN_TYPE_NAME IN ('Main','Standard','Process Alone','Pay Separately')

Line 130: ,l_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type) is

126:
127:
128: -- Cursor to get the assignment_action_id and assignment_id
129: cursor csr_assignment_id (p_tax_unit_id pay_assignment_actions.TAX_UNIT_ID%TYPE
130: ,l_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type) is
131: select ASSIGNMENT_ID
132: ,ASSIGNMENT_ACTION_ID
133: from pay_assignment_actions
134: where PAYROLL_ACTION_ID = l_payroll_action_id

Line 185: (p_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type

181:
182: -- cursor to get the Local Units (LU) and Legal Employers (LE) of the current assignments
183:
184: cursor csr_get_lu_le
185: (p_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type
186: ,p_date_earned DATE ) is
187:
188: SELECT scl.segment2 loc_unit , assact.tax_unit_id leg_emp
189: FROM pay_assignment_actions assact