40: p_source_id IN NUMBER,
41: p_source_type IN VARCHAR2) RETURN VARCHAR2
42: -------------------------------------------------------------------------------
43: -- Returns 'Y' or 'N' which indicates message lines exist or not in
44: -- PAY_MESSAGE_LINES table. In most environment, you would specify
45: -- p_source_type = 'A' when source_id means assignment_action_id.
46: -------------------------------------------------------------------------------
47: IS
48: l_messages_exist VARCHAR2(1);
50: select 'Y'
51: from dual
52: where exists(
53: select NULL
54: from pay_message_lines pml
55: where pml.source_id = p_source_id
56: and pml.source_type = p_source_type);
57: BEGIN
58: open csr_messages_exist;