APPS.PAY_GB_ENROLL_PENSION dependencies on PAY_MESSAGE_LINES

Line 2790: INTO pay_message_lines

2786: PRAGMA AUTONOMOUS_TRANSACTION;
2787: BEGIN
2788: hr_utility.set_location(' Entering: populate_run_msg',111);
2789: INSERT
2790: INTO pay_message_lines
2791: (
2792: line_sequence,
2793: payroll_id,
2794: message_level,

Line 2801: pay_message_lines_s.nextval ,

2797: line_text
2798: )
2799: VALUES
2800: (
2801: pay_message_lines_s.nextval ,
2802: 123 ,
2803: 'F' ,
2804: p_assignment_action_id ,
2805: 'A' ,

Line 2826: INTO pay_message_lines

2822: PRAGMA AUTONOMOUS_TRANSACTION;
2823: BEGIN
2824: hr_utility.set_location(' Entering: populate_warn_msg',111);
2825: INSERT
2826: INTO pay_message_lines
2827: (
2828: line_sequence,
2829: payroll_id,
2830: message_level,

Line 2837: pay_message_lines_s.nextval ,

2833: line_text
2834: )
2835: VALUES
2836: (
2837: pay_message_lines_s.nextval ,
2838: 111 ,
2839: 'W' ,
2840: p_assignment_action_id ,
2841: 'A' ,

Line 3103: FROM PAY_MESSAGE_LINES

3099: AND paa.action_status = 'C'
3100: --Bug 14492289 - Reporting EJH in separate Sections
3101: AND NOT EXISTS
3102: (SELECT 1
3103: FROM PAY_MESSAGE_LINES
3104: WHERE PAYROLL_ID = 123
3105: AND MESSAGE_LEVEL ='F'
3106: AND SOURCE_ID = PAA.ASSIGNMENT_ACTION_ID
3107: AND SOURCE_TYPE = 'A'

Line 3126: FROM PAY_MESSAGE_LINES

3122: ( paa.action_status = 'E'
3123: OR (paa.action_status = 'C'
3124: AND EXISTS
3125: (SELECT 1
3126: FROM PAY_MESSAGE_LINES
3127: WHERE PAYROLL_ID = 123
3128: AND MESSAGE_LEVEL ='F'
3129: AND SOURCE_ID = PAA.ASSIGNMENT_ACTION_ID
3130: AND SOURCE_TYPE = 'A'

Line 3149: FROM pay_message_lines

3145: ---To Fetch Messages
3146: CURSOR get_messages(p_assignment_action_id NUMBER)
3147: IS
3148: SELECT DISTINCT line_text
3149: FROM pay_message_lines
3150: WHERE source_id = p_assignment_action_id
3151: AND payroll_id = 123;
3152: --To Fetch Warning Messages
3153: CURSOR get_warn_messages(p_assignment_action_id NUMBER)

Line 3156: FROM pay_message_lines

3152: --To Fetch Warning Messages
3153: CURSOR get_warn_messages(p_assignment_action_id NUMBER)
3154: IS
3155: SELECT DISTINCT line_text
3156: FROM pay_message_lines
3157: WHERE source_id = p_assignment_action_id
3158: AND payroll_id = 111;
3159: l_assgn_number per_all_assignments_f.assignment_number%type;
3160: BEGIN

Line 4163: SELECT SUBSTR(line_text,1,240) FROM PAY_MESSAGE_LINES

4159: ORDER BY PETF.EFFECTIVE_START_DATE DESC;
4160:
4161: /*
4162: CURSOR C_ERROR_MSG IS
4163: SELECT SUBSTR(line_text,1,240) FROM PAY_MESSAGE_LINES
4164: WHERE PAYROLL_ID = 123 AND MESSAGE_LEVEL ='F' AND SOURCE_ID = P_ASSACTID AND SOURCE_TYPE = 'A';
4165: */
4166: ---------------------------------------------------------------------------------------------
4167: -- to get pensions staging date at Payroll level