DBA Data[Home] [Help]

APPS.PAYPLNK dependencies on PER_BUSINESS_GROUPS_PERF

Line 416: l_legislation_code per_business_groups_perf.legislation_code%TYPE := null;

412: l_header_check number;
413: l_leg_header_check boolean := false;
414: l_line_check number;
415: l_leg_line_check boolean := false;
416: l_legislation_code per_business_groups_perf.legislation_code%TYPE := null;
417: --
418: l_assignment_id pay_batch_lines.assignment_id%TYPE := null;
419: l_error_text pay_message_lines.line_text%TYPE := null;
420: l_assignment_exists varchar2(1) := null;

Line 433: from per_business_groups_perf

429: hr_utility.set_location('payplnk.validate',5);
430: --
431: select legislation_code
432: into l_legislation_code
433: from per_business_groups_perf
434: where business_group_id = p_business_group_id;
435: --
436: --
437: -- Find out of legislative checks at header and lines to

Line 1588: l_legislation_code per_business_groups_perf.legislation_code%TYPE := null;

1584: rows_processed integer;
1585: statem varchar2(256);
1586: l_valid number;
1587: l_leg_message pay_message_lines.line_text%TYPE := null;
1588: l_legislation_code per_business_groups_perf.legislation_code%TYPE := null;
1589: --
1590: column_is_null exception;
1591: invalid_value exception;
1592: user_error exception;

Line 1603: from per_business_groups_perf

1599: hr_utility.set_location('payplnk.validate_header',5);
1600: --
1601: select legislation_code
1602: into l_legislation_code
1603: from per_business_groups_perf
1604: where business_group_id = p_business_group_id;
1605: --
1606: -- Delete any messages that may have resulted from an OLD operation
1607: -- carried out on the batch.

Line 2827: per_business_groups_perf.cost_allocation_structure%TYPE :=null;

2823: l_multiple_entries_allowed
2824: pay_element_types_f.multiple_entries_allowed_flag%TYPE :=null;
2825: l_processing_type pay_element_types_f.processing_type%TYPE :=null;
2826: l_cost_allocation_structure
2827: per_business_groups_perf.cost_allocation_structure%TYPE :=null;
2828: l_legislation_code per_business_groups_perf.legislation_code%TYPE := null;
2829: l_link_id pay_element_links_f.element_link_id%TYPE :=null;
2830: l_user_status pay_batch_lines.batch_line_status%TYPE :=null;
2831: l_user_message pay_message_lines.line_text%TYPE :=null;

Line 2828: l_legislation_code per_business_groups_perf.legislation_code%TYPE := null;

2824: pay_element_types_f.multiple_entries_allowed_flag%TYPE :=null;
2825: l_processing_type pay_element_types_f.processing_type%TYPE :=null;
2826: l_cost_allocation_structure
2827: per_business_groups_perf.cost_allocation_structure%TYPE :=null;
2828: l_legislation_code per_business_groups_perf.legislation_code%TYPE := null;
2829: l_link_id pay_element_links_f.element_link_id%TYPE :=null;
2830: l_user_status pay_batch_lines.batch_line_status%TYPE :=null;
2831: l_user_message pay_message_lines.line_text%TYPE :=null;
2832: --

Line 3119: from per_business_groups_perf bsg

3115: select fnd_number.canonical_to_number(bsg.cost_allocation_structure)
3116: , bsg.legislation_code
3117: into l_cost_allocation_structure
3118: , l_legislation_code
3119: from per_business_groups_perf bsg
3120: where bsg.business_group_id = p_business_group_id
3121: and bsg.enabled_flag = 'Y';
3122: --
3123: --