DBA Data[Home] [Help]

APPS.PAY_FI_MTRR dependencies on DUAL

Line 126: FROM dual;

122: /* For Audit Report */
123: if l_data_source_code = 'PYFIMTRR' then
124: SELECT trim(rg_mtrr_rpt.action_information4)||' '||trim(rg_mtrr_rpt.action_information4)
125: INTO l_Wage_payment_month
126: FROM dual;
127:
128: IF rg_mtrr_rpt.action_information28 IS NULL THEN
129: l_due_date:=to_char(to_date('15'||trim(rg_mtrr_rpt.action_information4),'DDMMYYYY') ) ;
130: ELSE

Line 710: FROM dual;

706: ELSIF l_data_source_code = 'PYFIMTRREFT' then
707:
708: SELECT trim(rg_mtrr_rpt.action_information4)||' '||trim(rg_mtrr_rpt.action_information4)
709: INTO l_Wage_payment_month
710: FROM dual;
711: IF (NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information11),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information12),0)
712: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14),0)
713: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16),0)
714: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18),0)