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.HR_DELTA_SYNC_MESSAGES dependencies on PAY_ALL_PAYROLLS_F

Line 2625: p_pyrl_id pay_all_payrolls_f.payroll_id%type;

2621: procedure hr_payroll_delta_sync(errbuf OUT NOCOPY VARCHAR2
2622: ,retcode OUT NOCOPY VARCHAR2
2623: ,p_party_site_id in NUMBER)
2624: is
2625: p_pyrl_id pay_all_payrolls_f.payroll_id%type;
2626: p_pyrl_name pay_all_payrolls_f.payroll_name%type;
2627: p_bg_id pay_all_payrolls_f.business_group_id%type;
2628: p_eff_date date;
2629: p_eff_status varchar2(10);

Line 2626: p_pyrl_name pay_all_payrolls_f.payroll_name%type;

2622: ,retcode OUT NOCOPY VARCHAR2
2623: ,p_party_site_id in NUMBER)
2624: is
2625: p_pyrl_id pay_all_payrolls_f.payroll_id%type;
2626: p_pyrl_name pay_all_payrolls_f.payroll_name%type;
2627: p_bg_id pay_all_payrolls_f.business_group_id%type;
2628: p_eff_date date;
2629: p_eff_status varchar2(10);
2630: p_effective_date date default sysdate;

Line 2627: p_bg_id pay_all_payrolls_f.business_group_id%type;

2623: ,p_party_site_id in NUMBER)
2624: is
2625: p_pyrl_id pay_all_payrolls_f.payroll_id%type;
2626: p_pyrl_name pay_all_payrolls_f.payroll_name%type;
2627: p_bg_id pay_all_payrolls_f.business_group_id%type;
2628: p_eff_date date;
2629: p_eff_status varchar2(10);
2630: p_effective_date date default sysdate;
2631: l_params WF_PARAMETER_LIST_T;

Line 2644: pay_all_payrolls_f pay1

2640: payroll_name,
2641: business_group_id,
2642: case when p_effective_date > add_months(first_period_end_date,NUMBER_OF_YEARS*12)
2643: then add_months(first_period_end_date,NUMBER_OF_YEARS*12) else (select min(effective_start_date) from
2644: pay_all_payrolls_f pay1
2645: where pay1.payroll_id = pay.payroll_id
2646: and pay1.business_group_id = pay.business_group_id) end,
2647: case when p_effective_date > add_months(first_period_end_date,NUMBER_OF_YEARS*12)
2648: then 'INACTIVE' else 'ACTIVE' end,

Line 2650: from pay_all_payrolls_f pay

2646: and pay1.business_group_id = pay.business_group_id) end,
2647: case when p_effective_date > add_months(first_period_end_date,NUMBER_OF_YEARS*12)
2648: then 'INACTIVE' else 'ACTIVE' end,
2649: last_update_date
2650: from pay_all_payrolls_f pay
2651: where last_update_date > p_max_run_date
2652: and p_effective_date between effective_start_date and effective_end_date
2653: and (payroll_id,business_group_id) not in (select pyrl.payroll_id,pyrl.business_group_id
2654: from hr_pyrl_delta_sync pyrl

Line 2682: pay_all_payrolls_f pay1

2678: payroll_name,
2679: business_group_id,
2680: case when p_effective_date > add_months(first_period_end_date,NUMBER_OF_YEARS*12)
2681: then add_months(first_period_end_date,NUMBER_OF_YEARS*12) else (select min(effective_start_date) from
2682: pay_all_payrolls_f pay1
2683: where pay1.payroll_id = pay.payroll_id
2684: and pay1.business_group_id = pay.business_group_id) end,
2685: case when p_effective_date > add_months(first_period_end_date,NUMBER_OF_YEARS*12)
2686: then 'INACTIVE' else 'ACTIVE' end,

Line 2688: from pay_all_payrolls_f pay

2684: and pay1.business_group_id = pay.business_group_id) end,
2685: case when p_effective_date > add_months(first_period_end_date,NUMBER_OF_YEARS*12)
2686: then 'INACTIVE' else 'ACTIVE' end,
2687: last_update_date
2688: from pay_all_payrolls_f pay
2689: where pay.payroll_id = p_payroll_id
2690: and pay.business_group_id = p_bgrp_id
2691: and p_effective_date between effective_start_date and effective_end_date
2692: and last_update_date >= p_lstupd_date;