APPS.PAY_JP_ISDF_SS_PKG dependencies on PAY_ACTION_INFORMATION

Line 1515: from pay_action_information

1511: --
1512: -- recreate archive data (available for existing data of transaction_status N or U)
1513: --
1514: delete
1515: from pay_action_information
1516: where action_context_id = l_assact_rec.assignment_action_id
1517: and action_context_type = 'AAP'
1518: and action_information_category <> 'JP_ISDF_ASSACT';
1519: --

Line 1706: from pay_action_information pai

1702: action_information29,
1703: action_information30,
1704: effective_date,
1705: assignment_id
1706: from pay_action_information pai
1707: where pai.action_context_id = p_assignment_action_id
1708: and pai.action_context_type = 'AAP'
1709: and pai.action_information_category in ('JP_ISDF_LIFE_GEN',
1710: 'JP_ISDF_LIFE_PENS',

Line 3151: select pay_action_information_s.nextval

3147:
3148: --
3149: if l_csr_calc_dct.action_information_id is null then
3150: --
3151: select pay_action_information_s.nextval
3152: into l_action_information_id
3153: from dual;
3154: --
3155: pay_jp_isdf_dml_pkg.create_calc_dct(

Line 3242: select pay_action_information_s.nextval

3238: close csr_calc_dct2;
3239: --
3240: if l_csr_calc_dct2.action_information_id is null then
3241: --
3242: select pay_action_information_s.nextval
3243: into l_action_information_id
3244: from dual;
3245: --
3246: pay_jp_isdf_dml_pkg.create_calc_dct2(

Line 3367: select pay_action_information_s.nextval

3363: --
3364:
3365: if l_csr_calc_dct.action_information_id is null then
3366: --
3367: select pay_action_information_s.nextval
3368: into l_action_information_id
3369: from dual;
3370: --
3371: pay_jp_isdf_dml_pkg.create_calc_dct(

Line 3458: select pay_action_information_s.nextval

3454: close csr_calc_dct2;
3455:
3456: if l_csr_calc_dct2.action_information_id is null then
3457: --
3458: select pay_action_information_s.nextval
3459: into l_action_information_id
3460: from dual;
3461: --
3462: pay_jp_isdf_dml_pkg.create_calc_dct2(

Line 3501: select pay_action_information_s.nextval

3497: close csr_entry;
3498: --
3499: if l_csr_entry.action_information_id is null then
3500: --
3501: select pay_action_information_s.nextval
3502: into l_action_information_id
3503: from dual;
3504: --
3505: pay_jp_isdf_dml_pkg.create_entry(

Line 3702: from pay_action_information

3698: hr_utility.trace('start calc_dct before finalize');
3699: end if;
3700: --
3701: delete
3702: from pay_action_information
3703: where action_context_id = l_assact_rec.assignment_action_id
3704: and action_context_type = 'AAP'
3705: and action_information_category <> 'JP_ISDF_ASSACT';
3706: --

Line 5594: from pay_action_information

5590: select rowid row_id,
5591: action_information_id,
5592: object_version_number,
5593: action_information_category
5594: from pay_action_information
5595: where action_context_id = l_assact_rec.assignment_action_id
5596: and action_context_type = 'AAP'
5597: and action_information_category <> 'JP_ISDF_ASSACT'
5598: and action_information1 <> 'D';

Line 5697: from pay_action_information

5693: --
5694: if p_mode = 'ZAP' then
5695: --
5696: delete
5697: from pay_action_information
5698: where action_context_id = l_assact_rec.assignment_action_id
5699: and action_context_type = 'AAP'
5700: and action_information_category <> 'JP_ISDF_ASSACT';
5701: --

Line 5717: update pay_action_information

5713: else
5714: l_object_version_number := l_csr_del.object_version_number + 1;
5715: end if;
5716: --
5717: update pay_action_information
5718: set object_version_number = l_object_version_number,
5719: action_information1 = 'D'
5720: where rowid = l_csr_del.row_id;
5721: --