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.

APPS.PAY_P45_PKG dependencies on FF_USER_ENTITIES

Line 335: g_address_line1_eid ff_user_entities.user_entity_id%TYPE;

331: g_do_edi_validation BOOLEAN;
332: g_tax_ref VARCHAR2(20);
333: g_edi_ver VARCHAR2(10);
334: -- User Entity Ids
335: g_address_line1_eid ff_user_entities.user_entity_id%TYPE;
336: g_address_line2_eid ff_user_entities.user_entity_id%TYPE;
337: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;
338: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;
339: g_county_eid ff_user_entities.user_entity_id%TYPE;

Line 336: g_address_line2_eid ff_user_entities.user_entity_id%TYPE;

332: g_tax_ref VARCHAR2(20);
333: g_edi_ver VARCHAR2(10);
334: -- User Entity Ids
335: g_address_line1_eid ff_user_entities.user_entity_id%TYPE;
336: g_address_line2_eid ff_user_entities.user_entity_id%TYPE;
337: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;
338: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;
339: g_county_eid ff_user_entities.user_entity_id%TYPE;
340: g_deceased_flag_eid ff_user_entities.user_entity_id%TYPE;

Line 337: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;

333: g_edi_ver VARCHAR2(10);
334: -- User Entity Ids
335: g_address_line1_eid ff_user_entities.user_entity_id%TYPE;
336: g_address_line2_eid ff_user_entities.user_entity_id%TYPE;
337: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;
338: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;
339: g_county_eid ff_user_entities.user_entity_id%TYPE;
340: g_deceased_flag_eid ff_user_entities.user_entity_id%TYPE;
341: g_first_name_eid ff_user_entities.user_entity_id%TYPE;

Line 338: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;

334: -- User Entity Ids
335: g_address_line1_eid ff_user_entities.user_entity_id%TYPE;
336: g_address_line2_eid ff_user_entities.user_entity_id%TYPE;
337: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;
338: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;
339: g_county_eid ff_user_entities.user_entity_id%TYPE;
340: g_deceased_flag_eid ff_user_entities.user_entity_id%TYPE;
341: g_first_name_eid ff_user_entities.user_entity_id%TYPE;
342: g_middle_name_eid ff_user_entities.user_entity_id%TYPE; /*Bug 6710229*/

Line 339: g_county_eid ff_user_entities.user_entity_id%TYPE;

335: g_address_line1_eid ff_user_entities.user_entity_id%TYPE;
336: g_address_line2_eid ff_user_entities.user_entity_id%TYPE;
337: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;
338: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;
339: g_county_eid ff_user_entities.user_entity_id%TYPE;
340: g_deceased_flag_eid ff_user_entities.user_entity_id%TYPE;
341: g_first_name_eid ff_user_entities.user_entity_id%TYPE;
342: g_middle_name_eid ff_user_entities.user_entity_id%TYPE; /*Bug 6710229*/
343: g_issue_date_eid ff_user_entities.user_entity_id%TYPE;

Line 340: g_deceased_flag_eid ff_user_entities.user_entity_id%TYPE;

336: g_address_line2_eid ff_user_entities.user_entity_id%TYPE;
337: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;
338: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;
339: g_county_eid ff_user_entities.user_entity_id%TYPE;
340: g_deceased_flag_eid ff_user_entities.user_entity_id%TYPE;
341: g_first_name_eid ff_user_entities.user_entity_id%TYPE;
342: g_middle_name_eid ff_user_entities.user_entity_id%TYPE; /*Bug 6710229*/
343: g_issue_date_eid ff_user_entities.user_entity_id%TYPE;
344: g_last_name_eid ff_user_entities.user_entity_id%TYPE;

Line 341: g_first_name_eid ff_user_entities.user_entity_id%TYPE;

337: g_address_line3_eid ff_user_entities.user_entity_id%TYPE;
338: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;
339: g_county_eid ff_user_entities.user_entity_id%TYPE;
340: g_deceased_flag_eid ff_user_entities.user_entity_id%TYPE;
341: g_first_name_eid ff_user_entities.user_entity_id%TYPE;
342: g_middle_name_eid ff_user_entities.user_entity_id%TYPE; /*Bug 6710229*/
343: g_issue_date_eid ff_user_entities.user_entity_id%TYPE;
344: g_last_name_eid ff_user_entities.user_entity_id%TYPE;
345: g_month_number_eid ff_user_entities.user_entity_id%TYPE;

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

338: g_assignment_number_eid ff_user_entities.user_entity_id%TYPE;
339: g_county_eid ff_user_entities.user_entity_id%TYPE;
340: g_deceased_flag_eid ff_user_entities.user_entity_id%TYPE;
341: g_first_name_eid ff_user_entities.user_entity_id%TYPE;
342: g_middle_name_eid ff_user_entities.user_entity_id%TYPE; /*Bug 6710229*/
343: g_issue_date_eid ff_user_entities.user_entity_id%TYPE;
344: g_last_name_eid ff_user_entities.user_entity_id%TYPE;
345: g_month_number_eid ff_user_entities.user_entity_id%TYPE;
346: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;

Line 343: g_issue_date_eid ff_user_entities.user_entity_id%TYPE;

339: g_county_eid ff_user_entities.user_entity_id%TYPE;
340: g_deceased_flag_eid ff_user_entities.user_entity_id%TYPE;
341: g_first_name_eid ff_user_entities.user_entity_id%TYPE;
342: g_middle_name_eid ff_user_entities.user_entity_id%TYPE; /*Bug 6710229*/
343: g_issue_date_eid ff_user_entities.user_entity_id%TYPE;
344: g_last_name_eid ff_user_entities.user_entity_id%TYPE;
345: g_month_number_eid ff_user_entities.user_entity_id%TYPE;
346: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;
347: g_organization_name_eid ff_user_entities.user_entity_id%TYPE;

Line 344: g_last_name_eid ff_user_entities.user_entity_id%TYPE;

340: g_deceased_flag_eid ff_user_entities.user_entity_id%TYPE;
341: g_first_name_eid ff_user_entities.user_entity_id%TYPE;
342: g_middle_name_eid ff_user_entities.user_entity_id%TYPE; /*Bug 6710229*/
343: g_issue_date_eid ff_user_entities.user_entity_id%TYPE;
344: g_last_name_eid ff_user_entities.user_entity_id%TYPE;
345: g_month_number_eid ff_user_entities.user_entity_id%TYPE;
346: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;
347: g_organization_name_eid ff_user_entities.user_entity_id%TYPE;
348: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;

Line 345: g_month_number_eid ff_user_entities.user_entity_id%TYPE;

341: g_first_name_eid ff_user_entities.user_entity_id%TYPE;
342: g_middle_name_eid ff_user_entities.user_entity_id%TYPE; /*Bug 6710229*/
343: g_issue_date_eid ff_user_entities.user_entity_id%TYPE;
344: g_last_name_eid ff_user_entities.user_entity_id%TYPE;
345: g_month_number_eid ff_user_entities.user_entity_id%TYPE;
346: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;
347: g_organization_name_eid ff_user_entities.user_entity_id%TYPE;
348: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
349: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;

Line 346: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;

342: g_middle_name_eid ff_user_entities.user_entity_id%TYPE; /*Bug 6710229*/
343: g_issue_date_eid ff_user_entities.user_entity_id%TYPE;
344: g_last_name_eid ff_user_entities.user_entity_id%TYPE;
345: g_month_number_eid ff_user_entities.user_entity_id%TYPE;
346: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;
347: g_organization_name_eid ff_user_entities.user_entity_id%TYPE;
348: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
349: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;
350: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;

Line 347: g_organization_name_eid ff_user_entities.user_entity_id%TYPE;

343: g_issue_date_eid ff_user_entities.user_entity_id%TYPE;
344: g_last_name_eid ff_user_entities.user_entity_id%TYPE;
345: g_month_number_eid ff_user_entities.user_entity_id%TYPE;
346: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;
347: g_organization_name_eid ff_user_entities.user_entity_id%TYPE;
348: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
349: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;
350: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
351: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;

Line 348: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;

344: g_last_name_eid ff_user_entities.user_entity_id%TYPE;
345: g_month_number_eid ff_user_entities.user_entity_id%TYPE;
346: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;
347: g_organization_name_eid ff_user_entities.user_entity_id%TYPE;
348: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
349: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;
350: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
351: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
352: g_student_loan_flag_eid ff_user_entities.user_entity_id%TYPE;

Line 349: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;

345: g_month_number_eid ff_user_entities.user_entity_id%TYPE;
346: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;
347: g_organization_name_eid ff_user_entities.user_entity_id%TYPE;
348: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
349: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;
350: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
351: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
352: g_student_loan_flag_eid ff_user_entities.user_entity_id%TYPE;
353: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;

Line 350: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;

346: g_ni_number_eid ff_user_entities.user_entity_id%TYPE;
347: g_organization_name_eid ff_user_entities.user_entity_id%TYPE;
348: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
349: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;
350: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
351: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
352: g_student_loan_flag_eid ff_user_entities.user_entity_id%TYPE;
353: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;
354: g_period_of_service_eid ff_user_entities.user_entity_id%TYPE;

Line 351: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;

347: g_organization_name_eid ff_user_entities.user_entity_id%TYPE;
348: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
349: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;
350: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
351: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
352: g_student_loan_flag_eid ff_user_entities.user_entity_id%TYPE;
353: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;
354: g_period_of_service_eid ff_user_entities.user_entity_id%TYPE;
355: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;

Line 352: g_student_loan_flag_eid ff_user_entities.user_entity_id%TYPE;

348: g_payroll_id_eid ff_user_entities.user_entity_id%TYPE;
349: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;
350: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
351: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
352: g_student_loan_flag_eid ff_user_entities.user_entity_id%TYPE;
353: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;
354: g_period_of_service_eid ff_user_entities.user_entity_id%TYPE;
355: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;
356: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;

Line 353: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;

349: g_postal_code_eid ff_user_entities.user_entity_id%TYPE;
350: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
351: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
352: g_student_loan_flag_eid ff_user_entities.user_entity_id%TYPE;
353: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;
354: g_period_of_service_eid ff_user_entities.user_entity_id%TYPE;
355: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;
356: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;
357: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;

Line 354: g_period_of_service_eid ff_user_entities.user_entity_id%TYPE;

350: g_prev_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
351: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
352: g_student_loan_flag_eid ff_user_entities.user_entity_id%TYPE;
353: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;
354: g_period_of_service_eid ff_user_entities.user_entity_id%TYPE;
355: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;
356: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;
357: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
358: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;

Line 355: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;

351: g_prev_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
352: g_student_loan_flag_eid ff_user_entities.user_entity_id%TYPE;
353: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;
354: g_period_of_service_eid ff_user_entities.user_entity_id%TYPE;
355: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;
356: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;
357: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
358: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;
359: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;

Line 356: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;

352: g_student_loan_flag_eid ff_user_entities.user_entity_id%TYPE;
353: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;
354: g_period_of_service_eid ff_user_entities.user_entity_id%TYPE;
355: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;
356: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;
357: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
358: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;
359: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
360: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;

Line 357: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;

353: g_aggregated_paye_flag_eid ff_user_entities.user_entity_id%TYPE;
354: g_period_of_service_eid ff_user_entities.user_entity_id%TYPE;
355: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;
356: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;
357: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
358: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;
359: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
360: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;
361: g_title_eid ff_user_entities.user_entity_id%TYPE;

Line 358: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;

354: g_period_of_service_eid ff_user_entities.user_entity_id%TYPE;
355: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;
356: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;
357: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
358: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;
359: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
360: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;
361: g_title_eid ff_user_entities.user_entity_id%TYPE;
362: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;

Line 359: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;

355: g_effective_end_date_eid ff_user_entities.user_entity_id%TYPE;
356: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;
357: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
358: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;
359: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
360: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;
361: g_title_eid ff_user_entities.user_entity_id%TYPE;
362: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;
363: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;

Line 360: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;

356: g_tax_code_eid ff_user_entities.user_entity_id%TYPE;
357: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
358: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;
359: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
360: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;
361: g_title_eid ff_user_entities.user_entity_id%TYPE;
362: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;
363: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;
364: g_week_number_eid ff_user_entities.user_entity_id%TYPE;

Line 361: g_title_eid ff_user_entities.user_entity_id%TYPE;

357: g_tax_paid_eid ff_user_entities.user_entity_id%TYPE;
358: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;
359: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
360: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;
361: g_title_eid ff_user_entities.user_entity_id%TYPE;
362: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;
363: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;
364: g_week_number_eid ff_user_entities.user_entity_id%TYPE;
365: g_country_eid ff_user_entities.user_entity_id%TYPE;

Line 362: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;

358: g_tax_ref_transfer_eid ff_user_entities.user_entity_id%TYPE;
359: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
360: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;
361: g_title_eid ff_user_entities.user_entity_id%TYPE;
362: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;
363: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;
364: g_week_number_eid ff_user_entities.user_entity_id%TYPE;
365: g_country_eid ff_user_entities.user_entity_id%TYPE;
366: g_p45_final_action ff_user_entities.user_entity_id%TYPE;

Line 363: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;

359: g_taxable_pay_eid ff_user_entities.user_entity_id%TYPE;
360: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;
361: g_title_eid ff_user_entities.user_entity_id%TYPE;
362: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;
363: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;
364: g_week_number_eid ff_user_entities.user_entity_id%TYPE;
365: g_country_eid ff_user_entities.user_entity_id%TYPE;
366: g_p45_final_action ff_user_entities.user_entity_id%TYPE;
367: g_p45_inc_assignment ff_user_entities.user_entity_id%TYPE;

Line 364: g_week_number_eid ff_user_entities.user_entity_id%TYPE;

360: g_termination_date_eid ff_user_entities.user_entity_id%TYPE;
361: g_title_eid ff_user_entities.user_entity_id%TYPE;
362: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;
363: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;
364: g_week_number_eid ff_user_entities.user_entity_id%TYPE;
365: g_country_eid ff_user_entities.user_entity_id%TYPE;
366: g_p45_final_action ff_user_entities.user_entity_id%TYPE;
367: g_p45_inc_assignment ff_user_entities.user_entity_id%TYPE;
368: -- Added for P45PT1. Bug 6345375

Line 365: g_country_eid ff_user_entities.user_entity_id%TYPE;

361: g_title_eid ff_user_entities.user_entity_id%TYPE;
362: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;
363: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;
364: g_week_number_eid ff_user_entities.user_entity_id%TYPE;
365: g_country_eid ff_user_entities.user_entity_id%TYPE;
366: g_p45_final_action ff_user_entities.user_entity_id%TYPE;
367: g_p45_inc_assignment ff_user_entities.user_entity_id%TYPE;
368: -- Added for P45PT1. Bug 6345375
369: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;

Line 366: g_p45_final_action ff_user_entities.user_entity_id%TYPE;

362: g_town_or_city_eid ff_user_entities.user_entity_id%TYPE;
363: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;
364: g_week_number_eid ff_user_entities.user_entity_id%TYPE;
365: g_country_eid ff_user_entities.user_entity_id%TYPE;
366: g_p45_final_action ff_user_entities.user_entity_id%TYPE;
367: g_p45_inc_assignment ff_user_entities.user_entity_id%TYPE;
368: -- Added for P45PT1. Bug 6345375
369: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;
370: g_sex_eid ff_user_entities.user_entity_id%TYPE;

Line 367: g_p45_inc_assignment ff_user_entities.user_entity_id%TYPE;

363: g_w1_m1_indicator_eid ff_user_entities.user_entity_id%TYPE;
364: g_week_number_eid ff_user_entities.user_entity_id%TYPE;
365: g_country_eid ff_user_entities.user_entity_id%TYPE;
366: g_p45_final_action ff_user_entities.user_entity_id%TYPE;
367: g_p45_inc_assignment ff_user_entities.user_entity_id%TYPE;
368: -- Added for P45PT1. Bug 6345375
369: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;
370: g_sex_eid ff_user_entities.user_entity_id%TYPE;
371: -- Seed data IDs

Line 369: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;

365: g_country_eid ff_user_entities.user_entity_id%TYPE;
366: g_p45_final_action ff_user_entities.user_entity_id%TYPE;
367: g_p45_inc_assignment ff_user_entities.user_entity_id%TYPE;
368: -- Added for P45PT1. Bug 6345375
369: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;
370: g_sex_eid ff_user_entities.user_entity_id%TYPE;
371: -- Seed data IDs
372: g_paye_details_id pay_element_types_f.element_type_id%TYPE;
373: --

Line 370: g_sex_eid ff_user_entities.user_entity_id%TYPE;

366: g_p45_final_action ff_user_entities.user_entity_id%TYPE;
367: g_p45_inc_assignment ff_user_entities.user_entity_id%TYPE;
368: -- Added for P45PT1. Bug 6345375
369: g_date_of_birth_eid ff_user_entities.user_entity_id%TYPE;
370: g_sex_eid ff_user_entities.user_entity_id%TYPE;
371: -- Seed data IDs
372: g_paye_details_id pay_element_types_f.element_type_id%TYPE;
373: --
374: FUNCTION get_report_request_error RETURN VARCHAR2 IS

Line 1478: l_employers_name_eid ff_user_entities.user_entity_id%TYPE;

1474: PROCEDURE range_cursor (pactid IN NUMBER,
1475: sqlstr OUT NOCOPY VARCHAR2)
1476: IS
1477: l_proc CONSTANT VARCHAR2(35):= g_package||'range_cursor';
1478: l_employers_name_eid ff_user_entities.user_entity_id%TYPE;
1479: l_employers_address_line_eid ff_user_entities.user_entity_id%TYPE;
1480: l_tax_district_name_eid ff_user_entities.user_entity_id%TYPE;
1481: -- vars for returns from the API:
1482: l_archive_item_id ff_archive_items.archive_item_id%TYPE;

Line 1479: l_employers_address_line_eid ff_user_entities.user_entity_id%TYPE;

1475: sqlstr OUT NOCOPY VARCHAR2)
1476: IS
1477: l_proc CONSTANT VARCHAR2(35):= g_package||'range_cursor';
1478: l_employers_name_eid ff_user_entities.user_entity_id%TYPE;
1479: l_employers_address_line_eid ff_user_entities.user_entity_id%TYPE;
1480: l_tax_district_name_eid ff_user_entities.user_entity_id%TYPE;
1481: -- vars for returns from the API:
1482: l_archive_item_id ff_archive_items.archive_item_id%TYPE;
1483: l_ovn NUMBER;

Line 1480: l_tax_district_name_eid ff_user_entities.user_entity_id%TYPE;

1476: IS
1477: l_proc CONSTANT VARCHAR2(35):= g_package||'range_cursor';
1478: l_employers_name_eid ff_user_entities.user_entity_id%TYPE;
1479: l_employers_address_line_eid ff_user_entities.user_entity_id%TYPE;
1480: l_tax_district_name_eid ff_user_entities.user_entity_id%TYPE;
1481: -- vars for returns from the API:
1482: l_archive_item_id ff_archive_items.archive_item_id%TYPE;
1483: l_ovn NUMBER;
1484: l_some_warning BOOLEAN;

Line 1499: FROM ff_user_entities

1495: test_indicator_error EXCEPTION;
1496: --
1497: cursor csr_user_entity(p_entity_name VARCHAR2) IS
1498: SELECT user_entity_id
1499: FROM ff_user_entities
1500: WHERE user_entity_name = p_entity_name
1501: AND legislation_code = 'GB'
1502: AND business_group_id IS NULL;
1503: --

Line 2224: FROM ff_user_entities

2220: WHERE payroll_action_id = p_payroll_action_id;
2221: --
2222: cursor csr_user_entity(p_entity_name VARCHAR2) IS
2223: SELECT user_entity_id
2224: FROM ff_user_entities
2225: WHERE user_entity_name = p_entity_name
2226: AND legislation_code = 'GB'
2227: AND business_group_id IS NULL;
2228: --

