eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_FI_MTRR dependencies on FND_NUMBER

Line 136: l_sum := TRIM((TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15),0) +

132: END IF;
133:
134: l_ref_number:= rg_mtrr_rpt.action_information29 ;
135:
136: l_sum := TRIM((TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15),0) +
137: NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17),0) +
138: NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19),0)
139: - ( NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16),0)
140: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18),0)

Line 137: NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17),0) +

133:
134: l_ref_number:= rg_mtrr_rpt.action_information29 ;
135:
136: l_sum := TRIM((TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15),0) +
137: NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17),0) +
138: NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19),0)
139: - ( NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16),0)
140: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18),0)
141: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20),0) ) ,'999G999G990D99')));

Line 138: NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19),0)

134: l_ref_number:= rg_mtrr_rpt.action_information29 ;
135:
136: l_sum := TRIM((TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15),0) +
137: NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17),0) +
138: NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19),0)
139: - ( NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16),0)
140: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18),0)
141: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20),0) ) ,'999G999G990D99')));
142:

Line 139: - ( NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16),0)

135:
136: l_sum := TRIM((TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15),0) +
137: NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17),0) +
138: NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19),0)
139: - ( NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16),0)
140: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18),0)
141: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20),0) ) ,'999G999G990D99')));
142:
143: IF NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information21),0) = 0 THEN

Line 140: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18),0)

136: l_sum := TRIM((TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15),0) +
137: NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17),0) +
138: NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19),0)
139: - ( NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16),0)
140: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18),0)
141: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20),0) ) ,'999G999G990D99')));
142:
143: IF NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information21),0) = 0 THEN
144: l_no_vat_month:= rg_mtrr_rpt.action_information4||' '||rg_mtrr_rpt.action_information4;

Line 141: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20),0) ) ,'999G999G990D99')));

137: NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17),0) +
138: NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19),0)
139: - ( NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16),0)
140: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18),0)
141: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20),0) ) ,'999G999G990D99')));
142:
143: IF NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information21),0) = 0 THEN
144: l_no_vat_month:= rg_mtrr_rpt.action_information4||' '||rg_mtrr_rpt.action_information4;
145:

Line 143: IF NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information21),0) = 0 THEN

139: - ( NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16),0)
140: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18),0)
141: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20),0) ) ,'999G999G990D99')));
142:
143: IF NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information21),0) = 0 THEN
144: l_no_vat_month:= rg_mtrr_rpt.action_information4||' '||rg_mtrr_rpt.action_information4;
145:
146:
147: END IF;

Line 149: 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)

145:
146:
147: END IF;
148:
149: 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)
150: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14),0)
151: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16),0)
152: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18),0)
153: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20),0) )

Line 150: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14),0)

146:
147: END IF;
148:
149: 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)
150: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14),0)
151: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16),0)
152: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18),0)
153: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20),0) )
154: = 0 THEN

Line 151: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16),0)

147: END IF;
148:
149: 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)
150: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14),0)
151: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16),0)
152: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18),0)
153: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20),0) )
154: = 0 THEN
155:

Line 152: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18),0)

148:
149: 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)
150: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14),0)
151: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16),0)
152: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18),0)
153: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20),0) )
154: = 0 THEN
155:
156: l_none_payment_month := rg_mtrr_rpt.action_information4||' '||rg_mtrr_rpt.action_information4;

Line 153: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20),0) )

149: 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)
150: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14),0)
151: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16),0)
152: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18),0)
153: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20),0) )
154: = 0 THEN
155:
156: l_none_payment_month := rg_mtrr_rpt.action_information4||' '||rg_mtrr_rpt.action_information4;
157:

Line 160: l_x80_code := LPAD(TRIM((TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15),0) - NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16),0),'999999999D99'))) ,11,'0');

156: l_none_payment_month := rg_mtrr_rpt.action_information4||' '||rg_mtrr_rpt.action_information4;
157:
158: END IF;
159:
160: l_x80_code := LPAD(TRIM((TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15),0) - NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16),0),'999999999D99'))) ,11,'0');
161: l_x81_code := LPAD(TRIM((TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17),0) - NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18),0),'999999999D99'))) ,11,'0');
162: l_x82_code := LPAD(TRIM((TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19),0) - NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20),0),'999999999D99'))) ,11,'0');
163:
164: l_sal_subject_wt := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information11))))) ;

Line 161: l_x81_code := LPAD(TRIM((TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17),0) - NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18),0),'999999999D99'))) ,11,'0');

