APPS.HR_FULL_SYNC_MESSAGES dependencies on PAY_ALL_PAYROLLS_F

Line 1036: p_pyrl_id pay_all_payrolls_f.payroll_id%type;

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

Line 1037: p_pyrl_name pay_all_payrolls_f.payroll_name%type;

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

Line 1038: p_bg_id pay_all_payrolls_f.business_group_id%type;

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

Line 1049: pay_all_payrolls_f pay1

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

Line 1054: from pay_all_payrolls_f pay

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