APPS.PAY_GB_RTI_P60 dependencies on PAY_MESSAGE_LINES

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

4752: )
4753:
4754: ORDER BY end_date DESC;
4755:
4756: -- Cursor to fetch error Messages from pay_message lines table
4757: CURSOR csr_err_msg(asg_action_id NUMBER)
4758: IS
4759: SELECT DISTINCT line_text
4760: FROM pay_message_lines

Line 4760: FROM pay_message_lines

4756: -- Cursor to fetch error Messages from pay_message lines table
4757: CURSOR csr_err_msg(asg_action_id NUMBER)
4758: IS
4759: SELECT DISTINCT line_text
4760: FROM pay_message_lines
4761: WHERE source_id = asg_action_id
4762: AND message_level <> 'W'-- p_message_level
4763: AND payroll_id = 100;
4764:

Line 4768: FROM pay_message_lines

4764:
4765: CURSOR csr_warn_msg(asg_action_id NUMBER)
4766: IS
4767: SELECT DISTINCT line_text
4768: FROM pay_message_lines
4769: WHERE source_id = asg_action_id
4770: AND message_level = 'W'
4771: AND payroll_id = 100;
4772:

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

4819:
4820: OPEN csr_err_msg(action_id.asg_action_id);
4821: FETCH csr_err_msg INTO err_msg;
4822: if csr_err_msg%notfound then
4823: SELECT LINE_TEXT into err_msg FROM pay_message_lines WHERE source_id = action_id.asg_action_id and rownum <=1;
4824: end if;
4825:
4826: l_error_flag := 'Y';
4827: