APPS.PAY_MX_SS_ARCH_TRAN_DATE_UPG dependencies on PAY_ACTION_INFORMATION

Line 70: pay_action_information pai

66: CURSOR csr_qualified IS
67: SELECT 'Y'
68: FROM pay_payroll_actions ppa,
69: pay_assignment_actions paa,
70: pay_action_information pai
71: WHERE ppa.payroll_action_id = paa.payroll_action_id
72: AND paa.assignment_action_id = pai.action_context_id
73: AND pai.action_information_category = 'MX SS TRANSACTIONS'
74: AND paa.assignment_id = p_object_id

Line 115: pay_action_information pai

111: pai.action_information_id,
112: pai.object_version_number
113: FROM pay_payroll_actions ppa,
114: pay_assignment_actions paa,
115: pay_action_information pai
116: WHERE ppa.payroll_action_id = paa.payroll_action_id
117: AND paa.assignment_action_id = pai.action_context_id
118: AND pai.action_information_category = 'MX SS TRANSACTIONS'
119: AND paa.assignment_id = p_object_id

Line 124: lv_transaction_date pay_action_information.action_information5%type;

120: AND ppa.report_type = 'SS_ARCHIVE'
121: AND ppa.report_qualifier = 'SS_ARCHIVE'
122: AND ppa.report_category = 'RT';
123:
124: lv_transaction_date pay_action_information.action_information5%type;
125: lv_er_ss_id pay_action_information.action_information2%type;
126: ln_act_info_id number;
127: l_object_version_number number;
128:

Line 125: lv_er_ss_id pay_action_information.action_information2%type;

121: AND ppa.report_qualifier = 'SS_ARCHIVE'
122: AND ppa.report_category = 'RT';
123:
124: lv_transaction_date pay_action_information.action_information5%type;
125: lv_er_ss_id pay_action_information.action_information2%type;
126: ln_act_info_id number;
127: l_object_version_number number;
128:
129: l_proc_name varchar2(100);

Line 145: pay_action_information_api.update_action_information

141: ln_act_info_id,
142: l_object_version_number;
143: EXIT WHEN csr_upgrade%NOTFOUND;
144:
145: pay_action_information_api.update_action_information
146: (p_action_information_id => ln_act_info_id,
147: p_object_version_number => l_object_version_number,
148: p_action_information2 => lv_transaction_date,
149: p_action_information5 => lv_er_ss_id);