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_ASSIGNMENT_ACTIONS

Line 129: cursor csr_assignment_id (p_tax_unit_id pay_assignment_actions.TAX_UNIT_ID%TYPE

125:
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

Line 133: from pay_assignment_actions

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
135: and TAX_UNIT_ID = p_tax_unit_id;
136:
137: -- Cursor to get the Local Unit and Tax Municipality

Line 141: ,l_assignment_action_id pay_assignment_actions.ASSIGNMENT_ACTION_ID %type

137: -- Cursor to get the Local Unit and Tax Municipality
138:
139: /*
140: cursor csr_lu_mu (l_assignment_id per_all_assignments_f.ASSIGNMENT_ID%type
141: ,l_assignment_action_id pay_assignment_actions.ASSIGNMENT_ACTION_ID %type
142: ,p_date_earned DATE ) is
143: select scl.segment2 local_unit_id
144: ,rr.jurisdiction_code tax_mun_id
145: from per_all_assignments_f asg

Line 161: ,l_assignment_action_id pay_assignment_actions.ASSIGNMENT_ACTION_ID %type

157: */
158:
159: /* Bug Fix: 5042861 - Modified cursor csr_lu_mu for performance fix to remove MERGE JOIN CARTESIAN*/
160: cursor csr_lu_mu (l_assignment_id per_all_assignments_f.ASSIGNMENT_ID%type
161: ,l_assignment_action_id pay_assignment_actions.ASSIGNMENT_ACTION_ID %type
162: ,p_date_earned DATE
163: ,l_ele_type_id NUMBER ) is
164: SELECT scl.segment2 local_unit_id
165: ,rr.jurisdiction_code tax_mun_id

Line 166: FROM pay_assignment_actions assact

162: ,p_date_earned DATE
163: ,l_ele_type_id NUMBER ) is
164: SELECT scl.segment2 local_unit_id
165: ,rr.jurisdiction_code tax_mun_id
166: FROM pay_assignment_actions assact
167: ,per_all_assignments_f asg
168: ,hr_soft_coding_keyflex scl
169: ,pay_run_results rr
170: WHERE assact.assignment_action_id = l_assignment_action_id

Line 189: FROM pay_assignment_actions assact

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
190: ,pay_run_types_f prt
191: ,per_all_assignments_f asg
192: ,hr_soft_coding_keyflex scl
193: WHERE assact.PAYROLL_ACTION_ID = p_payroll_action_id

Line 216: cursor get_le_status(p_tax_unit_id pay_assignment_actions.TAX_UNIT_ID%TYPE) IS

212:
213: /* Bug No. : 4474602 and 4463136 */
214:
215: -- cursor to get STATUS from Legal Employer
216: cursor get_le_status(p_tax_unit_id pay_assignment_actions.TAX_UNIT_ID%TYPE) IS
217: select ORG_INFORMATION3
218: from HR_ORGANIZATION_INFORMATION
219: where ORGANIZATION_ID = p_tax_unit_id
220: and org_information_context = 'NO_LEGAL_EMPLOYER_DETAILS';

Line 271: (p_assignment_action_id IN pay_assignment_actions.ASSIGNMENT_ACTION_ID%type

267: ,g_mu_tab IN OUT NOCOPY PAY_NO_EMP_CONT.g_mu_tabtype ) RETURN NUMBER ;
268:
269:
270: FUNCTION check_under_62
271: (p_assignment_action_id IN pay_assignment_actions.ASSIGNMENT_ACTION_ID%type
272: ,p_date_earned IN DATE) RETURN VARCHAR2 ;
273:
274:
275: -- function to get the lookup meaning