DBA Data[Home] [Help]

APPS.PAY_US_FLS_REPORTING_PKG dependencies on PAY_ACTION_INFORMATION

Line 211: from pay_action_information pai,

207: decode(length(ltrim(rtrim(pai.action_information30))),
208: 11, pai.action_information30),
209: 'TRANSFER_TAX_TYPE_CODE=P', fcl.lookup_code,
210: 'TRANSFER_TAX_TYPE_DESC=P', fcl.description
211: from pay_action_information pai,
212: fnd_common_lookups fcl
213: where fcl.lookup_type = 'US_FLS_TAX_TYPES'
214: and pai.action_information_category in ('US FEDERAL',
215: 'US STATE',

Line 338: ( jurisdiction_code pay_action_information.jurisdiction_code%type

334: /*******************************************************************
335: ** PL/SQL Record to store the archived values.
336: *******************************************************************/
337: TYPE action_info_rec IS RECORD
338: ( jurisdiction_code pay_action_information.jurisdiction_code%type
339: ,action_information1 NUMBER(14,2) := 0
340: ,action_information2 NUMBER(14,2) := 0
341: ,action_information3 NUMBER(14,2) := 0
342: ,action_information4 NUMBER(14,2) := 0