eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PAY_P45_PKG dependencies on FF_USER_ENTITIES

Line 287: g_address_line1_eid ff_user_entities.user_entity_id%TYPE;

283: g_business_group_id hr_organization_units.business_group_id%TYPE;
284: g_do_edi_validation BOOLEAN;
285: g_tax_ref VARCHAR2(20);
286: -- User Entity Ids
287: g_address_line1_eid ff_user_entities.user_entity_id%TYPE;
288: g_address_line2_eid ff_user_entities.user_entity_id%TYPE;
289: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;
290: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;
291: g_county_eid ff_user_entities.user_entity_id%TYPE;

Line 288: g_address_line2_eid ff_user_entities.user_entity_id%TYPE;

284: g_do_edi_validation BOOLEAN;
285: g_tax_ref VARCHAR2(20);
286: -- User Entity Ids
287: g_address_line1_eid ff_user_entities.user_entity_id%TYPE;
288: g_address_line2_eid ff_user_entities.user_entity_id%TYPE;
289: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;
290: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;
291: g_county_eid ff_user_entities.user_entity_id%TYPE;
292: g_deceased_flag_eid ff_user_entities.user_entity_id%TYPE;

Line 289: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;

285: g_tax_ref VARCHAR2(20);
286: -- User Entity Ids
287: g_address_line1_eid ff_user_entities.user_entity_id%TYPE;
288: g_address_line2_eid ff_user_entities.user_entity_id%TYPE;
289: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;
290: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;
291: g_county_eid ff_user_entities.user_entity_id%TYPE;
292: g_deceased_flag_eid ff_user_entities.user_entity_id%TYPE;
293: g_first_name_eid ff_user_entities.user_entity_id%TYPE;

Line 290: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;

286: -- User Entity Ids
287: g_address_line1_eid ff_user_entities.user_entity_id%TYPE;
288: g_address_line2_eid ff_user_entities.user_entity_id%TYPE;
289: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;
290: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;
291: g_county_eid ff_user_entities.user_entity_id%TYPE;
292: g_deceased_flag_eid ff_user_entities.user_entity_id%TYPE;
293: g_first_name_eid ff_user_entities.user_entity_id%TYPE;
294: g_middle_name_eid ff_user_entities.user_entity_id%TYPE; /*Bug 6710229*/

Line 291: g_county_eid ff_user_entities.user_entity_id%TYPE;

287: g_address_line1_eid ff_user_entities.user_entity_id%TYPE;
288: g_address_line2_eid ff_user_entities.user_entity_id%TYPE;
289: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;
290: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;
291: g_county_eid ff_user_entities.user_entity_id%TYPE;
292: g_deceased_flag_eid ff_user_entities.user_entity_id%TYPE;
293: g_first_name_eid ff_user_entities.user_entity_id%TYPE;
294: g_middle_name_eid ff_user_entities.user_entity_id%TYPE; /*Bug 6710229*/
295: g_issue_date_eid ff_user_entities.user_entity_id%TYPE;

Line 292: g_deceased_flag_eid ff_user_entities.user_entity_id%TYPE;

288: g_address_line2_eid ff_user_entities.user_entity_id%TYPE;
289: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;
290: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;
291: g_county_eid ff_user_entities.user_entity_id%TYPE;
292: g_deceased_flag_eid ff_user_entities.user_entity_id%TYPE;
293: g_first_name_eid ff_user_entities.user_entity_id%TYPE;
294: g_middle_name_eid ff_user_entities.user_entity_id%TYPE; /*Bug 6710229*/
295: g_issue_date_eid ff_user_entities.user_entity_id%TYPE;
296: g_last_name_eid ff_user_entities.user_entity_id%TYPE;

Line 293: g_first_name_eid ff_user_entities.user_entity_id%TYPE;

