DBA Data[Home] [Help]

APPS.PAY_CA_RL2_MAG dependencies on FND_NUMBER

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

1401: l_all_box_0 BOOLEAN;
1402:
1403: /* Cursor for fetching the Footnote Codes */
1404: CURSOR c_footnote_codes ( p_assg_actid number) is
1405: SELECT hl.meaning code, fnd_number.canonical_to_number(FT.FOOTNOTE_AMOUNT) value
1406: FROM PAY_CA_EOY_RL2_FOOTNOTE_INFO_V FT,
1407: HR_LOOKUPS HL
1408: WHERE FT.ASSIGNMENT_ACTION_ID = p_assg_actid
1409: AND ((HL.LOOKUP_TYPE = 'PAY_CA_RL2_FOOTNOTES'