APPS.PAY_NO_K27_REIM_UPLD dependencies on PAY_ACTION_INFORMATION

Line 476: PAY_ACTION_INFORMATION

472: )
473: IS
474: SELECT 'Y'
475: FROM
476: PAY_ACTION_INFORMATION
477: WHERE
478: action_information_category = 'EMEA REPORT INFORMATION'
479: and action_information1 = 'K27_REIMB_UPLOAD'
480: --and action_information2 = p_mun_sso_num

Line 792: pay_action_information_api.create_action_information (

788: , l_mun_sso_num
789: , l_ref_code
790: );
791:
792: pay_action_information_api.create_action_information (
793: p_action_information_id => l_action_info_id
794: ,p_action_context_id => g_payroll_action_id
795: ,p_action_context_type => 'PA'
796: ,p_object_version_number => l_ovn

Line 1262: PAY_ACTION_INFORMATION

1258: IS
1259: SELECT substr(action_information6,1,6)||'-'||substr(action_information6,7,5) NI_number,
1260: to_char(to_date(action_information13,'RRRRMMDD'),'DD-MON-RRRR') Reimb_date
1261: FROM
1262: PAY_ACTION_INFORMATION
1263: WHERE
1264: action_information_category = 'EMEA REPORT INFORMATION'
1265: and action_information1 = 'K27_REIMB_UPLOAD'
1266: and action_information3 = p_legal_employer

Line 1275: pay_action_information pai,

1271: SELECT substr(pai.action_information6,1,6)||'-'||substr(pai.action_information6,7,5) NI_number,
1272: to_char(to_date(pai.action_information13,'RRRRMMDD'),'DD-MON-RRRR') Reimb_date,
1273: papf.employee_number emp_number,
1274: pai.action_information11 reimburse_amount FROM
1275: pay_action_information pai,
1276: per_all_assignments_f paaf ,
1277: per_all_people_f papf
1278: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
1279: and pai.action_information1 = 'K27_REIMB_UPLOAD'