APPS.PAY_GB_RTI_EYU dependencies on PAY_MESSAGE_LINES

Line 2478: INTO pay_message_lines

2474: BEGIN
2475: hr_utility.set_location(' Entering: populate_run_msg',111);
2476:
2477: INSERT
2478: INTO pay_message_lines
2479: (
2480: line_sequence,
2481: payroll_id,
2482: message_level,

Line 2489: pay_message_lines_s.nextval ,

2485: line_text
2486: )
2487: VALUES
2488: (
2489: pay_message_lines_s.nextval ,
2490: 100 ,
2491: p_message_level, --'F' ,
2492: p_assignment_action_id ,
2493: 'A' ,

Line 5842: FROM pay_message_lines

5838: --CURSOR csr_err_msg(asg_action_id NUMBER)
5839: CURSOR csr_prepay_err_msg(asg_action_id NUMBER)
5840: IS
5841: SELECT DISTINCT line_text
5842: FROM pay_message_lines
5843: WHERE source_id = asg_action_id --9919881 --asg_action_id
5844: AND message_level <> 'W'-- p_message_level
5845: AND payroll_id = 100;
5846:

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

6025: )
6026:
6027: ORDER BY end_date DESC;
6028:
6029: -- Cursor to fetch error Messages from pay_message lines table
6030: --CURSOR csr_err_msg(asg_action_id NUMBER)
6031: CURSOR csr_err_msg(asg_action_id NUMBER)
6032: IS
6033: SELECT DISTINCT line_text

Line 6034: FROM pay_message_lines

6030: --CURSOR csr_err_msg(asg_action_id NUMBER)
6031: CURSOR csr_err_msg(asg_action_id NUMBER)
6032: IS
6033: SELECT DISTINCT line_text
6034: FROM pay_message_lines
6035: WHERE source_id = asg_action_id
6036: --AND message_level <> 'W'-- p_message_level
6037: AND payroll_id = 100;
6038:

Line 6079: SELECT LINE_TEXT into err_msg FROM pay_message_lines WHERE source_id = action_id.asg_action_id and rownum <=1;

6075:
6076: OPEN csr_err_msg(action_id.asg_action_id);
6077: FETCH csr_err_msg INTO err_msg;
6078: if csr_err_msg%notfound then
6079: SELECT LINE_TEXT into err_msg FROM pay_message_lines WHERE source_id = action_id.asg_action_id and rownum <=1;
6080: end if;
6081:
6082: l_error_flag := 'Y';
6083: