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.PER_RI_CRP_DEFAULT_SETTINGS dependencies on PAY_PAYROLLS_F

Line 418: l_payroll_name PAY_PAYROLLS_F.PAYROLL_NAME%TYPE := p_payroll_name;

414: IS
415:
416: -- IN Variables
417: l_leg_code VARCHAR2(2) := p_leg_code;
418: l_payroll_name PAY_PAYROLLS_F.PAYROLL_NAME%TYPE := p_payroll_name;
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;

Line 420: l_period_type PAY_PAYROLLS_F.PAYROLL_TYPE%TYPE := p_period_type;

416: -- IN Variables
417: l_leg_code VARCHAR2(2) := p_leg_code;
418: l_payroll_name PAY_PAYROLLS_F.PAYROLL_NAME%TYPE := p_payroll_name;
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;

Line 421: l_first_period_end_date PAY_PAYROLLS_F.FIRST_PERIOD_END_DATE%TYPE := p_first_period_end_date;

417: l_leg_code VARCHAR2(2) := p_leg_code;
418: l_payroll_name PAY_PAYROLLS_F.PAYROLL_NAME%TYPE := p_payroll_name;
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;

Line 422: l_number_of_years PAY_PAYROLLS_F.NUMBER_OF_YEARS%TYPE := p_number_of_years;

418: l_payroll_name PAY_PAYROLLS_F.PAYROLL_NAME%TYPE := p_payroll_name;
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:

Line 424: l_def_payment_method_id PAY_PAYROLLS_F.DEFAULT_PAYMENT_METHOD_ID%type;

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:
428: -- OUT Variables

Line 457: FROM PAY_PAYROLLS_F

453: FETCH csr_consolidation_set_id INTO l_consolidation_set_id;
454: CLOSE csr_consolidation_set_id;
455:
456: SELECT COUNT(*) INTO l_verify_payroll
457: FROM PAY_PAYROLLS_F
458: WHERE payroll_name = p_payroll_name
459: AND business_group_id = p_bg_id;
460:
461: --hr_utility.trace(' BG ID .....' || p_bg_id);

Line 472: FROM PAY_PAYROLLS_F

468: write_log(1,p_errbuff,p_bg_id);
469:
470: -- Get the id of the existing payroll with the same name
471: SELECT distinct payroll_id into p_payroll_id
472: FROM PAY_PAYROLLS_F
473: WHERE payroll_name = p_payroll_name
474: AND business_group_id = p_bg_id;
475: ELSE
476: