DBA Data[Home] [Help]

APPS.PAY_JP_BALANCE_PKG dependencies on FND_NUMBER

Line 327: nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)

323: INDEX(PAY_PAYROLL_ACTIONS_PK PACT)
324: INDEX(PAY_BALANCE_FEEDS_F_FK1 FEED)
325: INDEX(PAY_RUN_RESULTS_N50 RR)
326: INDEX(PAY_RUN_RESULT_VALUES_PK TARGET) */
327: nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)
328: FROM pay_assignment_actions ASSACT,
329: pay_payroll_actions PACT,
330: pay_balance_feeds_f FEED,
331: pay_run_results RR,

Line 354: nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)

350: INDEX(PAY_PAYROLL_ACTIONS_PK PACT)
351: INDEX(PAY_BALANCE_FEEDS_F_FK1 FEED)
352: INDEX(PAY_RUN_RESULTS_N50 RR)
353: INDEX(PAY_RUN_RESULT_VALUES_PK TARGET) */
354: nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)
355: FROM
356: pay_assignment_actions ASSACT,
357: pay_payroll_actions PACT,
358: pay_balance_feeds_f FEED,

Line 470: sum(fnd_number.canonical_to_number(prrv.result_value))

466: INDEX(PAY_ASSIGNMENT_ACTIONS_PK PAA)
467: INDEX(PAY_PAYROLL_ACTIONS_PK PPA)
468: INDEX(PAY_RUN_RESULTS_N50 PRR)
469: INDEX(PAY_RUN_RESULT_VALUES_PK PRRV) */
470: sum(fnd_number.canonical_to_number(prrv.result_value))
471: from pay_assignment_actions paa,
472: pay_payroll_actions ppa,
473: pay_run_results prr,
474: pay_run_result_values prrv

Line 633: min(fnd_number.canonical_to_number(prrv.result_value))

629: INDEX(PAY_ASSIGNMENT_ACTIONS_PK PAA)
630: INDEX(PAY_PAYROLL_ACTIONS_PK PPA)
631: INDEX(PAY_RUN_RESULTS_N50 PRR)
632: INDEX(PAY_RUN_RESULT_VALUES_PK PRRV) */
633: min(fnd_number.canonical_to_number(prrv.result_value))
634: from pay_assignment_actions paa,
635: pay_payroll_actions ppa,
636: pay_run_results prr,
637: pay_run_result_values prrv

Line 888: min(fnd_number.canonical_to_number(decode(decode(substr(piv.uom,1,1),'M','N','N','N','I','N','H','N',null),'N',

884: INDEX(PAY_INPUT_VALUES_F_PK PIV)
885: INDEX(PAY_LINK_INPUT_VALUES_F_N2 PLIV)
886: INDEX(PAY_ELEMENT_ENTRIES_F_N51 PEE)
887: INDEX(PAY_ELEMENT_ENTRY_VALUES_F_N50 PEEV) */
888: min(fnd_number.canonical_to_number(decode(decode(substr(piv.uom,1,1),'M','N','N','N','I','N','H','N',null),'N',
889: decode(piv.hot_default_flag, 'Y',nvl(peev.screen_entry_value,nvl(pliv.default_value,piv.default_value)),
890: 'N',peev.screen_entry_value),null)))
891: from pay_input_values_f piv,
892: pay_link_input_values_f pliv,