APPS.HR_WORKFLOW_SS dependencies on PER_ALL_ASSIGNMENTS_F

Line 750: l_assignment_id per_all_assignments_f.assignment_id%type default null;

746: funmode in varchar2,
747: result out nocopy varchar2 ) IS
748:
749:
750: l_assignment_id per_all_assignments_f.assignment_id%type default null;
751: l_payroll_id per_all_assignments_f.payroll_id%type default null;
752: l_old_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
753: l_new_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
754: l_pay_period_start_date date default null;

Line 751: l_payroll_id per_all_assignments_f.payroll_id%type default null;

747: result out nocopy varchar2 ) IS
748:
749:
750: l_assignment_id per_all_assignments_f.assignment_id%type default null;
751: l_payroll_id per_all_assignments_f.payroll_id%type default null;
752: l_old_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
753: l_new_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
754: l_pay_period_start_date date default null;
755: l_pay_period_end_date date default null;

Line 752: l_old_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;

748:
749:
750: l_assignment_id per_all_assignments_f.assignment_id%type default null;
751: l_payroll_id per_all_assignments_f.payroll_id%type default null;
752: l_old_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
753: l_new_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
754: l_pay_period_start_date date default null;
755: l_pay_period_end_date date default null;
756:

Line 753: l_new_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;

749:
750: l_assignment_id per_all_assignments_f.assignment_id%type default null;
751: l_payroll_id per_all_assignments_f.payroll_id%type default null;
752: l_old_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
753: l_new_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
754: l_pay_period_start_date date default null;
755: l_pay_period_end_date date default null;
756:
757: l_asg_txn_step_id hr_api_transaction_steps.transaction_step_id%type

Line 788: FROM per_all_assignments_f

784:
785: -- Get existing assignment data
786: CURSOR csr_get_old_asg_data IS
787: SELECT pay_basis_id
788: FROM per_all_assignments_f
789: WHERE assignment_id = l_assignment_id
790: AND l_effective_date between effective_start_date
791: and effective_end_date
792: AND assignment_type = 'E';