289: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;
290: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;
291: g_county_eid ff_user_entities.user_entity_id%TYPE;
292: g_deceased_flag_eid ff_user_entities.user_entity_id%TYPE;
293: g_first_name_eid ff_user_entities.user_entity_id%TYPE;
294: g_middle_name_eid ff_user_entities.user_entity_id%TYPE; /*Bug 6710229*/
295: g_issue_date_eid ff_user_entities.user_entity_id%TYPE;
296: g_last_name_eid ff_user_entities.user_entity_id%TYPE;
297: g_month_number_eid ff_user_entities.user_entity_id%TYPE;

Line 294: g_middle_name_eid ff_user_entities.user_entity_id%TYPE; /Bug 6710229/

290: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;
291: g_county_eid ff_user_entities.user_entity_id%TYPE;
292: g_deceased_flag_eid ff_user_entities.user_entity_id%TYPE;
293: g_first_name_eid ff_user_entities.user_entity_id%TYPE;
294: g_middle_name_eid ff_user_entities.user_entity_id%TYPE; /*Bug 6710229*/
295: g_issue_date_eid ff_user_entities.user_entity_id%TYPE;
296: g_last_name_eid ff_user_entities.user_entity_id%TYPE;
297: g_month_number_eid ff_user_entities.user_entity_id%TYPE;
298: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;

Line 295: g_issue_date_eid ff_user_entities.user_entity_id%TYPE;

291: g_county_eid ff_user_entities.user_entity_id%TYPE;
292: g_deceased_flag_eid ff_user_entities.user_entity_id%TYPE;
293: g_first_name_eid ff_user_entities.user_entity_id%TYPE;
294: g_middle_name_eid ff_user_entities.user_entity_id%TYPE; /*Bug 6710229*/
295: g_issue_date_eid ff_user_entities.user_entity_id%TYPE;
296: g_last_name_eid ff_user_entities.user_entity_id%TYPE;
297: g_month_number_eid ff_user_entities.user_entity_id%TYPE;
298: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;
299: g_organization_name_eid ff_user_entities.user_entity_id%TYPE;

Line 296: g_last_name_eid ff_user_entities.user_entity_id%TYPE;

292: g_deceased_flag_eid ff_user_entities.user_entity_id%TYPE;
293: g_first_name_eid ff_user_entities.user_entity_id%TYPE;
294: g_middle_name_eid ff_user_entities.user_entity_id%TYPE; /*Bug 6710229*/
295: g_issue_date_eid ff_user_entities.user_entity_id%TYPE;
296: g_last_name_eid ff_user_entities.user_entity_id%TYPE;
297: g_month_number_eid ff_user_entities.user_entity_id%TYPE;
298: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;
299: g_organization_name_eid ff_user_entities.user_entity_id%TYPE;
300: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;

Line 297: g_month_number_eid ff_user_entities.user_entity_id%TYPE;

293: g_first_name_eid ff_user_entities.user_entity_id%TYPE;
294: g_middle_name_eid ff_user_entities.user_entity_id%TYPE; /*Bug 6710229*/
295: g_issue_date_eid ff_user_entities.user_entity_id%TYPE;
296: g_last_name_eid ff_user_entities.user_entity_id%TYPE;
297: g_month_number_eid ff_user_entities.user_entity_id%TYPE;
298: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;
299: g_organization_name_eid ff_user_entities.user_entity_id%TYPE;
300: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
301: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;

Line 298: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;

294: g_middle_name_eid ff_user_entities.user_entity_id%TYPE; /*Bug 6710229*/
295: g_issue_date_eid ff_user_entities.user_entity_id%TYPE;
296: g_last_name_eid ff_user_entities.user_entity_id%TYPE;
297: g_month_number_eid ff_user_entities.user_entity_id%TYPE;
298: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;
299: g_organization_name_eid ff_user_entities.user_entity_id%TYPE;
300: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
301: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;
302: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;

Line 299: g_organization_name_eid ff_user_entities.user_entity_id%TYPE;

295: g_issue_date_eid ff_user_entities.user_entity_id%TYPE;
296: g_last_name_eid ff_user_entities.user_entity_id%TYPE;
297: g_month_number_eid ff_user_entities.user_entity_id%TYPE;
298: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;
299: g_organization_name_eid ff_user_entities.user_entity_id%TYPE;
300: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
301: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;
302: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
303: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;

Line 300: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;

296: g_last_name_eid ff_user_entities.user_entity_id%TYPE;
297: g_month_number_eid ff_user_entities.user_entity_id%TYPE;
298: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;
299: g_organization_name_eid ff_user_entities.user_entity_id%TYPE;
300: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
301: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;
302: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
303: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
304: g_student_loan_flag_eid ff_user_entities.user_entity_id%TYPE;

Line 301: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;

297: g_month_number_eid ff_user_entities.user_entity_id%TYPE;
298: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;
299: g_organization_name_eid ff_user_entities.user_entity_id%TYPE;
300: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
301: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;
302: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
303: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
304: g_student_loan_flag_eid ff_user_entities.user_entity_id%TYPE;
305: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;

Line 302: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;

298: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;
299: g_organization_name_eid ff_user_entities.user_entity_id%TYPE;
300: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
301: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;
302: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
303: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
304: g_student_loan_flag_eid ff_user_entities.user_entity_id%TYPE;
305: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;
306: g_period_of_service_eid ff_user_entities.user_entity_id%TYPE;

Line 303: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;

299: g_organization_name_eid ff_user_entities.user_entity_id%TYPE;
300: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
301: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;
302: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
303: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
304: g_student_loan_flag_eid ff_user_entities.user_entity_id%TYPE;
305: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;
306: g_period_of_service_eid ff_user_entities.user_entity_id%TYPE;
307: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;

Line 304: g_student_loan_flag_eid ff_user_entities.user_entity_id%TYPE;

300: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
301: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;
302: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
303: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
304: g_student_loan_flag_eid ff_user_entities.user_entity_id%TYPE;
305: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;
306: g_period_of_service_eid ff_user_entities.user_entity_id%TYPE;
307: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;
308: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;

Line 305: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;

301: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;
302: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
303: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
304: g_student_loan_flag_eid ff_user_entities.user_entity_id%TYPE;
305: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;
306: g_period_of_service_eid ff_user_entities.user_entity_id%TYPE;
307: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;
308: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;
309: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;

Line 306: g_period_of_service_eid ff_user_entities.user_entity_id%TYPE;

302: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
303: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
304: g_student_loan_flag_eid ff_user_entities.user_entity_id%TYPE;
305: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;
306: g_period_of_service_eid ff_user_entities.user_entity_id%TYPE;
307: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;
308: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;
309: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
310: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;

Line 307: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;

303: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
304: g_student_loan_flag_eid ff_user_entities.user_entity_id%TYPE;
305: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;
306: g_period_of_service_eid ff_user_entities.user_entity_id%TYPE;
307: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;
308: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;
309: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
310: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;
311: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;

Line 308: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;

304: g_student_loan_flag_eid ff_user_entities.user_entity_id%TYPE;
305: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;
306: g_period_of_service_eid ff_user_entities.user_entity_id%TYPE;
307: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;
308: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;
309: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
310: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;
311: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
312: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;

Line 309: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;

305: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;
306: g_period_of_service_eid ff_user_entities.user_entity_id%TYPE;
307: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;
308: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;
309: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
310: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;
311: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
312: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;
313: g_title_eid ff_user_entities.user_entity_id%TYPE;

Line 310: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;

306: g_period_of_service_eid ff_user_entities.user_entity_id%TYPE;
307: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;
308: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;
309: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
310: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;
311: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
312: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;
313: g_title_eid ff_user_entities.user_entity_id%TYPE;
314: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;

Line 311: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;

307: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;
308: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;
309: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
310: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;
311: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
312: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;
313: g_title_eid ff_user_entities.user_entity_id%TYPE;
314: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;
315: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;

Line 312: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;

308: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;
309: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
310: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;
311: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
312: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;
313: g_title_eid ff_user_entities.user_entity_id%TYPE;
314: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;
315: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;
316: g_week_number_eid ff_user_entities.user_entity_id%TYPE;

Line 313: g_title_eid ff_user_entities.user_entity_id%TYPE;

309: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
310: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;
311: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
312: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;
313: g_title_eid ff_user_entities.user_entity_id%TYPE;
314: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;
315: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;
316: g_week_number_eid ff_user_entities.user_entity_id%TYPE;
317: g_country_eid ff_user_entities.user_entity_id%TYPE;

Line 314: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;

310: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;
311: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
312: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;
313: g_title_eid ff_user_entities.user_entity_id%TYPE;
314: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;
315: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;
316: g_week_number_eid ff_user_entities.user_entity_id%TYPE;
317: g_country_eid ff_user_entities.user_entity_id%TYPE;
318: g_p45_final_action ff_user_entities.user_entity_id%TYPE;

Line 315: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;

311: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
312: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;
313: g_title_eid ff_user_entities.user_entity_id%TYPE;
314: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;
315: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;
316: g_week_number_eid ff_user_entities.user_entity_id%TYPE;
317: g_country_eid ff_user_entities.user_entity_id%TYPE;
318: g_p45_final_action ff_user_entities.user_entity_id%TYPE;
319: g_p45_inc_assignment ff_user_entities.user_entity_id%TYPE;

Line 316: g_week_number_eid ff_user_entities.user_entity_id%TYPE;

312: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;
313: g_title_eid ff_user_entities.user_entity_id%TYPE;
314: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;
315: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;
316: g_week_number_eid ff_user_entities.user_entity_id%TYPE;
317: g_country_eid ff_user_entities.user_entity_id%TYPE;
318: g_p45_final_action ff_user_entities.user_entity_id%TYPE;
319: g_p45_inc_assignment ff_user_entities.user_entity_id%TYPE;
320: -- Added for P45PT1. Bug 6345375

Line 317: g_country_eid ff_user_entities.user_entity_id%TYPE;

313: g_title_eid ff_user_entities.user_entity_id%TYPE;
314: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;
315: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;
316: g_week_number_eid ff_user_entities.user_entity_id%TYPE;
317: g_country_eid ff_user_entities.user_entity_id%TYPE;
318: g_p45_final_action ff_user_entities.user_entity_id%TYPE;
319: g_p45_inc_assignment ff_user_entities.user_entity_id%TYPE;
320: -- Added for P45PT1. Bug 6345375
321: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;

Line 318: g_p45_final_action ff_user_entities.user_entity_id%TYPE;

314: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;
315: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;
316: g_week_number_eid ff_user_entities.user_entity_id%TYPE;
317: g_country_eid ff_user_entities.user_entity_id%TYPE;
318: g_p45_final_action ff_user_entities.user_entity_id%TYPE;
319: g_p45_inc_assignment ff_user_entities.user_entity_id%TYPE;
320: -- Added for P45PT1. Bug 6345375
321: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;
322: g_sex_eid ff_user_entities.user_entity_id%TYPE;

Line 319: g_p45_inc_assignment ff_user_entities.user_entity_id%TYPE;

315: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;
316: g_week_number_eid ff_user_entities.user_entity_id%TYPE;
317: g_country_eid ff_user_entities.user_entity_id%TYPE;
318: g_p45_final_action ff_user_entities.user_entity_id%TYPE;
319: g_p45_inc_assignment ff_user_entities.user_entity_id%TYPE;
320: -- Added for P45PT1. Bug 6345375
321: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;
322: g_sex_eid ff_user_entities.user_entity_id%TYPE;
323: -- Seed data IDs

Line 321: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;

