APPS.HR_WORKFLOW_SS dependencies on PER_ALL_ASSIGNMENTS_F

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

780: funmode in varchar2,
781: result out nocopy varchar2 ) IS
782:
783:
784: l_assignment_id per_all_assignments_f.assignment_id%type default null;
785: l_payroll_id per_all_assignments_f.payroll_id%type default null;
786: l_old_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
787: l_new_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
788: l_pay_period_start_date date default null;

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

781: result out nocopy varchar2 ) IS
782:
783:
784: l_assignment_id per_all_assignments_f.assignment_id%type default null;
785: l_payroll_id per_all_assignments_f.payroll_id%type default null;
786: l_old_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
787: l_new_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
788: l_pay_period_start_date date default null;
789: l_pay_period_end_date date default null;

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

782:
783:
784: l_assignment_id per_all_assignments_f.assignment_id%type default null;
785: l_payroll_id per_all_assignments_f.payroll_id%type default null;
786: l_old_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
787: l_new_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
788: l_pay_period_start_date date default null;
789: l_pay_period_end_date date default null;
790:

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

783:
784: l_assignment_id per_all_assignments_f.assignment_id%type default null;
785: l_payroll_id per_all_assignments_f.payroll_id%type default null;
786: l_old_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
787: l_new_pay_basis_id per_all_assignments_f.pay_basis_id%type default null;
788: l_pay_period_start_date date default null;
789: l_pay_period_end_date date default null;
790:
791: l_asg_txn_step_id hr_api_transaction_steps.transaction_step_id%type

Line 822: FROM per_all_assignments_f

818:
819: -- Get existing assignment data
820: CURSOR csr_get_old_asg_data IS
821: SELECT pay_basis_id
822: FROM per_all_assignments_f
823: WHERE assignment_id = l_assignment_id
824: AND l_effective_date between effective_start_date
825: and effective_end_date
826: AND assignment_type = 'E';