Line 2938: FROM ff_user_entities

2934:
2935: --
2936: cursor csr_user_entity(p_entity_name VARCHAR2) IS
2937: SELECT user_entity_id
2938: FROM ff_user_entities
2939: WHERE user_entity_name = p_entity_name
2940: AND legislation_code = 'GB'
2941: AND business_group_id IS NULL;
2942: --

Line 4281: FROM ff_user_entities

4277: l_actid pay_assignment_actions.assignment_action_id%TYPE;
4278: --
4279: cursor csr_user_entity(p_entity_name VARCHAR2) IS
4280: SELECT user_entity_id
4281: FROM ff_user_entities
4282: WHERE user_entity_name = p_entity_name
4283: AND legislation_code = 'GB'
4284: AND business_group_id IS NULL;
4285: --

Line 4592: ff_user_entities fue

4588: nvl(substr(to_char(fnd_date.canonical_to_date(max(decode(fue.user_entity_name,'X_DATE_OF_BIRTH',fai.VALUE))),'DD-MM-YYYY'),7,4),' ') DATE_OF_BIRTH_YY,
4589: nvl(max (decode(fue.user_entity_name,'X_SEX', substr(fai.value,1,1))),' ') SEX
4590: /*P45 A4 2008/09*/
4591: from ff_archive_items fai,
4592: ff_user_entities fue
4593: where x_assignment_action_id = fai.context1
4594: and fai.archive_type <>'PA'
4595: and fai.user_entity_id = fue.user_entity_id;
4596: --

Line 4694: ff_user_entities fue

4690: select upper(nvl(max(decode(fue.user_entity_name,'X_EMPLOYERS_NAME',fai.VALUE)),null)) EMPLOYERS_NAME,
4691: upper(nvl(max(decode(fue.user_entity_name,'X_EMPLOYERS_ADDRESS_LINE',fai.VALUE)),null)) EMPLOYERS_ADDRESS
4692: from ff_archive_item_contexts aic,
4693: ff_archive_items fai,
4694: ff_user_entities fue
4695: where X_PAYROLL_ACTION_ID = fai.context1
4696: and fai.user_entity_id = fue.user_entity_id
4697: and fai.archive_item_id = aic.archive_item_id
4698: and aic.context = '0'

Line 4737: FROM ff_archive_items fai, ff_user_entities fue

4733: AND report_category = 'P45';
4734:
4735: CURSOR csr_transfer_p45(c_assignment_action_id NUMBER) IS
4736: SELECT fai.VALUE
4737: FROM ff_archive_items fai, ff_user_entities fue
4738: WHERE fai.user_entity_id = fue.user_entity_id
4739: AND fue.user_entity_name = 'X_TAX_REF_TRANSFER'
4740: AND fue.legislation_code = 'GB'
4741: AND fue.business_group_id IS NULL

Line 4816: ff_user_entities ue,

4812: /*
4813: Cursor csr_get_final_payment(c_assignment_id NUMBER, c_asg_action_id NUMBER, c_action_sequence NUMBER) IS
4814: select pact1.payroll_action_id, pact1.effective_date final_payment_date
4815: from FF_ARCHIVE_ITEMS ai,
4816: ff_user_entities ue,
4817: pay_payroll_actions pact1
4818: WHERE ue.user_entity_name in ('X_MONTH_NUMBER', 'X_WEEK_NUMBER') -- for the weekly frequency (and multiples)
4819: AND ue.legislation_code = 'GB'
4820: AND ue.business_group_id IS NULL

Line 4912: ff_user_entities fue

4908: --
4909: cursor csr_get_p45_another_asg(c_assignment_id number,c_assignment_action_id number) is
4910: select 1
4911: from ff_archive_items fai,
4912: ff_user_entities fue
4913: where fai.user_entity_id = fue.user_entity_id
4914: and fue.user_entity_name = 'X_P45_INCLUDED_ASSIGNMENT'
4915: and fai.context1 = c_assignment_action_id
4916: and fai.value = to_char(c_assignment_id);