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_PAYROLL_ACTIONS

Line 129: (P_date pay_payroll_actions.effective_date%type

125:
126: -- Cursor definitions
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)

Line 140: ,pay_payroll_actions pact

136: nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)
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

Line 180: ,pay_payroll_actions pact

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

Line 182: ,pay_payroll_actions bact

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
186: and feed.balance_type_id = p_bal_id + decode(target.input_value_id,null, 0, 0)

Line 209: ,p_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type

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
213: ,pay_run_types_f prt

Line 227: ,p_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type

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
231: ,pay_run_types_f prt