DBA Data[Home] [Help]

APPS.PAY_US_FLS_REPORTING_PKG dependencies on PAY_ACTION_INFORMATION

Line 219: from pay_action_information pai,

215: decode(length(ltrim(rtrim(pai.action_information30))),
216: 11, pai.action_information30),
217: 'TRANSFER_TAX_TYPE_CODE=P', fcl.lookup_code,
218: 'TRANSFER_TAX_TYPE_DESC=P', fcl.description
219: from pay_action_information pai,
220: fnd_common_lookups fcl
221: where fcl.lookup_type = 'US_FLS_TAX_TYPES'
222: and pai.action_information_category in ('US FEDERAL',
223: 'US STATE',

Line 347: ( jurisdiction_code pay_action_information.jurisdiction_code%type

343: /*******************************************************************
344: ** PL/SQL Record to store the archived values.
345: *******************************************************************/
346: TYPE action_info_rec IS RECORD
347: ( jurisdiction_code pay_action_information.jurisdiction_code%type
348: ,action_information1 NUMBER(14,2) := 0
349: ,action_information2 NUMBER(14,2) := 0
350: ,action_information3 NUMBER(14,2) := 0
351: ,action_information4 NUMBER(14,2) := 0