DBA Data[Home] [Help]

APPS.PER_RI_CRP_DEFAULT_SETTINGS dependencies on PAY_CONSOLIDATION_SETS

Line 423: l_consolidation_set_id PAY_CONSOLIDATION_SETS.CONSOLIDATION_SET_ID%TYPE;

419: l_effective_date DATE := p_effective_date;
420: l_period_type PAY_PAYROLLS_F.PAYROLL_TYPE%TYPE := p_period_type;
421: l_first_period_end_date PAY_PAYROLLS_F.FIRST_PERIOD_END_DATE%TYPE := p_first_period_end_date;
422: l_number_of_years PAY_PAYROLLS_F.NUMBER_OF_YEARS%TYPE := p_number_of_years;
423: l_consolidation_set_id PAY_CONSOLIDATION_SETS.CONSOLIDATION_SET_ID%TYPE;
424: l_def_payment_method_id PAY_PAYROLLS_F.DEFAULT_PAYMENT_METHOD_ID%type;
425: l_verify_payroll NUMBER;
426:
427:

Line 442: FROM PAY_CONSOLIDATION_SETS c,PER_BUSINESS_GROUPS b

438:
439: -- Declare a Cursor to capture the consolidation set
440: CURSOR csr_consolidation_set_id IS
441: SELECT c.consolidation_set_id
442: FROM PAY_CONSOLIDATION_SETS c,PER_BUSINESS_GROUPS b
443: WHERE b.business_group_id = p_bg_id
444: AND b.business_group_id = c.business_group_id
445: AND c.consolidation_set_name = p_consolidation_set_name;
446: