DBA Data[Home] [Help]

APPS.PAY_PAYWSDAS_PKG dependencies on PER_BUSINESS_GROUPS_PERF

Line 525: l_business_group_id per_business_groups_perf.business_group_id%type;

521: ,p_null_allowed out nocopy varchar2
522: ,p_notfound_allowed out nocopy varchar2
523: ,p_start_of_time out nocopy varchar2
524: ) is
525: l_business_group_id per_business_groups_perf.business_group_id%type;
526: l_legislation_code per_business_groups_perf.legislation_code%type;
527: begin
528: --
529: -- This code replaces plain SQL so don't worry about exceptions.

Line 526: l_legislation_code per_business_groups_perf.legislation_code%type;

522: ,p_notfound_allowed out nocopy varchar2
523: ,p_start_of_time out nocopy varchar2
524: ) is
525: l_business_group_id per_business_groups_perf.business_group_id%type;
526: l_legislation_code per_business_groups_perf.legislation_code%type;
527: begin
528: --
529: -- This code replaces plain SQL so don't worry about exceptions.
530: --

Line 540: , per_business_groups_perf bg

536: , bg.legislation_code
537: into l_business_group_id
538: , l_legislation_code
539: from hr_assignment_sets a_s
540: , per_business_groups_perf bg
541: where a_s.assignment_set_id = p_assignment_set_id
542: and bg.business_group_id = a_s.business_group_id
543: ;
544: