APPS.PAY_CA_RL1_MAG dependencies on PER_ASSIGNMENTS_F

Line 1238: l_asg_id per_assignments_f.assignment_id%TYPE;

1234: p_rep_type in varchar2)
1235: RETURN BLOB IS
1236:
1237: l_arch_pay_actid pay_assignment_actions.payroll_action_id%TYPE;
1238: l_asg_id per_assignments_f.assignment_id%TYPE;
1239: l_province varchar2(30);
1240: lv_negative_bal_flag VARCHAR2(5);
1241: l_is_temp_final_xml VARCHAR2(2);
1242: p_xml_blob BLOB;

Line 1401: l_asg_id per_assignments_f.assignment_id%TYPE;

1397:
1398: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
1399: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1400: l_arch_pay_actid pay_assignment_actions.payroll_action_id%TYPE;
1401: l_asg_id per_assignments_f.assignment_id%TYPE;
1402: l_date_earned DATE;
1403: l_province VARCHAR2(30);
1404: l_payroll_actid NUMBER;
1405: l_rep_type VARCHAR2(30);

Line 1547: p_asg_id in per_assignments_f.assignment_id%TYPE,

1543: in RL1 CP and in online RL1
1544: =============================================================*/
1545: PROCEDURE fetch_rl1_xml(p_arch_action_id in pay_assignment_actions.assignment_action_id%TYPE,
1546: p_arch_pay_actid in pay_assignment_actions.payroll_action_id%TYPE,
1547: p_asg_id in per_assignments_f.assignment_id%TYPE,
1548: p_rep_type in varchar2,
1549: p_province in varchar2,
1550: p_taxation_year in varchar2,
1551: p_print_instruction in varchar2,