DBA Data[Home] [Help]

APPS.PAY_JP_RETRO_PKG dependencies on PAY_BALANCE_FEEDS_F

Line 159: INDEX(FEED PAY_BALANCE_FEEDS_F_N2) */

155: INDEX(ASSACT PAY_ASSIGNMENT_ACTIONS_PK)
156: INDEX(PACT PAY_PAYROLL_ACTIONS_PK)
157: INDEX(PEE PAY_ELEMENT_ENTRIES_F_PK)
158: INDEX(TARGET PAY_RUN_RESULT_VALUES_N50)
159: INDEX(FEED PAY_BALANCE_FEEDS_F_N2) */
160: -- retro salary diff(adjusted amount to pay actually)
161: -- = retro salary to pay at target month(BACT) - retro salary paid at target month(PACT)
162: nvl(sum(decode(FEED.balance_type_id,
163: g_sal_id,fnd_number.canonical_to_number(TARGET.result_value)

Line 268: pay_balance_feeds_f FEED

264: pay_assignment_actions ASSACT, -- target assact
265: pay_payroll_actions PACT, -- target pact
266: pay_element_entries_f PEE, -- retro element entries
267: pay_run_result_values TARGET, -- target result value
268: pay_balance_feeds_f FEED
269: WHERE BACT_ASSACT.assignment_id = p_assignment_id
270: and PEPD.source_asg_action_id = BACT_ASSACT.assignment_action_id
271: and BACT.payroll_action_id = BACT_ASSACT.payroll_action_id
272: and RR.source_id = PEPD.element_entry_id

Line 301: INDEX(FEED PAY_BALANCE_FEEDS_F_N2) */

297: INDEX(ASSACT PAY_ASSIGNMENT_ACTIONS_PK)
298: INDEX(PACT PAY_PAYROLL_ACTIONS_PK)
299: INDEX(PEE PAY_ELEMENT_ENTRIES_F_PK)
300: INDEX(TARGET PAY_RUN_RESULT_VALUES_N50)
301: INDEX(FEED PAY_BALANCE_FEEDS_F_N2) */
302: nvl(sum(fnd_number.canonical_to_number(target.result_value)),0)
303: INTO g_retro_diff_value
304: FROM pay_assignment_actions BACT_ASSACT,
305: pay_entry_process_details PEPD,

Line 312: pay_balance_feeds_f FEED

308: pay_assignment_actions ASSACT,
309: pay_payroll_actions PACT,
310: pay_element_entries_f PEE,
311: pay_run_result_values TARGET,
312: pay_balance_feeds_f FEED
313: WHERE BACT_ASSACT.assignment_id = p_assignment_id
314: and PEPD.source_asg_action_id = BACT_ASSACT.assignment_action_id
315: and BACT.payroll_action_id = BACT_ASSACT.payroll_action_id
316: and to_char(BACT.effective_date,'YYYYMM')=to_char(l_min_effective_date,'YYYYMM')