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_CNU_BUS1 dependencies on PAY_FR_CONTRIBUTION_USAGES

Line 61: p_element_name in pay_fr_contribution_usages.element_name%TYPE

57: --
58: -- {End Of Comments}
59: -- ----------------------------------------------------------------------------
60: Procedure chk_element_name (
61: p_element_name in pay_fr_contribution_usages.element_name%TYPE
62: );
63: -- ----------------------------------------------------------------------------
64: -- |---------------------------< chk_contribution_usage_type >----------------|
65: -- ----------------------------------------------------------------------------

Line 95: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE

91: -- {End Of Comments}
92: -- ----------------------------------------------------------------------------
93: Procedure chk_contribution_usage_type (
94: p_effective_date in date
95: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
96: );
97: -- ----------------------------------------------------------------------------
98: -- |---------------------------< chk_rate_type >------------------------------|
99: -- ----------------------------------------------------------------------------

Line 129: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE

125: -- {End Of Comments}
126: -- ----------------------------------------------------------------------------
127: Procedure chk_rate_type (
128: p_effective_date in date
129: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE
130: );
131: -- ----------------------------------------------------------------------------
132: -- |---------------------------< chk_process_type >---------------------------|
133: -- ----------------------------------------------------------------------------

Line 163: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE

159: -- {End Of Comments}
160: -- ----------------------------------------------------------------------------
161: Procedure chk_process_type (
162: p_effective_date in date
163: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
164: );
165: -- ----------------------------------------------------------------------------
166: -- |---------------------------< chk_lu_group_code >--------------------------|
167: -- ----------------------------------------------------------------------------

Line 197: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE

193: -- {End Of Comments}
194: -- ----------------------------------------------------------------------------
195: Procedure chk_lu_group_code (
196: p_effective_date in date
197: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE
198: );
199: -- ----------------------------------------------------------------------------
200: -- |---------------------------< chk_business_group_id >-----------------------|
201: -- ----------------------------------------------------------------------------

Line 227: p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE

223: --
224: -- {End Of Comments}
225: -- ----------------------------------------------------------------------------
226: Procedure chk_business_group_id (
227: p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE
228: );
229: -- ----------------------------------------------------------------------------
230: -- |---------------------------< chk_rate_category_type >---------------------|
231: -- ----------------------------------------------------------------------------

Line 257: p_rate_category in pay_fr_contribution_usages.rate_category%TYPE

253: --
254: -- {End Of Comments}
255: -- ----------------------------------------------------------------------------
256: Procedure chk_rate_category_type (
257: p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
258: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE
259: );
260: -- ----------------------------------------------------------------------------
261: -- |---------------------------< chk_validate_code >---------------------------|

Line 258: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE

254: -- {End Of Comments}
255: -- ----------------------------------------------------------------------------
256: Procedure chk_rate_category_type (
257: p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
258: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE
259: );
260: -- ----------------------------------------------------------------------------
261: -- |---------------------------< chk_validate_code >---------------------------|
262: -- ----------------------------------------------------------------------------

Line 289: p_code in pay_fr_contribution_usages.contribution_code%TYPE

285: --
286: -- {End Of Comments}
287: -- ----------------------------------------------------------------------------
288: Procedure chk_validate_code (
289: p_code in pay_fr_contribution_usages.contribution_code%TYPE
290: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE
291: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
292: );
293: -- ----------------------------------------------------------------------------

Line 290: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE

286: -- {End Of Comments}
287: -- ----------------------------------------------------------------------------
288: Procedure chk_validate_code (
289: p_code in pay_fr_contribution_usages.contribution_code%TYPE
290: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE
291: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
292: );
293: -- ----------------------------------------------------------------------------
294: -- |---------------------------< chk_contribution_type >----------------------|

Line 291: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE

287: -- ----------------------------------------------------------------------------
288: Procedure chk_validate_code (
289: p_code in pay_fr_contribution_usages.contribution_code%TYPE
290: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE
291: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
292: );
293: -- ----------------------------------------------------------------------------
294: -- |---------------------------< chk_contribution_type >----------------------|
295: -- ----------------------------------------------------------------------------

Line 320: p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE

316: --
317: -- {End Of Comments}
318: -- ----------------------------------------------------------------------------
319: Procedure chk_contribution_type (
320: p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE
321: );
322: -- ----------------------------------------------------------------------------
323: -- |---------------------------< chk_contribution_codes >----------------------|
324: -- ----------------------------------------------------------------------------