157:
158: END IF;
159:
160: l_x80_code := LPAD(TRIM((TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15),0) - NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16),0),'999999999D99'))) ,11,'0');
161: l_x81_code := LPAD(TRIM((TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17),0) - NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18),0),'999999999D99'))) ,11,'0');
162: l_x82_code := LPAD(TRIM((TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19),0) - NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20),0),'999999999D99'))) ,11,'0');
163:
164: l_sal_subject_wt := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information11))))) ;
165: l_sal_subject_ts := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information12))))) ;

Line 162: l_x82_code := LPAD(TRIM((TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19),0) - NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20),0),'999999999D99'))) ,11,'0');

158: END IF;
159:
160: l_x80_code := LPAD(TRIM((TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15),0) - NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16),0),'999999999D99'))) ,11,'0');
161: l_x81_code := LPAD(TRIM((TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17),0) - NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18),0),'999999999D99'))) ,11,'0');
162: l_x82_code := LPAD(TRIM((TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19),0) - NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20),0),'999999999D99'))) ,11,'0');
163:
164: l_sal_subject_wt := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information11))))) ;
165: l_sal_subject_ts := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information12))))) ;
166: l_pay_subject_wt := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13))))) ;

Line 164: l_sal_subject_wt := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information11))))) ;

160: l_x80_code := LPAD(TRIM((TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15),0) - NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16),0),'999999999D99'))) ,11,'0');
161: l_x81_code := LPAD(TRIM((TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17),0) - NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18),0),'999999999D99'))) ,11,'0');
162: l_x82_code := LPAD(TRIM((TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19),0) - NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20),0),'999999999D99'))) ,11,'0');
163:
164: l_sal_subject_wt := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information11))))) ;
165: l_sal_subject_ts := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information12))))) ;
166: l_pay_subject_wt := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13))))) ;
167: l_pay_subject_ts := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14))))) ;
168: l_wt_deduction := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15))))) ;

Line 165: l_sal_subject_ts := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information12))))) ;

161: l_x81_code := LPAD(TRIM((TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17),0) - NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18),0),'999999999D99'))) ,11,'0');
162: l_x82_code := LPAD(TRIM((TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19),0) - NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20),0),'999999999D99'))) ,11,'0');
163:
164: l_sal_subject_wt := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information11))))) ;
165: l_sal_subject_ts := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information12))))) ;
166: l_pay_subject_wt := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13))))) ;
167: l_pay_subject_ts := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14))))) ;
168: l_wt_deduction := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15))))) ;
169: l_adjustment_wt := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16))))) ;

Line 166: l_pay_subject_wt := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13))))) ;

162: l_x82_code := LPAD(TRIM((TO_CHAR(NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19),0) - NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20),0),'999999999D99'))) ,11,'0');
163:
164: l_sal_subject_wt := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information11))))) ;
165: l_sal_subject_ts := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information12))))) ;
166: l_pay_subject_wt := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13))))) ;
167: l_pay_subject_ts := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14))))) ;
168: l_wt_deduction := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15))))) ;
169: l_adjustment_wt := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16))))) ;
170: l_employer_ss_fee := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17))))) ;

Line 167: l_pay_subject_ts := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14))))) ;

163:
164: l_sal_subject_wt := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information11))))) ;
165: l_sal_subject_ts := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information12))))) ;
166: l_pay_subject_wt := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13))))) ;
167: l_pay_subject_ts := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14))))) ;
168: l_wt_deduction := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15))))) ;
169: l_adjustment_wt := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16))))) ;
170: l_employer_ss_fee := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17))))) ;
171: l_adjustment_ss := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18))))) ;

Line 168: l_wt_deduction := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15))))) ;

164: l_sal_subject_wt := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information11))))) ;
165: l_sal_subject_ts := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information12))))) ;
166: l_pay_subject_wt := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13))))) ;
167: l_pay_subject_ts := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14))))) ;
168: l_wt_deduction := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15))))) ;
169: l_adjustment_wt := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16))))) ;
170: l_employer_ss_fee := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17))))) ;
171: l_adjustment_ss := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18))))) ;
172: l_ts_deduction := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19))))) ;

Line 169: l_adjustment_wt := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16))))) ;

165: l_sal_subject_ts := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information12))))) ;
166: l_pay_subject_wt := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13))))) ;
167: l_pay_subject_ts := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14))))) ;
168: l_wt_deduction := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15))))) ;
169: l_adjustment_wt := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16))))) ;
170: l_employer_ss_fee := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17))))) ;
171: l_adjustment_ss := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18))))) ;
172: l_ts_deduction := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19))))) ;
173: l_adjustment_ts := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20))))) ;

