[Home] [Help]
48: 14-Aug-2012 pkoduri 115.136 14319807 Fixed the issue,Retroactive entries for a payroll period if
49: de-selected from the Quickpay screen are being archived
50: with null values.
51: 04-May-2012 Pkoduri 115.135 13881512 In case of an employee having bounus with separate check then
52: retro elements are not being individually archived.
53: For this the fix is to revert the chagnes done for the
54: bug 9207953.
55: 27-Mar-2012 Pkoduri 115.134 13877047 In this version the fix reverted in the earlier version is
56: addressed again but this time carefully handling the YTD issue
2649: hr_utility.trace('Addl Ele DFF Info Configured.');
2650:
2651: SELECT TO_CHAR(TRUNC(fnd_date.canonical_to_date(fnd_date.date_to_canonical(p_curr_pymt_eff_date))),'DD-MON-YYYY')
2652: INTO lv_curr_pymt_eff_date
2653: FROM DUAL;
2654: --bug no 6950970 starts here
2655: OPEN get_payroll_date_earned (ln_run_assignment_action_id);
2656: FETCH get_payroll_date_earned INTO l_date_earned;
2657: CLOSE get_payroll_date_earned;
2824: AND ppa.payroll_action_id = paa.payroll_action_id
2825: AND ppa.effective_date between peaf.effective_start_date and peaf.effective_end_date
2826: ))
2827: into lv_jurisdiction_flag
2828: from dual;
2829: END IF; -- Work At Home 'N'
2830:
2831: END IF; -- ln_addnl_ele_num > 0
2832: /* Commented for Bug# 8211926
5140: AND ppa.payroll_action_id = paa.payroll_action_id
5141: AND ppa.effective_date between peaf.effective_start_date and peaf.effective_end_date
5142: ))
5143: into lv_jurisdiction_flag
5144: from dual;
5145: END IF; -- Work At Home 'N'
5146:
5147: -- populating temporary plsql table
5148: --
5695: AND ppa.payroll_action_id = paa.payroll_action_id
5696: AND ppa.effective_date between peaf.effective_start_date and peaf.effective_end_date
5697: ))
5698: into lv_jurisdiction_flag
5699: from dual;
5700: END IF; -- Work at Home 'N'
5701:
5702: hr_utility.trace('lv_jurisdiction_flag := '||lv_jurisdiction_flag);
5703: lv_action_category := 'AC EARNINGS';
6307: AND ppa.payroll_action_id = paa.payroll_action_id
6308: AND ppa.effective_date between peaf.effective_start_date and peaf.effective_end_date
6309: ))
6310: into lv_jurisdiction_flag
6311: from dual;
6312: END IF; -- Work at Home 'N'
6313:
6314: hr_utility.trace('lv_jurisdiction_flag := '||lv_jurisdiction_flag);
6315: lv_action_category := 'AC EARNINGS';