APPS.PAY_IE_NES_REPORT_PKG dependencies on PAY_ACTION_INFORMATION

Line 889: pay_action_information_api.create_action_information

885: END IF;
886:
887: hr_utility.set_location('Before entering record for IE_NES_HEADER ', 380);
888:
889: pay_action_information_api.create_action_information
890: ( p_action_information_id => l_action_info_id
891: ,p_action_context_id => pactid
892: ,p_action_context_type => 'PA'
893: ,p_object_version_number => l_ovn

Line 2906: pay_action_information_api.create_action_information

2902: /* 10081528 end */
2903:
2904: hr_utility.set_location(' l_id_reference '|| l_id_reference,1100);
2905: hr_utility.set_location(' Before Inserting in to IE_NES_EMPLOYEE_INFORMATION ', 890);
2906: pay_action_information_api.create_action_information
2907: ( p_action_information_id => l_action_info_id
2908: ,p_action_context_id => p_assactid
2909: ,p_action_context_type => 'AAP'
2910: ,p_object_version_number => l_ovn

Line 2974: pay_action_information_api.create_action_information

2970: END IF;
2971:
2972:
2973: hr_utility.set_location(' Before Inserting in to IE_NES_PART1 ', 890);
2974: pay_action_information_api.create_action_information
2975: ( p_action_information_id => l_action_info_id
2976: ,p_action_context_id => p_assactid
2977: ,p_action_context_type => 'AAP'
2978: ,p_object_version_number => l_ovn

Line 3082: FROM pay_action_information

3078: action_information6 address_line3,
3079: action_information7 address_line4,
3080: action_information8 address_line5
3081:
3082: FROM pay_action_information
3083: WHERE action_context_id = c_pact_id
3084: AND action_context_type = 'AAP'
3085: AND action_information_category ='IE_NES_EMPLOYEE_INFORMATION';
3086:

Line 3108: FROM pay_action_information

3104: NVL(action_information15,0) prsi_class,
3105: NVL(action_information16,0) ref_period_hours,
3106: NVL(action_information17,0) contracted_hours,
3107: NVL(action_information18,0) overtime_hours
3108: FROM pay_action_information
3109: WHERE action_context_id = c_pact_id
3110: AND action_context_type = 'AAP'
3111: AND action_information_category ='IE_NES_PART1';
3112:

Line 3207: FROM pay_action_information

3203: action_information23 declarant_phone,
3204: action_information24 declarant_email,
3205: action_information25 declare_date,
3206: action_information26 declarant_position
3207: FROM pay_action_information
3208: WHERE action_context_id = c_pact_id
3209: AND action_context_type = 'PA'
3210: AND action_information_category ='IE_NES_HEADER';
3211:

Line 3215: pay_action_information pai

3211:
3212: CURSOR c_total_sample(c_pact_id NUMBER) IS
3213: SELECT count(*)
3214: FROM pay_assignment_actions paa,
3215: pay_action_information pai
3216: WHERE paa.payroll_action_id=c_pact_id
3217: AND paa.source_action_id is null
3218: AND pai.action_context_id=paa.assignment_action_id
3219: AND pai.action_information_category='IE_NES_PART1';