Line 356: p_contribution_usage_id in pay_fr_contribution_usages.contribution_usage_id%TYPE

352: --
353: -- {End Of Comments}
354: -- ----------------------------------------------------------------------------
355: Procedure chk_contribution_codes (
356: p_contribution_usage_id in pay_fr_contribution_usages.contribution_usage_id%TYPE
357: ,p_object_version_number in pay_fr_contribution_usages.object_version_number%TYPE
358: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE
359: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
360: ,p_retro_contribution_code in pay_fr_contribution_usages.retro_contribution_code%TYPE

Line 357: ,p_object_version_number in pay_fr_contribution_usages.object_version_number%TYPE

353: -- {End Of Comments}
354: -- ----------------------------------------------------------------------------
355: Procedure chk_contribution_codes (
356: p_contribution_usage_id in pay_fr_contribution_usages.contribution_usage_id%TYPE
357: ,p_object_version_number in pay_fr_contribution_usages.object_version_number%TYPE
358: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE
359: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
360: ,p_retro_contribution_code in pay_fr_contribution_usages.retro_contribution_code%TYPE
361: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE

Line 358: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE

354: -- ----------------------------------------------------------------------------
355: Procedure chk_contribution_codes (
356: p_contribution_usage_id in pay_fr_contribution_usages.contribution_usage_id%TYPE
357: ,p_object_version_number in pay_fr_contribution_usages.object_version_number%TYPE
358: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE
359: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
360: ,p_retro_contribution_code in pay_fr_contribution_usages.retro_contribution_code%TYPE
361: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
362: );

Line 359: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE

355: Procedure chk_contribution_codes (
356: p_contribution_usage_id in pay_fr_contribution_usages.contribution_usage_id%TYPE
357: ,p_object_version_number in pay_fr_contribution_usages.object_version_number%TYPE
358: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE
359: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
360: ,p_retro_contribution_code in pay_fr_contribution_usages.retro_contribution_code%TYPE
361: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
362: );
363: -- ----------------------------------------------------------------------------

Line 360: ,p_retro_contribution_code in pay_fr_contribution_usages.retro_contribution_code%TYPE

356: p_contribution_usage_id in pay_fr_contribution_usages.contribution_usage_id%TYPE
357: ,p_object_version_number in pay_fr_contribution_usages.object_version_number%TYPE
358: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE
359: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
360: ,p_retro_contribution_code in pay_fr_contribution_usages.retro_contribution_code%TYPE
361: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
362: );
363: -- ----------------------------------------------------------------------------
364: -- |---------------------------< chk_group_code >------------------------------|

Line 361: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE

357: ,p_object_version_number in pay_fr_contribution_usages.object_version_number%TYPE
358: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE
359: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
360: ,p_retro_contribution_code in pay_fr_contribution_usages.retro_contribution_code%TYPE
361: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
362: );
363: -- ----------------------------------------------------------------------------
364: -- |---------------------------< chk_group_code >------------------------------|
365: -- ----------------------------------------------------------------------------

Line 398: p_group_code in pay_fr_contribution_usages.group_code%TYPE

394: --
395: -- {End Of Comments}
396: -- ----------------------------------------------------------------------------
397: Procedure chk_group_code (
398: p_group_code in pay_fr_contribution_usages.group_code%TYPE
399: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
400: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
401: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
402: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE

Line 399: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE

395: -- {End Of Comments}
396: -- ----------------------------------------------------------------------------
397: Procedure chk_group_code (
398: p_group_code in pay_fr_contribution_usages.group_code%TYPE
399: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
400: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
401: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
402: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE
403: );

Line 400: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE

396: -- ----------------------------------------------------------------------------
397: Procedure chk_group_code (
398: p_group_code in pay_fr_contribution_usages.group_code%TYPE
399: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
400: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
401: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
402: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE
403: );
404: --

Line 401: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE

397: Procedure chk_group_code (
398: p_group_code in pay_fr_contribution_usages.group_code%TYPE
399: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
400: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
401: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
402: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE
403: );
404: --
405: -- ----------------------------------------------------------------------------

Line 402: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE

398: p_group_code in pay_fr_contribution_usages.group_code%TYPE
399: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
400: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
401: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
402: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE
403: );
404: --
405: -- ----------------------------------------------------------------------------
406: -- |---------------------------< chk_dates >----------------------------------|