317: g_country_eid ff_user_entities.user_entity_id%TYPE;
318: g_p45_final_action ff_user_entities.user_entity_id%TYPE;
319: g_p45_inc_assignment ff_user_entities.user_entity_id%TYPE;
320: -- Added for P45PT1. Bug 6345375
321: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;
322: g_sex_eid ff_user_entities.user_entity_id%TYPE;
323: -- Seed data IDs
324: g_paye_details_id pay_element_types_f.element_type_id%TYPE;
325: --

Line 322: g_sex_eid ff_user_entities.user_entity_id%TYPE;

318: g_p45_final_action ff_user_entities.user_entity_id%TYPE;
319: g_p45_inc_assignment ff_user_entities.user_entity_id%TYPE;
320: -- Added for P45PT1. Bug 6345375
321: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;
322: g_sex_eid ff_user_entities.user_entity_id%TYPE;
323: -- Seed data IDs
324: g_paye_details_id pay_element_types_f.element_type_id%TYPE;
325: --
326: FUNCTION get_report_request_error RETURN VARCHAR2 IS

Line 1361: l_employers_name_eid ff_user_entities.user_entity_id%TYPE;

1357: PROCEDURE range_cursor (pactid IN NUMBER,
1358: sqlstr OUT NOCOPY VARCHAR2)
1359: IS
1360: l_proc CONSTANT VARCHAR2(35):= g_package||'range_cursor';
1361: l_employers_name_eid ff_user_entities.user_entity_id%TYPE;
1362: l_employers_address_line_eid ff_user_entities.user_entity_id%TYPE;
1363: l_tax_district_name_eid ff_user_entities.user_entity_id%TYPE;
1364: -- vars for returns from the API:
1365: l_archive_item_id ff_archive_items.archive_item_id%TYPE;

Line 1362: l_employers_address_line_eid ff_user_entities.user_entity_id%TYPE;

1358: sqlstr OUT NOCOPY VARCHAR2)
1359: IS
1360: l_proc CONSTANT VARCHAR2(35):= g_package||'range_cursor';
1361: l_employers_name_eid ff_user_entities.user_entity_id%TYPE;
1362: l_employers_address_line_eid ff_user_entities.user_entity_id%TYPE;
1363: l_tax_district_name_eid ff_user_entities.user_entity_id%TYPE;
1364: -- vars for returns from the API:
1365: l_archive_item_id ff_archive_items.archive_item_id%TYPE;
1366: l_ovn NUMBER;

Line 1363: l_tax_district_name_eid ff_user_entities.user_entity_id%TYPE;

1359: IS
1360: l_proc CONSTANT VARCHAR2(35):= g_package||'range_cursor';
1361: l_employers_name_eid ff_user_entities.user_entity_id%TYPE;
1362: l_employers_address_line_eid ff_user_entities.user_entity_id%TYPE;
1363: l_tax_district_name_eid ff_user_entities.user_entity_id%TYPE;
1364: -- vars for returns from the API:
1365: l_archive_item_id ff_archive_items.archive_item_id%TYPE;
1366: l_ovn NUMBER;
1367: l_some_warning BOOLEAN;

Line 1382: FROM ff_user_entities

1378: test_indicator_error EXCEPTION;
1379: --
1380: cursor csr_user_entity(p_entity_name VARCHAR2) IS
1381: SELECT user_entity_id
1382: FROM ff_user_entities
1383: WHERE user_entity_name = p_entity_name
1384: AND legislation_code = 'GB'
1385: AND business_group_id IS NULL;
1386: --

Line 2097: FROM ff_user_entities

2093: WHERE payroll_action_id = p_payroll_action_id;
2094: --
2095: cursor csr_user_entity(p_entity_name VARCHAR2) IS
2096: SELECT user_entity_id
2097: FROM ff_user_entities
2098: WHERE user_entity_name = p_entity_name
2099: AND legislation_code = 'GB'
2100: AND business_group_id IS NULL;
2101: --

Line 2613: FROM ff_user_entities