Line 170: l_employer_ss_fee := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17))))) ;

166: l_pay_subject_wt := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13))))) ;
167: l_pay_subject_ts := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14))))) ;
168: l_wt_deduction := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15))))) ;
169: l_adjustment_wt := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16))))) ;
170: l_employer_ss_fee := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17))))) ;
171: l_adjustment_ss := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18))))) ;
172: l_ts_deduction := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19))))) ;
173: l_adjustment_ts := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20))))) ;
174: l_vat := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information21))))) ;

Line 171: l_adjustment_ss := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18))))) ;

167: l_pay_subject_ts := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14))))) ;
168: l_wt_deduction := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15))))) ;
169: l_adjustment_wt := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16))))) ;
170: l_employer_ss_fee := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17))))) ;
171: l_adjustment_ss := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18))))) ;
172: l_ts_deduction := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19))))) ;
173: l_adjustment_ts := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20))))) ;
174: l_vat := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information21))))) ;
175: l_subsidy_tax_source := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information3))))) ;

Line 172: l_ts_deduction := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19))))) ;

168: l_wt_deduction := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15))))) ;
169: l_adjustment_wt := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16))))) ;
170: l_employer_ss_fee := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17))))) ;
171: l_adjustment_ss := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18))))) ;
172: l_ts_deduction := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19))))) ;
173: l_adjustment_ts := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20))))) ;
174: l_vat := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information21))))) ;
175: l_subsidy_tax_source := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information3))))) ;
176: l_subsidy_withhold_tax := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information30))))) ;

Line 173: l_adjustment_ts := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20))))) ;

169: l_adjustment_wt := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16))))) ;
170: l_employer_ss_fee := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17))))) ;
171: l_adjustment_ss := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18))))) ;
172: l_ts_deduction := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19))))) ;
173: l_adjustment_ts := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20))))) ;
174: l_vat := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information21))))) ;
175: l_subsidy_tax_source := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information3))))) ;
176: l_subsidy_withhold_tax := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information30))))) ;
177:

Line 174: l_vat := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information21))))) ;

170: l_employer_ss_fee := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17))))) ;
171: l_adjustment_ss := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18))))) ;
172: l_ts_deduction := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19))))) ;
173: l_adjustment_ts := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20))))) ;
174: l_vat := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information21))))) ;
175: l_subsidy_tax_source := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information3))))) ;
176: l_subsidy_withhold_tax := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information30))))) ;
177:
178: l_sal_subject_wt_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information11) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information11)),'D99'))),2,2);

Line 175: l_subsidy_tax_source := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information3))))) ;

171: l_adjustment_ss := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18))))) ;
172: l_ts_deduction := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19))))) ;
173: l_adjustment_ts := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20))))) ;
174: l_vat := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information21))))) ;
175: l_subsidy_tax_source := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information3))))) ;
176: l_subsidy_withhold_tax := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information30))))) ;
177:
178: l_sal_subject_wt_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information11) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information11)),'D99'))),2,2);
179: l_sal_subject_ts_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information12) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information12)),'D99'))),2,2);

Line 176: l_subsidy_withhold_tax := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information30))))) ;

172: l_ts_deduction := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19))))) ;
173: l_adjustment_ts := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20))))) ;
174: l_vat := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information21))))) ;
175: l_subsidy_tax_source := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information3))))) ;
176: l_subsidy_withhold_tax := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information30))))) ;
177:
178: l_sal_subject_wt_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information11) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information11)),'D99'))),2,2);
179: l_sal_subject_ts_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information12) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information12)),'D99'))),2,2);
180: l_pay_subject_wt_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13)),'D99'))),2,2);

Line 178: l_sal_subject_wt_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information11) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information11)),'D99'))),2,2);

174: l_vat := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information21))))) ;
175: l_subsidy_tax_source := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information3))))) ;
176: l_subsidy_withhold_tax := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information30))))) ;
177:
178: l_sal_subject_wt_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information11) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information11)),'D99'))),2,2);
179: l_sal_subject_ts_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information12) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information12)),'D99'))),2,2);
180: l_pay_subject_wt_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13)),'D99'))),2,2);
181: l_pay_subject_ts_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14)),'D99'))),2,2);
182: l_wt_deduction_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15)),'D99'))),2,2);

