APPS.PAY_CNU_BUS dependencies on PAY_FR_CONTRIBUTION_USAGES

Line 29: , pay_fr_contribution_usages con

25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , pay_fr_contribution_usages con
30: where con.contribution_usage_id = p_contribution_usage_id
31: and pbg.business_group_id = con.business_group_id;
32: --
33: -- Declare local variables

Line 89: , pay_fr_contribution_usages con

85: --
86: cursor csr_leg_code is
87: select pbg.legislation_code
88: from per_business_groups pbg
89: , pay_fr_contribution_usages con
90: where con.contribution_usage_id = p_contribution_usage_id
91: and pbg.business_group_id (+) = con.business_group_id;
92: --
93: -- Declare local variables

Line 298: ,p_code_Rate_id out nocopy PAY_FR_CONTRIBUTION_USAGES.CODE_RATE_ID%TYPE

294: -- ----------------------------------------------------------------------------
295: Procedure insert_validate
296: (p_effective_date in date
297: ,p_rec in pay_cnu_shd.g_rec_type
298: ,p_code_Rate_id out nocopy PAY_FR_CONTRIBUTION_USAGES.CODE_RATE_ID%TYPE
299: ) is
300: --
301: l_proc varchar2(72) := g_package||'insert_validate';
302: l_code_Rate_id PAY_FR_CONTRIBUTION_USAGES.CODE_RATE_ID%TYPE := p_rec.code_Rate_id;

Line 302: l_code_Rate_id PAY_FR_CONTRIBUTION_USAGES.CODE_RATE_ID%TYPE := p_rec.code_Rate_id;

298: ,p_code_Rate_id out nocopy PAY_FR_CONTRIBUTION_USAGES.CODE_RATE_ID%TYPE
299: ) is
300: --
301: l_proc varchar2(72) := g_package||'insert_validate';
302: l_code_Rate_id PAY_FR_CONTRIBUTION_USAGES.CODE_RATE_ID%TYPE := p_rec.code_Rate_id;
303: --
304: Begin
305: hr_utility.set_location('Entering:'||l_proc, 5);
306: --