DBA Data[Home] [Help]

APPS.PAY_CA_RL2_AMEND_MAG dependencies on FND_NUMBER

Line 1589: SELECT hl.meaning code, fnd_number.canonical_to_number(FT.FOOTNOTE_AMOUNT) value

1585: l_all_box_0 BOOLEAN;
1586:
1587: /* Cursor for fetching the Footnote Codes */
1588: CURSOR c_footnote_codes ( p_assg_actid number) is
1589: SELECT hl.meaning code, fnd_number.canonical_to_number(FT.FOOTNOTE_AMOUNT) value
1590: FROM PAY_CA_EOY_RL2_FOOTNOTE_INFO_V FT,
1591: HR_LOOKUPS HL
1592: WHERE FT.ASSIGNMENT_ACTION_ID = p_assg_actid
1593: AND ((HL.LOOKUP_TYPE = 'PAY_CA_RL2_FOOTNOTES'