Line 179: l_sal_subject_ts_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information12) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information12)),'D99'))),2,2);

175: l_subsidy_tax_source := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information3))))) ;
176: l_subsidy_withhold_tax := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information30))))) ;
177:
178: l_sal_subject_wt_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information11) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information11)),'D99'))),2,2);
179: l_sal_subject_ts_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information12) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information12)),'D99'))),2,2);
180: l_pay_subject_wt_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13)),'D99'))),2,2);
181: l_pay_subject_ts_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14)),'D99'))),2,2);
182: l_wt_deduction_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15)),'D99'))),2,2);
183: l_adjustment_wt_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16)),'D99'))),2,2);

Line 180: l_pay_subject_wt_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13)),'D99'))),2,2);

176: l_subsidy_withhold_tax := TRIM((TO_CHAR(FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information30))))) ;
177:
178: l_sal_subject_wt_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information11) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information11)),'D99'))),2,2);
179: l_sal_subject_ts_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information12) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information12)),'D99'))),2,2);
180: l_pay_subject_wt_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13)),'D99'))),2,2);
181: l_pay_subject_ts_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14)),'D99'))),2,2);
182: l_wt_deduction_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15)),'D99'))),2,2);
183: l_adjustment_wt_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16)),'D99'))),2,2);
184: l_employer_ss_fee_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17)),'D99'))),2,2);

Line 181: l_pay_subject_ts_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14)),'D99'))),2,2);

177:
178: l_sal_subject_wt_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information11) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information11)),'D99'))),2,2);
179: l_sal_subject_ts_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information12) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information12)),'D99'))),2,2);
180: l_pay_subject_wt_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13)),'D99'))),2,2);
181: l_pay_subject_ts_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14)),'D99'))),2,2);
182: l_wt_deduction_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15)),'D99'))),2,2);
183: l_adjustment_wt_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16)),'D99'))),2,2);
184: l_employer_ss_fee_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17)),'D99'))),2,2);
185: l_adjustment_ss_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18)),'D99'))),2,2);

Line 182: l_wt_deduction_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15)),'D99'))),2,2);

178: l_sal_subject_wt_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information11) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information11)),'D99'))),2,2);
179: l_sal_subject_ts_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information12) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information12)),'D99'))),2,2);
180: l_pay_subject_wt_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13)),'D99'))),2,2);
181: l_pay_subject_ts_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14)),'D99'))),2,2);
182: l_wt_deduction_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15)),'D99'))),2,2);
183: l_adjustment_wt_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16)),'D99'))),2,2);
184: l_employer_ss_fee_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17)),'D99'))),2,2);
185: l_adjustment_ss_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18)),'D99'))),2,2);
186: l_ts_deduction_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19)),'D99'))),2,2);

Line 183: l_adjustment_wt_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16)),'D99'))),2,2);

179: l_sal_subject_ts_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information12) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information12)),'D99'))),2,2);
180: l_pay_subject_wt_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13)),'D99'))),2,2);
181: l_pay_subject_ts_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14)),'D99'))),2,2);
182: l_wt_deduction_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15)),'D99'))),2,2);
183: l_adjustment_wt_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16)),'D99'))),2,2);
184: l_employer_ss_fee_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17)),'D99'))),2,2);
185: l_adjustment_ss_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18)),'D99'))),2,2);
186: l_ts_deduction_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19)),'D99'))),2,2);
187: l_adjustment_ts_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20)),'D99'))),2,2);

Line 184: l_employer_ss_fee_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17)),'D99'))),2,2);

180: l_pay_subject_wt_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13)),'D99'))),2,2);
181: l_pay_subject_ts_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14)),'D99'))),2,2);
182: l_wt_deduction_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15)),'D99'))),2,2);
183: l_adjustment_wt_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16)),'D99'))),2,2);
184: l_employer_ss_fee_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17)),'D99'))),2,2);
185: l_adjustment_ss_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18)),'D99'))),2,2);
186: l_ts_deduction_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19)),'D99'))),2,2);
187: l_adjustment_ts_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20)),'D99'))),2,2);
188: l_vat_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information21) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information21)),'D99'))),2,2);

Line 185: l_adjustment_ss_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18)),'D99'))),2,2);

