APPS.PAY_NO_EMP_CONT_2007 dependencies on PAY_RUN_RESULTS

Line 132: , p_jur_code pay_run_results.jurisdiction_code%type

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

Line 133: , p_local_unit pay_run_results.local_unit_id%type)

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

Line 139: ,pay_run_results rr

135: select
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

Line 171: , p_jur_code pay_run_results.jurisdiction_code%type

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)
175: from

Line 172: , p_local_unit pay_run_results.local_unit_id%type

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)
175: from
176:

Line 179: ,pay_run_results rr

175: from
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