DBA Data[Home] [Help]

APPS.PAY_CA_RL2_MAG dependencies on PER_ASSIGNMENTS_F

Line 1307: l_asg_id per_assignments_f.assignment_id%TYPE;

1303: p_rep_type in varchar2)
1304: RETURN BLOB IS
1305:
1306: l_arch_pay_actid pay_assignment_actions.payroll_action_id%TYPE;
1307: l_asg_id per_assignments_f.assignment_id%TYPE;
1308: lv_negative_bal_flag VARCHAR2(5);
1309: l_is_temp_final_xml VARCHAR2(2);
1310: p_xml_blob BLOB;
1311: l_final_xml BLOB;

Line 1478: l_asg_id per_assignments_f.assignment_id%TYPE;

1474: PROCEDURE xml_employee_record IS
1475:
1476: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
1477: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1478: l_asg_id per_assignments_f.assignment_id%TYPE;
1479: l_rep_type pay_report_format_mappings_f.report_type%type;
1480: l_date_earned DATE;
1481: l_taxation_year VARCHAR2(4);
1482: l_print_instruction VARCHAR2(1);

Line 1609: p_asg_id in per_assignments_f.assignment_id%TYPE,

1605:
1606: END xml_employee_record;
1607:
1608: PROCEDURE fetch_rl2_xml(p_arch_action_id in pay_assignment_actions.assignment_action_id%TYPE,
1609: p_asg_id in per_assignments_f.assignment_id%TYPE,
1610: p_rep_type in varchar2,
1611: p_taxation_year in varchar2,
1612: p_print_instruction in varchar2,
1613: called_from in varchar2,