APPS.PAY_FR_RULES dependencies on PAY_FR_CONTRIBUTION_USAGES

Line 422: from pay_fr_contribution_usages

418: = nvl(max(decode(piv.name,'Rate Type',eev2.screen_entry_value)),' ');
419: --
420: cursor csr_retro_code_by_id(p_cu_id in number) is
421: select retro_contribution_code,contribution_type
422: from pay_fr_contribution_usages
423: where contribution_usage_id = p_cu_id
424: and retro_contribution_code <> contribution_code;
425: --
426: rec_matching_entry csr_matching_entry%ROWTYPE;

Line 427: l_retro_code pay_fr_contribution_usages.retro_contribution_code%TYPE;

423: where contribution_usage_id = p_cu_id
424: and retro_contribution_code <> contribution_code;
425: --
426: rec_matching_entry csr_matching_entry%ROWTYPE;
427: l_retro_code pay_fr_contribution_usages.retro_contribution_code%TYPE;
428: l_contribution_type pay_fr_contribution_usages.contribution_type%TYPE;
429: begin
430: if p_context_name <> 'SOURCE_TEXT2'
431: or nvl(p_context_value,' ') = ' '

Line 428: l_contribution_type pay_fr_contribution_usages.contribution_type%TYPE;

424: and retro_contribution_code <> contribution_code;
425: --
426: rec_matching_entry csr_matching_entry%ROWTYPE;
427: l_retro_code pay_fr_contribution_usages.retro_contribution_code%TYPE;
428: l_contribution_type pay_fr_contribution_usages.contribution_type%TYPE;
429: begin
430: if p_context_name <> 'SOURCE_TEXT2'
431: or nvl(p_context_value,' ') = ' '
432: then

Line 451: -- not held on pay_fr_contribution_usages

447: fnd_number.canonical_to_number(rec_matching_entry.cui1));
448: fetch csr_retro_code_by_id into l_retro_code,l_contribution_type;
449: if csr_retro_code_by_id%NOTFOUND then
450: -- retro_contribution_code not different or contribution_code
451: -- not held on pay_fr_contribution_usages
452: -- so return value unchanged
453: p_replacement_value := p_context_value;
454: else
455: IF l_contribution_type = 'URSSAF' THEN