APPS.PAY_JP_ISDF_SS_PKG dependencies on PAY_ACTION_INFORMATION

Line 1114: from pay_action_information

1110: --
1111: -- recreate archive data (available for existing data of transaction_status N or U)
1112: --
1113: delete
1114: from pay_action_information
1115: where action_context_id = l_assact_rec.assignment_action_id
1116: and action_context_type = 'AAP'
1117: and action_information_category <> 'JP_ISDF_ASSACT';
1118: --

Line 1305: from pay_action_information pai

1301: action_information29,
1302: action_information30,
1303: effective_date,
1304: assignment_id
1305: from pay_action_information pai
1306: where pai.action_context_id = p_assignment_action_id
1307: and pai.action_context_type = 'AAP'
1308: and pai.action_information_category in ('JP_ISDF_LIFE_GEN',
1309: 'JP_ISDF_LIFE_PENS',

Line 2594: select pay_action_information_s.nextval

2590: close csr_calc_dct;
2591: --
2592: if l_csr_calc_dct.action_information_id is null then
2593: --
2594: select pay_action_information_s.nextval
2595: into l_action_information_id
2596: from dual;
2597: --
2598: pay_jp_isdf_dml_pkg.create_calc_dct(

Line 2754: select pay_action_information_s.nextval

2750: close csr_calc_dct;
2751: --
2752: if l_csr_calc_dct.action_information_id is null then
2753: --
2754: select pay_action_information_s.nextval
2755: into l_action_information_id
2756: from dual;
2757: --
2758: pay_jp_isdf_dml_pkg.create_calc_dct(

Line 2843: select pay_action_information_s.nextval

2839: close csr_entry;
2840: --
2841: if l_csr_entry.action_information_id is null then
2842: --
2843: select pay_action_information_s.nextval
2844: into l_action_information_id
2845: from dual;
2846: --
2847: pay_jp_isdf_dml_pkg.create_entry(

Line 3035: from pay_action_information

3031: hr_utility.trace('start calc_dct before finalize');
3032: end if;
3033: --
3034: delete
3035: from pay_action_information
3036: where action_context_id = l_assact_rec.assignment_action_id
3037: and action_context_type = 'AAP'
3038: and action_information_category <> 'JP_ISDF_ASSACT';
3039: --

Line 4668: from pay_action_information

4664: select rowid row_id,
4665: action_information_id,
4666: object_version_number,
4667: action_information_category
4668: from pay_action_information
4669: where action_context_id = l_assact_rec.assignment_action_id
4670: and action_context_type = 'AAP'
4671: and action_information_category <> 'JP_ISDF_ASSACT'
4672: and action_information1 <> 'D';

Line 4771: from pay_action_information

4767: --
4768: if p_mode = 'ZAP' then
4769: --
4770: delete
4771: from pay_action_information
4772: where action_context_id = l_assact_rec.assignment_action_id
4773: and action_context_type = 'AAP'
4774: and action_information_category <> 'JP_ISDF_ASSACT';
4775: --

Line 4791: update pay_action_information

4787: else
4788: l_object_version_number := l_csr_del.object_version_number + 1;
4789: end if;
4790: --
4791: update pay_action_information
4792: set object_version_number = l_object_version_number,
4793: action_information1 = 'D'
4794: where rowid = l_csr_del.row_id;
4795: --