Line 450: p_contribution_usage_id in pay_fr_contribution_usages.contribution_usage_id%TYPE

446: --
447: -- {End Of Comments}
448: -- ----------------------------------------------------------------------------
449: Procedure chk_dates (
450: p_contribution_usage_id in pay_fr_contribution_usages.contribution_usage_id%TYPE
451: ,p_object_version_number in pay_fr_contribution_usages.object_version_number%TYPE
452: ,p_date_from in pay_fr_contribution_usages.date_from%TYPE
453: ,p_date_to in pay_fr_contribution_usages.date_to%TYPE
454: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE

Line 451: ,p_object_version_number in pay_fr_contribution_usages.object_version_number%TYPE

447: -- {End Of Comments}
448: -- ----------------------------------------------------------------------------
449: Procedure chk_dates (
450: p_contribution_usage_id in pay_fr_contribution_usages.contribution_usage_id%TYPE
451: ,p_object_version_number in pay_fr_contribution_usages.object_version_number%TYPE
452: ,p_date_from in pay_fr_contribution_usages.date_from%TYPE
453: ,p_date_to in pay_fr_contribution_usages.date_to%TYPE
454: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE
455: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE

Line 452: ,p_date_from in pay_fr_contribution_usages.date_from%TYPE

448: -- ----------------------------------------------------------------------------
449: Procedure chk_dates (
450: p_contribution_usage_id in pay_fr_contribution_usages.contribution_usage_id%TYPE
451: ,p_object_version_number in pay_fr_contribution_usages.object_version_number%TYPE
452: ,p_date_from in pay_fr_contribution_usages.date_from%TYPE
453: ,p_date_to in pay_fr_contribution_usages.date_to%TYPE
454: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE
455: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
456: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE

Line 453: ,p_date_to in pay_fr_contribution_usages.date_to%TYPE

449: Procedure chk_dates (
450: p_contribution_usage_id in pay_fr_contribution_usages.contribution_usage_id%TYPE
451: ,p_object_version_number in pay_fr_contribution_usages.object_version_number%TYPE
452: ,p_date_from in pay_fr_contribution_usages.date_from%TYPE
453: ,p_date_to in pay_fr_contribution_usages.date_to%TYPE
454: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE
455: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
456: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
457: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE

Line 454: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE

450: p_contribution_usage_id in pay_fr_contribution_usages.contribution_usage_id%TYPE
451: ,p_object_version_number in pay_fr_contribution_usages.object_version_number%TYPE
452: ,p_date_from in pay_fr_contribution_usages.date_from%TYPE
453: ,p_date_to in pay_fr_contribution_usages.date_to%TYPE
454: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE
455: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
456: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
457: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
458: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE

Line 455: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE

451: ,p_object_version_number in pay_fr_contribution_usages.object_version_number%TYPE
452: ,p_date_from in pay_fr_contribution_usages.date_from%TYPE
453: ,p_date_to in pay_fr_contribution_usages.date_to%TYPE
454: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE
455: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
456: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
457: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
458: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE
459: );

Line 456: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE

452: ,p_date_from in pay_fr_contribution_usages.date_from%TYPE
453: ,p_date_to in pay_fr_contribution_usages.date_to%TYPE
454: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE
455: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
456: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
457: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
458: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE
459: );
460: --

Line 457: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE

453: ,p_date_to in pay_fr_contribution_usages.date_to%TYPE
454: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE
455: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
456: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
457: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
458: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE
459: );
460: --
461: -- ----------------------------------------------------------------------------

Line 458: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE

454: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE
455: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
456: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
457: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
458: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE
459: );
460: --
461: -- ----------------------------------------------------------------------------
462: -- |---------------------------< LOAD_ROW >-----------------------------------|

Line 510: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE

506: -- ----------------------------------------------------------------------------
507: Procedure load_row (
508: p_date_from in varchar2
509: ,p_date_to in varchar2
510: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE
511: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
512: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
513: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
514: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE

Line 511: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE

507: Procedure load_row (
508: p_date_from in varchar2
509: ,p_date_to in varchar2
510: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE
511: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
512: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
513: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
514: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE
515: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE

Line 512: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE

508: p_date_from in varchar2
509: ,p_date_to in varchar2
510: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE
511: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
512: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
513: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
514: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE
515: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
516: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE

Line 513: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE

509: ,p_date_to in varchar2
510: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE
511: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
512: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
513: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
514: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE
515: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
516: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
517: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE

Line 514: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE

510: ,p_group_code in pay_fr_contribution_usages.group_code%TYPE
511: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
512: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
513: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
514: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE
515: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
516: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
517: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE
518: ,p_retro_contribution_code in pay_fr_contribution_usages.retro_contribution_code%TYPE

Line 515: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE

511: ,p_process_type in pay_fr_contribution_usages.process_type%TYPE
512: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
513: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
514: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE
515: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
516: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
517: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE
518: ,p_retro_contribution_code in pay_fr_contribution_usages.retro_contribution_code%TYPE
519: ,p_code_rate_id in pay_fr_contribution_usages.code_Rate_id%TYPE

Line 516: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE

512: ,p_element_name in pay_fr_contribution_usages.element_name%TYPE
513: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
514: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE
515: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
516: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
517: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE
518: ,p_retro_contribution_code in pay_fr_contribution_usages.retro_contribution_code%TYPE
519: ,p_code_rate_id in pay_fr_contribution_usages.code_Rate_id%TYPE
520: );

Line 517: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE

513: ,p_contribution_usage_type in pay_fr_contribution_usages.contribution_usage_type%TYPE
514: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE
515: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
516: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
517: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE
518: ,p_retro_contribution_code in pay_fr_contribution_usages.retro_contribution_code%TYPE
519: ,p_code_rate_id in pay_fr_contribution_usages.code_Rate_id%TYPE
520: );
521: --

Line 518: ,p_retro_contribution_code in pay_fr_contribution_usages.retro_contribution_code%TYPE

514: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE
515: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
516: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
517: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE
518: ,p_retro_contribution_code in pay_fr_contribution_usages.retro_contribution_code%TYPE
519: ,p_code_rate_id in pay_fr_contribution_usages.code_Rate_id%TYPE
520: );
521: --
522: -- ----------------------------------------------------------------------------

Line 519: ,p_code_rate_id in pay_fr_contribution_usages.code_Rate_id%TYPE

515: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
516: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
517: ,p_contribution_type in pay_fr_contribution_usages.contribution_type%TYPE
518: ,p_retro_contribution_code in pay_fr_contribution_usages.retro_contribution_code%TYPE
519: ,p_code_rate_id in pay_fr_contribution_usages.code_Rate_id%TYPE
520: );
521: --
522: -- ----------------------------------------------------------------------------
523: -- |---------------------------< chk_code_rate_id >----------------------------|

Line 564: p_code_rate_id in out nocopy pay_fr_contribution_usages.code_rate_id%TYPE

560: --
561: -- {End Of Comments}
562: -- ----------------------------------------------------------------------------
563: Procedure chk_code_rate_id (
564: p_code_rate_id in out nocopy pay_fr_contribution_usages.code_rate_id%TYPE
565: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
566: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE
567: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE
568: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE

Line 565: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE

561: -- {End Of Comments}
562: -- ----------------------------------------------------------------------------
563: Procedure chk_code_rate_id (
564: p_code_rate_id in out nocopy pay_fr_contribution_usages.code_rate_id%TYPE
565: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
566: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE
567: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE
568: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
569: );

Line 566: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE

562: -- ----------------------------------------------------------------------------
563: Procedure chk_code_rate_id (
564: p_code_rate_id in out nocopy pay_fr_contribution_usages.code_rate_id%TYPE
565: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
566: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE
567: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE
568: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
569: );
570: end pay_cnu_bus1;

Line 567: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE

563: Procedure chk_code_rate_id (
564: p_code_rate_id in out nocopy pay_fr_contribution_usages.code_rate_id%TYPE
565: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
566: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE
567: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE
568: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
569: );
570: end pay_cnu_bus1;

Line 568: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE

564: p_code_rate_id in out nocopy pay_fr_contribution_usages.code_rate_id%TYPE
565: ,p_contribution_code in pay_fr_contribution_usages.contribution_code%TYPE
566: ,p_business_group_id in pay_fr_contribution_usages.business_group_id%TYPE
567: ,p_rate_type in pay_fr_contribution_usages.rate_type%TYPE
568: ,p_rate_category in pay_fr_contribution_usages.rate_category%TYPE
569: );
570: end pay_cnu_bus1;