DBA Data[Home] [Help]

APPS.PAYPLNK dependencies on PER_BUSINESS_GROUPS_PERF

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

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

Line 435: from per_business_groups_perf

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

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

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

Line 1605: from per_business_groups_perf

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

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

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

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

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

Line 3128: from per_business_groups_perf bsg

3124: select fnd_number.canonical_to_number(bsg.cost_allocation_structure)
3125: , bsg.legislation_code
3126: into l_cost_allocation_structure
3127: , l_legislation_code
3128: from per_business_groups_perf bsg
3129: where bsg.business_group_id = p_business_group_id
3130: and bsg.enabled_flag = 'Y';
3131: --
3132: --