APPS.PAY_FR_DADS_ESTAB_COMP dependencies on PAY_ACTION_INFORMATION

Line 29: pay_action_information_api.create_action_information (

25: IF p_lookup_type is not null THEN
26: l_user_value := hr_general.decode_lookup(p_lookup_type,p_file_value);
27: END IF;
28: --
29: pay_action_information_api.create_action_information (
30: p_action_information_id => l_action_info_id
31: , p_action_context_id => p_payroll_action_id
32: , p_action_context_type => 'PA'
33: , p_object_version_number => l_ovn

Line 65: pay_action_information_api.create_action_information (

61: l_ovn NUMBER;
62: --
63: BEGIN
64: --
65: pay_action_information_api.create_action_information (
66: p_action_information_id => l_action_info_id
67: , p_action_context_id => p_payroll_action_id
68: , p_action_context_type => 'PA'
69: , p_object_version_number => l_ovn

Line 2148: from pay_action_information pai_part,

2144: -- Get all employees with their categories and
2145: -- part-time percentage as archived for S41
2146: Cursor csr_emp_headcount(c_effective_date DATE) IS
2147: Select pai_part.action_information4 part_pct
2148: from pay_action_information pai_part,
2149: pay_assignment_actions pasac,
2150: per_all_assignments_f pasg
2151: where pai_part.action_information_category = 'FR_DADS_FILE_DATA'
2152: and pai_part.action_context_id = pasac.assignment_action_id

Line 2156: from pay_action_information pai_sub

2152: and pai_part.action_context_id = pasac.assignment_action_id
2153: and pai_part.action_context_type = 'AAP'
2154: and pai_part.action_information1 ='S41.G01.00.020'
2155: and pai_part.action_information8 = (Select max(pai_sub.action_information8)
2156: from pay_action_information pai_sub
2157: where pai_sub.action_information_category = 'FR_DADS_FILE_DATA'
2158: and pai_sub.action_context_type = 'AAP'
2159: and pai_sub.action_context_id = pasac.assignment_action_id
2160: and pai_sub.action_information1 ='S41.G01.00.020')