DBA Data[Home] [Help]

APPS.PAY_JP_BALANCE_PKG dependencies on FND_DATE

Line 717: min(fnd_date.canonical_to_date(prrv.result_value))

713: INDEX(PAY_ASSIGNMENT_ACTIONS_PK PAA)
714: INDEX(PAY_PAYROLL_ACTIONS_PK PPA)
715: INDEX(PAY_RUN_RESULTS_N50 PRR)
716: INDEX(PAY_RUN_RESULT_VALUES_PK PRRV) */
717: min(fnd_date.canonical_to_date(prrv.result_value))
718: from pay_assignment_actions paa,
719: pay_payroll_actions ppa,
720: pay_run_results prr,
721: pay_run_result_values prrv

Line 984: min (fnd_date.canonical_to_date(decode(substr(piv.uom,1,1),'D',

980: INDEX(PAY_INPUT_VALUES_F_PK PIV)
981: INDEX(PAY_LINK_INPUT_VALUES_F_N2 PLIV)
982: INDEX(PAY_ELEMENT_ENTRIES_F_N51 PEE)
983: INDEX(PAY_ELEMENT_ENTRY_VALUES_F_N50 PEEV) */
984: min (fnd_date.canonical_to_date(decode(substr(piv.uom,1,1),'D',
985: decode(piv.hot_default_flag, 'Y',nvl(peev.screen_entry_value,nvl(pliv.default_value,piv.default_value)),
986: 'N',peev.screen_entry_value),null)))
987: from pay_input_values_f piv,
988: pay_link_input_values_f pliv,