APPS.PAY_GB_RTI dependencies on PAY_MESSAGE_LINES

Line 713: INSERT INTO pay_message_lines(line_sequence,

709: )
710: IS
711: PRAGMA AUTONOMOUS_TRANSACTION;
712: BEGIN
713: INSERT INTO pay_message_lines(line_sequence,
714: payroll_id,
715: message_level,
716: source_id,
717: source_type,

Line 720: pay_message_lines_s.nextval

716: source_id,
717: source_type,
718: line_text)
719: VALUES(
720: pay_message_lines_s.nextval
721: ,100
722: ,'F'
723: ,p_assignment_action_id
724: ,'A'

Line 2939: -- Cursor to fetch error Messages from pay_message lines table

2935: and past.ASSIGNMENT_STATUS_TYPE_ID = paa.ASSIGNMENT_STATUS_TYPE_ID
2936: and past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
2937: and l_nino_eff_date between pap.EFFECTIVE_START_DATE and pap.EFFECTIVE_END_DATE
2938: order by end_date desc;
2939: -- Cursor to fetch error Messages from pay_message lines table
2940: cursor csr_err_msg(asg_action_id number) is
2941: select distinct line_text from pay_message_lines where source_id = asg_action_id and payroll_id = 100;
2942:
2943: err_msg csr_err_msg%rowtype;

Line 2941: select distinct line_text from pay_message_lines where source_id = asg_action_id and payroll_id = 100;

2937: and l_nino_eff_date between pap.EFFECTIVE_START_DATE and pap.EFFECTIVE_END_DATE
2938: order by end_date desc;
2939: -- Cursor to fetch error Messages from pay_message lines table
2940: cursor csr_err_msg(asg_action_id number) is
2941: select distinct line_text from pay_message_lines where source_id = asg_action_id and payroll_id = 100;
2942:
2943: err_msg csr_err_msg%rowtype;
2944:
2945: et_asg_rec get_person_details%rowtype;