APPS.PAY_CA_EOY_RL1_ARCHIVE dependencies on PAY_ACTION_INFORMATION

Line 92: in pay_action_information table.

88: for Federal is present then subtract
89: it from the gross earnings.
90: 08-NOV-2001 VPandya 115.30 Added QPP Basic Exemption, QPP Exempt
91: Earnings. Archiving RL1 NonBox Footnotes
92: in pay_action_information table.
93: 10-NOV-2001 vpandya 115.31 Added set veify off at top as per GSCC.
94: 12-NOV-2001 vpandya 115.32 Added dbdrv line.
95: 27-DEC-2001 vpandya 115.33 Archiving new DBI
96: CAEOY_EMPLOYEE_DATE_OF_BIRTH

Line 593: from pay_action_information

589:
590: cursor c_get_nonbox_footnote(cp_asg_act_id number) is
591: select action_information4,
592: action_information5
593: from pay_action_information
594: where action_context_id = cp_asg_act_id
595: and action_information_category = 'CA FOOTNOTES'
596: and action_context_type = 'AAP'
597: and action_information6 = 'RL1'

Line 3464: pay_action_information_api.create_action_information(

3460:
3461: if ((lv_max_pensionable_earnings > lv_total_pensionable_earnings) and
3462: (lv_taxable_benefit_with_no_rem <> 0)) then
3463:
3464: pay_action_information_api.create_action_information(
3465: p_action_information_id => l_action_information_id_1,
3466: p_object_version_number => l_object_version_number_1,
3467: p_action_information_category => 'CA FOOTNOTES',
3468: p_action_context_id => p_assactid,

Line 3538: pay_action_information_api.create_action_information(

3534: hr_utility.trace('l_prev_messages - '||l_prev_messages);
3535:
3536: if l_total_mesg_amt <> 0 then
3537:
3538: pay_action_information_api.create_action_information(
3539: p_action_information_id => l_action_information_id_1,
3540: p_object_version_number => l_object_version_number_1,
3541: p_action_information_category => 'CA FOOTNOTES',
3542: p_action_context_id => p_assactid,

Line 3608: pay_action_information_api.create_action_information(

3604: hr_utility.trace('l_total_mesg_amt - '||to_char(l_total_mesg_amt));
3605:
3606: if l_total_mesg_amt <> 0 then
3607:
3608: pay_action_information_api.create_action_information(
3609: p_action_information_id => l_action_information_id_1,
3610: p_object_version_number => l_object_version_number_1,
3611: p_action_information_category => 'CA FOOTNOTES',
3612: p_action_context_id => p_assactid,