DBA Data[Home] [Help]

APPS.PAY_SG_CPFLINE_BALANCES dependencies on PER_ALL_ASSIGNMENTS_F

Line 19: assignment_id per_all_assignments_f.assignment_id%type,

15: legal_name varchar2(150),
16: employee_number varchar2(30),
17: permit_type per_people_f.per_information6%type,
18: department varchar2(200),
19: assignment_id per_all_assignments_f.assignment_id%type,
20: assignment_action_id pay_assignment_actions.assignment_action_id%type,
21: tax_unit_id pay_assignment_actions.tax_unit_id%type,
22: effective_date pay_payroll_actions.effective_date%type,
23: cl_record_status varchar2(1),

Line 56: p_assignment_id in per_all_assignments_f.assignment_id%type,

52: -- This function is called from existing_employee and new_employee cursors
53: --------------------------------------------------------------------------
54: function get_balance_value
55: ( p_employee_type in varchar2,
56: p_assignment_id in per_all_assignments_f.assignment_id%type,
57: p_cpf_acc_number in varchar2,
58: p_department in varchar2,
59: p_assignment_action_id in varchar2,
60: p_tax_unit_id in varchar2,