DBA Data[Home] [Help]

APPS.PAY_US_GET_ITEM_DATA_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 1199: from pay_payroll_Actions

1195: -- in legislative_prameters for a given Payroll_action_id
1196: cursor c_get_legislative_parameter( c_payroll_action_id number)
1197: IS
1198: select legislative_parameters
1199: from pay_payroll_Actions
1200: where payroll_action_id = c_payroll_action_id;
1201:
1202: parameter_list varchar2(2000);
1203: start_ptr number;

Line 1205: token_val pay_payroll_actions.legislative_parameters%type;

1201:
1202: parameter_list varchar2(2000);
1203: start_ptr number;
1204: end_ptr number;
1205: token_val pay_payroll_actions.legislative_parameters%type;
1206: par_value pay_payroll_actions.legislative_parameters%type;
1207: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
1208: BEGIN
1209: --l_payroll_action_id := pay_magtape_generic.get_parameter_value

Line 1206: par_value pay_payroll_actions.legislative_parameters%type;

1202: parameter_list varchar2(2000);
1203: start_ptr number;
1204: end_ptr number;
1205: token_val pay_payroll_actions.legislative_parameters%type;
1206: par_value pay_payroll_actions.legislative_parameters%type;
1207: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
1208: BEGIN
1209: --l_payroll_action_id := pay_magtape_generic.get_parameter_value
1210: -- ('TRANSFER_PAYROLL_ACTION_ID');

Line 1207: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;

1203: start_ptr number;
1204: end_ptr number;
1205: token_val pay_payroll_actions.legislative_parameters%type;
1206: par_value pay_payroll_actions.legislative_parameters%type;
1207: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
1208: BEGIN
1209: --l_payroll_action_id := pay_magtape_generic.get_parameter_value
1210: -- ('TRANSFER_PAYROLL_ACTION_ID');
1211: --