DBA Data[Home] [Help]

APPS.PAY_US_GET_ITEM_DATA_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 1081: from pay_payroll_Actions

1077: -- in legislative_prameters for a given Payroll_action_id
1078: cursor c_get_legislative_parameter( c_payroll_action_id number)
1079: IS
1080: select legislative_parameters
1081: from pay_payroll_Actions
1082: where payroll_action_id = c_payroll_action_id;
1083:
1084: parameter_list varchar2(2000);
1085: start_ptr number;

Line 1087: token_val pay_payroll_actions.legislative_parameters%type;

1083:
1084: parameter_list varchar2(2000);
1085: start_ptr number;
1086: end_ptr number;
1087: token_val pay_payroll_actions.legislative_parameters%type;
1088: par_value pay_payroll_actions.legislative_parameters%type;
1089: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
1090: BEGIN
1091: --l_payroll_action_id := pay_magtape_generic.get_parameter_value

Line 1088: par_value pay_payroll_actions.legislative_parameters%type;

1084: parameter_list varchar2(2000);
1085: start_ptr number;
1086: end_ptr number;
1087: token_val pay_payroll_actions.legislative_parameters%type;
1088: par_value pay_payroll_actions.legislative_parameters%type;
1089: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
1090: BEGIN
1091: --l_payroll_action_id := pay_magtape_generic.get_parameter_value
1092: -- ('TRANSFER_PAYROLL_ACTION_ID');

Line 1089: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;

1085: start_ptr number;
1086: end_ptr number;
1087: token_val pay_payroll_actions.legislative_parameters%type;
1088: par_value pay_payroll_actions.legislative_parameters%type;
1089: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
1090: BEGIN
1091: --l_payroll_action_id := pay_magtape_generic.get_parameter_value
1092: -- ('TRANSFER_PAYROLL_ACTION_ID');
1093: --