DBA Data[Home] [Help]

APPS.PAY_CA_T4A_XML dependencies on PAY_CA_T4A_REG

Line 533: SUBSTR(pay_ca_t4a_reg.get_label('PAY_CA_T4A_FOOTNOTES',

529: code,
530: value
531: from ( select decode(l_box38,'13',hl.lookup_code,
532: SUBSTR(fdi.user_name,11,5)||': '||
533: SUBSTR(pay_ca_t4a_reg.get_label('PAY_CA_T4A_FOOTNOTES',
534: hl.lookup_code, l_lang),1,46)) code,
535: to_number(fai.value) value
536: from hr_lookups HL,
537: ff_database_items fdi,

Line 549: pay_ca_t4a_reg.get_label('PAY_CA_T4A_NONBOX_FOOTNOTES',

545: SUBSTR(FDI.USER_NAME, 17, instr(fdi.user_name,'AMT') - 18 )
546: union all
547: select
548: decode(l_box38,'13',hl.lookup_code,
549: pay_ca_t4a_reg.get_label('PAY_CA_T4A_NONBOX_FOOTNOTES',
550: hl.lookup_code, l_lang)),
551: to_number(pai.action_information5)
552: from pay_action_information pai,
553: hr_lookups hl