181: l_pay_subject_ts_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14)),'D99'))),2,2);
182: l_wt_deduction_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15)),'D99'))),2,2);
183: l_adjustment_wt_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16)),'D99'))),2,2);
184: l_employer_ss_fee_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17)),'D99'))),2,2);
185: l_adjustment_ss_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18)),'D99'))),2,2);
186: l_ts_deduction_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19)),'D99'))),2,2);
187: l_adjustment_ts_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20)),'D99'))),2,2);
188: l_vat_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information21) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information21)),'D99'))),2,2);
189: l_subsidy_tax_source_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information3) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information3)),'D99'))),2,2);

Line 186: l_ts_deduction_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19)),'D99'))),2,2);

182: l_wt_deduction_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15)),'D99'))),2,2);
183: l_adjustment_wt_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16)),'D99'))),2,2);
184: l_employer_ss_fee_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17)),'D99'))),2,2);
185: l_adjustment_ss_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18)),'D99'))),2,2);
186: l_ts_deduction_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19)),'D99'))),2,2);
187: l_adjustment_ts_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20)),'D99'))),2,2);
188: l_vat_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information21) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information21)),'D99'))),2,2);
189: l_subsidy_tax_source_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information3) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information3)),'D99'))),2,2);
190: l_subsidy_withhold_tax_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information30) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information30)),'D99'))),2,2);

Line 187: l_adjustment_ts_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20)),'D99'))),2,2);

183: l_adjustment_wt_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16)),'D99'))),2,2);
184: l_employer_ss_fee_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17)),'D99'))),2,2);
185: l_adjustment_ss_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18)),'D99'))),2,2);
186: l_ts_deduction_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19)),'D99'))),2,2);
187: l_adjustment_ts_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20)),'D99'))),2,2);
188: l_vat_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information21) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information21)),'D99'))),2,2);
189: l_subsidy_tax_source_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information3) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information3)),'D99'))),2,2);
190: l_subsidy_withhold_tax_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information30) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information30)),'D99'))),2,2);
191:

Line 188: l_vat_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information21) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information21)),'D99'))),2,2);

184: l_employer_ss_fee_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17)),'D99'))),2,2);
185: l_adjustment_ss_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18)),'D99'))),2,2);
186: l_ts_deduction_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19)),'D99'))),2,2);
187: l_adjustment_ts_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20)),'D99'))),2,2);
188: l_vat_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information21) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information21)),'D99'))),2,2);
189: l_subsidy_tax_source_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information3) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information3)),'D99'))),2,2);
190: l_subsidy_withhold_tax_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information30) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information30)),'D99'))),2,2);
191:
192:

Line 189: l_subsidy_tax_source_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information3) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information3)),'D99'))),2,2);

185: l_adjustment_ss_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18)),'D99'))),2,2);
186: l_ts_deduction_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19)),'D99'))),2,2);
187: l_adjustment_ts_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20)),'D99'))),2,2);
188: l_vat_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information21) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information21)),'D99'))),2,2);
189: l_subsidy_tax_source_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information3) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information3)),'D99'))),2,2);
190: l_subsidy_withhold_tax_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information30) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information30)),'D99'))),2,2);
191:
192:
193:

Line 190: l_subsidy_withhold_tax_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information30) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information30)),'D99'))),2,2);

186: l_ts_deduction_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19)),'D99'))),2,2);
187: l_adjustment_ts_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20)),'D99'))),2,2);
188: l_vat_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information21) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information21)),'D99'))),2,2);
189: l_subsidy_tax_source_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information3) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information3)),'D99'))),2,2);
190: l_subsidy_withhold_tax_c := SUBSTR(TRIM((TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information30) - FLOOR(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information30)),'D99'))),2,2);
191:
192:
193:
194: hr_utility.set_location('Before populating pl/sql table',20);

Line 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)

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)
715: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20),0) )

Line 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)

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)
715: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20),0) )
716: = 0 THEN

Line 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)

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)
715: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20),0) )
716: = 0 THEN
717:

Line 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)

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)
715: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20),0) )
716: = 0 THEN
717:
718: l_none_payment_month := rg_mtrr_rpt.action_information4||' '||rg_mtrr_rpt.action_information4;

Line 715: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20),0) )

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)
715: + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19),0) + NVL(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20),0) )
716: = 0 THEN
717:
718: l_none_payment_month := rg_mtrr_rpt.action_information4||' '||rg_mtrr_rpt.action_information4;
719: END IF;

Line 740: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information11),2) * 100;

736: gtagdata(l_counter).TagValue := rg_mtrr_rpt.action_information4;
737: l_counter := l_counter + 1;
738:
739: gtagdata(l_counter).TagName := 'SAL_SUBJECT_WT';
740: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information11),2) * 100;
741: l_counter := l_counter + 1;
742:
743: gtagdata(l_counter).TagName := 'SAL_SUBJECT_TS';
744: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information12),2) * 100;