2609: l_effective_date DATE;
2610: --
2611: cursor csr_user_entity(p_entity_name VARCHAR2) IS
2612: SELECT user_entity_id
2613: FROM ff_user_entities
2614: WHERE user_entity_name = p_entity_name
2615: AND legislation_code = 'GB'
2616: AND business_group_id IS NULL;
2617: --

Line 3499: FROM ff_user_entities

3495: l_actid pay_assignment_actions.assignment_action_id%TYPE;
3496: --
3497: cursor csr_user_entity(p_entity_name VARCHAR2) IS
3498: SELECT user_entity_id
3499: FROM ff_user_entities
3500: WHERE user_entity_name = p_entity_name
3501: AND legislation_code = 'GB'
3502: AND business_group_id IS NULL;
3503: --

Line 3799: ff_user_entities fue

3795: upper(nvl(max(decode(fue.user_entity_name,'X_TAX_REF_TRANSFER',fai.VALUE)),' ')) TAX_REF_TRANSFER,
3796: upper(nvl(max(decode(fue.user_entity_name,'X_STUDENT_LOAN_FLAG',fai.VALUE)),' ')) STUDENT_LOAN_FLAG,
3797: upper(nvl(max(decode(fue.user_entity_name,'X_COUNTRY',fai.VALUE)),' ')) COUNTRY
3798: from ff_archive_items fai,
3799: ff_user_entities fue
3800: where x_assignment_action_id = fai.context1
3801: and fai.archive_type <>'PA'
3802: and fai.user_entity_id = fue.user_entity_id;
3803: --

Line 3888: ff_user_entities fue

3884: select upper(nvl(max(decode(fue.user_entity_name,'X_EMPLOYERS_NAME',fai.VALUE)),null)) EMPLOYERS_NAME,
3885: upper(nvl(max(decode(fue.user_entity_name,'X_EMPLOYERS_ADDRESS_LINE',fai.VALUE)),null)) EMPLOYERS_ADDRESS
3886: from ff_archive_item_contexts aic,
3887: ff_archive_items fai,
3888: ff_user_entities fue
3889: where X_PAYROLL_ACTION_ID = fai.context1
3890: and fai.user_entity_id = fue.user_entity_id
3891: and fai.archive_item_id = aic.archive_item_id
3892: and aic.context = '0'

Line 3930: FROM ff_archive_items fai, ff_user_entities fue

3926: AND report_category = 'P45';
3927:
3928: CURSOR csr_transfer_p45(c_assignment_action_id NUMBER) IS
3929: SELECT fai.VALUE
3930: FROM ff_archive_items fai, ff_user_entities fue
3931: WHERE fai.user_entity_id = fue.user_entity_id
3932: AND fue.user_entity_name = 'X_TAX_REF_TRANSFER'
3933: AND fue.legislation_code = 'GB'
3934: AND fue.business_group_id IS NULL

Line 4009: ff_user_entities ue,

4005: /*
4006: Cursor csr_get_final_payment(c_assignment_id NUMBER, c_asg_action_id NUMBER, c_action_sequence NUMBER) IS
4007: select pact1.payroll_action_id, pact1.effective_date final_payment_date
4008: from FF_ARCHIVE_ITEMS ai,
4009: ff_user_entities ue,
4010: pay_payroll_actions pact1
4011: WHERE ue.user_entity_name in ('X_MONTH_NUMBER', 'X_WEEK_NUMBER') -- for the weekly frequency (and multiples)
4012: AND ue.legislation_code = 'GB'
4013: AND ue.business_group_id IS NULL

Line 4105: ff_user_entities fue

4101: --
4102: cursor csr_get_p45_another_asg(c_assignment_id number,c_assignment_action_id number) is
4103: select 1
4104: from ff_archive_items fai,
4105: ff_user_entities fue
4106: where fai.user_entity_id = fue.user_entity_id
4107: and fue.user_entity_name = 'X_P45_INCLUDED_ASSIGNMENT'
4108: and fai.context1 = c_assignment_action_id
4109: and fai.value = to_char(c_assignment_id);