APPS.HR_FULL_SYNC_MESSAGES dependencies on PAY_ALL_PAYROLLS_F

Line 1035: p_pyrl_id pay_all_payrolls_f.payroll_id%type;

1031: /*Procedure to extract the payroll group data for full synch process begins*/
1032: procedure hr_payroll_full_sync(errbuf OUT NOCOPY VARCHAR2
1033: ,retcode OUT NOCOPY VARCHAR2)
1034: is
1035: p_pyrl_id pay_all_payrolls_f.payroll_id%type;
1036: p_pyrl_name pay_all_payrolls_f.payroll_name%type;
1037: p_bg_id pay_all_payrolls_f.business_group_id%type;
1038: p_eff_date date;
1039: p_eff_status varchar2(10);

Line 1036: p_pyrl_name pay_all_payrolls_f.payroll_name%type;

1032: procedure hr_payroll_full_sync(errbuf OUT NOCOPY VARCHAR2
1033: ,retcode OUT NOCOPY VARCHAR2)
1034: is
1035: p_pyrl_id pay_all_payrolls_f.payroll_id%type;
1036: p_pyrl_name pay_all_payrolls_f.payroll_name%type;
1037: p_bg_id pay_all_payrolls_f.business_group_id%type;
1038: p_eff_date date;
1039: p_eff_status varchar2(10);
1040: p_effective_date date default sysdate;

Line 1037: p_bg_id pay_all_payrolls_f.business_group_id%type;

1033: ,retcode OUT NOCOPY VARCHAR2)
1034: is
1035: p_pyrl_id pay_all_payrolls_f.payroll_id%type;
1036: p_pyrl_name pay_all_payrolls_f.payroll_name%type;
1037: p_bg_id pay_all_payrolls_f.business_group_id%type;
1038: p_eff_date date;
1039: p_eff_status varchar2(10);
1040: p_effective_date date default sysdate;
1041:

Line 1048: pay_all_payrolls_f pay1

1044: payroll_name,
1045: business_group_id,
1046: case when p_effective_date > add_months(first_period_end_date,NUMBER_OF_YEARS*12)
1047: then add_months(first_period_end_date,NUMBER_OF_YEARS*12) else (select min(effective_start_date) from
1048: pay_all_payrolls_f pay1
1049: where pay1.payroll_id = pay.payroll_id
1050: and pay1.business_group_id = pay.business_group_id) end,
1051: case when p_effective_date > add_months(first_period_end_date,NUMBER_OF_YEARS*12)
1052: then 'INACTIVE' else 'ACTIVE' end

Line 1053: from pay_all_payrolls_f pay

1049: where pay1.payroll_id = pay.payroll_id
1050: and pay1.business_group_id = pay.business_group_id) end,
1051: case when p_effective_date > add_months(first_period_end_date,NUMBER_OF_YEARS*12)
1052: then 'INACTIVE' else 'ACTIVE' end
1053: from pay_all_payrolls_f pay
1054: where p_effective_date between effective_start_date and effective_end_date;
1055:
1056:
1057: cursor fet_psft_sync is