Line 744: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information12),2) * 100;

740: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information11),2) * 100;
741: l_counter := l_counter + 1;
742:
743: gtagdata(l_counter).TagName := 'SAL_SUBJECT_TS';
744: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information12),2) * 100;
745: l_counter := l_counter + 1;
746:
747: gtagdata(l_counter).TagName := 'PAY_SUBJECT_WT';
748: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13),2) * 100;

Line 748: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13),2) * 100;

744: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information12),2) * 100;
745: l_counter := l_counter + 1;
746:
747: gtagdata(l_counter).TagName := 'PAY_SUBJECT_WT';
748: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13),2) * 100;
749: l_counter := l_counter + 1;
750:
751: gtagdata(l_counter).TagName := 'PAY_SUBJECT_TS';
752: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14),2) * 100;

Line 752: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14),2) * 100;

748: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information13),2) * 100;
749: l_counter := l_counter + 1;
750:
751: gtagdata(l_counter).TagName := 'PAY_SUBJECT_TS';
752: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14),2) * 100;
753: l_counter := l_counter + 1;
754:
755: gtagdata(l_counter).TagName := 'WT_DEDUCTION';
756: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15),2) * 100;

Line 756: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15),2) * 100;

752: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information14),2) * 100;
753: l_counter := l_counter + 1;
754:
755: gtagdata(l_counter).TagName := 'WT_DEDUCTION';
756: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15),2) * 100;
757: l_counter := l_counter + 1;
758:
759: gtagdata(l_counter).TagName := 'ADJUSTMENT_WT';
760: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16),2) * 100;

Line 760: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16),2) * 100;

756: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information15),2) * 100;
757: l_counter := l_counter + 1;
758:
759: gtagdata(l_counter).TagName := 'ADJUSTMENT_WT';
760: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16),2) * 100;
761: l_counter := l_counter + 1;
762:
763: gtagdata(l_counter).TagName := 'SUB_WITHHOLD';
764: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information30),2) * 100;

Line 764: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information30),2) * 100;

760: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information16),2) * 100;
761: l_counter := l_counter + 1;
762:
763: gtagdata(l_counter).TagName := 'SUB_WITHHOLD';
764: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information30),2) * 100;
765: l_counter := l_counter + 1;
766:
767: gtagdata(l_counter).TagName := 'EMPLOYER_SS_FEE';
768: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17),2) * 100;

Line 768: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17),2) * 100;

764: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information30),2) * 100;
765: l_counter := l_counter + 1;
766:
767: gtagdata(l_counter).TagName := 'EMPLOYER_SS_FEE';
768: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17),2) * 100;
769: l_counter := l_counter + 1;
770:
771: gtagdata(l_counter).TagName := 'ADJUSTMENT_SS';
772: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18),2) * 100;

Line 772: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18),2) * 100;

768: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information17),2) * 100;
769: l_counter := l_counter + 1;
770:
771: gtagdata(l_counter).TagName := 'ADJUSTMENT_SS';
772: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18),2) * 100;
773: l_counter := l_counter + 1;
774:
775: gtagdata(l_counter).TagName := 'TS_DEDUCTION';
776: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19),2) * 100;

Line 776: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19),2) * 100;

772: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information18),2) * 100;
773: l_counter := l_counter + 1;
774:
775: gtagdata(l_counter).TagName := 'TS_DEDUCTION';
776: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19),2) * 100;
777: l_counter := l_counter + 1;
778:
779: gtagdata(l_counter).TagName := 'ADJUSTMENT_TS';
780: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20),2) * 100;

Line 780: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20),2) * 100;

776: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information19),2) * 100;
777: l_counter := l_counter + 1;
778:
779: gtagdata(l_counter).TagName := 'ADJUSTMENT_TS';
780: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information20),2) * 100;
781: l_counter := l_counter + 1;
782:
783:
784: gtagdata(l_counter).TagName := 'SUB_TAX_SOURCE';

Line 785: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information3),2) * 100;

781: l_counter := l_counter + 1;
782:
783:
784: gtagdata(l_counter).TagName := 'SUB_TAX_SOURCE';
785: gtagdata(l_counter).TagValue := ROUND(FND_NUMBER.CANONICAL_TO_NUMBER(rg_mtrr_rpt.action_information3),2) * 100;
786: l_counter := l_counter + 1;
787:
788: if l_none_payment_month is not null then
789: gtagdata(l_counter).TagName := 'NO_PAY_MNTH';