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_2007 dependencies on PAY_ASSIGNMENT_ACTIONS

Line 131: , p_tax_id pay_assignment_Actions.tax_unit_id%type

127: -- added by rp 29-dec-2012
128: cursor get_TU_MU_LU_BIMONTH
129: (P_date pay_payroll_actions.effective_date%type
130: , p_bal_id pay_balance_types.balance_type_id%type
131: , p_tax_id pay_assignment_Actions.tax_unit_id%type
132: , p_jur_code pay_run_results.jurisdiction_code%type
133: , p_local_unit pay_run_results.local_unit_id%type)
134: is
135: select

Line 141: ,pay_assignment_actions assact

137: from pay_balance_feeds_f feed
138: ,pay_run_result_values target
139: ,pay_run_results rr
140: ,pay_payroll_actions pact
141: ,pay_assignment_actions assact
142: where feed.balance_type_id = p_bal_id + decode(target.input_value_id,null, 0, 0)
143: and feed.input_value_id = target.input_value_id
144: and target.run_result_id = rr.run_result_id
145: and nvl(target.result_value,'0') <> '0'

Line 168: (P_asg_id pay_assignment_Actions.assignment_Action_id%type

164: where pbt.balance_name = p_bal_name
165: and pbt.legislation_code = 'NO';
166:
167: cursor get_ASG_TU_MU_LU_BIMONTH
168: (P_asg_id pay_assignment_Actions.assignment_Action_id%type
169: , p_bal_id pay_balance_types.balance_type_id%type
170: , p_tax_id pay_assignment_Actions.tax_unit_id%type
171: , p_jur_code pay_run_results.jurisdiction_code%type
172: , p_local_unit pay_run_results.local_unit_id%type

Line 170: , p_tax_id pay_assignment_Actions.tax_unit_id%type

166:
167: cursor get_ASG_TU_MU_LU_BIMONTH
168: (P_asg_id pay_assignment_Actions.assignment_Action_id%type
169: , p_bal_id pay_balance_types.balance_type_id%type
170: , p_tax_id pay_assignment_Actions.tax_unit_id%type
171: , p_jur_code pay_run_results.jurisdiction_code%type
172: , p_local_unit pay_run_results.local_unit_id%type
173: ) is
174: select nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)

Line 181: ,pay_assignment_actions assact

177: pay_balance_feeds_f feed
178: ,pay_run_result_values target
179: ,pay_run_results rr
180: ,pay_payroll_actions pact
181: ,pay_assignment_actions assact
182: ,pay_payroll_actions bact
183: ,pay_assignment_actions bal_assact
184: where bal_assact.assignment_action_id = P_asg_id
185: and bal_assact.payroll_action_id = bact.payroll_action_id

Line 183: ,pay_assignment_actions bal_assact

179: ,pay_run_results rr
180: ,pay_payroll_actions pact
181: ,pay_assignment_actions assact
182: ,pay_payroll_actions bact
183: ,pay_assignment_actions bal_assact
184: where bal_assact.assignment_action_id = P_asg_id
185: and bal_assact.payroll_action_id = bact.payroll_action_id
186: and feed.balance_type_id = p_bal_id + decode(target.input_value_id,null, 0, 0)
187: and feed.input_value_id = target.input_value_id

Line 208: (p_tax_unit_id pay_assignment_actions.TAX_UNIT_ID%TYPE

204: -- End 29-dec-2012
205:
206: -- csr to get the current assignment_action_ids with the same LE
207: cursor csr_curr_le_asg_act_id
208: (p_tax_unit_id pay_assignment_actions.TAX_UNIT_ID%TYPE
209: ,p_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type
210: ,p_date_earned DATE ) is
211: select pact.ASSIGNMENT_ACTION_ID
212: from pay_assignment_actions pact

Line 212: from pay_assignment_actions pact

208: (p_tax_unit_id pay_assignment_actions.TAX_UNIT_ID%TYPE
209: ,p_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type
210: ,p_date_earned DATE ) is
211: select pact.ASSIGNMENT_ACTION_ID
212: from pay_assignment_actions pact
213: ,pay_run_types_f prt
214: where pact.PAYROLL_ACTION_ID = p_payroll_action_id
215: and pact.TAX_UNIT_ID = p_tax_unit_id
216: and prt.LEGISLATION_CODE = 'NO'

Line 226: (p_tax_unit_id pay_assignment_actions.TAX_UNIT_ID%TYPE

222: ------------- Remove this
223: -- testing the number of rows returned by the above cursor
224: -- csr to get the current assignment_action_ids with the same LE
225: cursor csr_test_aag_act_id
226: (p_tax_unit_id pay_assignment_actions.TAX_UNIT_ID%TYPE
227: ,p_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type
228: ,p_date_earned DATE ) is
229: select count(*)
230: from pay_assignment_actions pact

Line 230: from pay_assignment_actions pact

226: (p_tax_unit_id pay_assignment_actions.TAX_UNIT_ID%TYPE
227: ,p_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type
228: ,p_date_earned DATE ) is
229: select count(*)
230: from pay_assignment_actions pact
231: ,pay_run_types_f prt
232: where pact.PAYROLL_ACTION_ID = p_payroll_action_id
233: and pact.TAX_UNIT_ID = p_tax_unit_id
234: and prt.LEGISLATION_CODE = 'NO'