DBA Data[Home] [Help]

APPS.BEN_EXT_THREAD dependencies on BEN_BENEFIT_ACTIONS

Line 5465: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;

5461: --
5462: l_current_loc NUMBER:=0;
5463: -- End Update
5464: l_request_id number;
5465: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
5466: l_person_id l_number_type := l_number_type();
5467: l_person_action_id l_number_type := l_number_type();
5468: l_range_id ben_batch_ranges.range_id%type;
5469: l_object_version_number ben_batch_ranges.object_version_number%type;

Line 5863: ben_benefit_actions_api.create_perf_benefit_actions

5859:
5860:
5861:
5862: --
5863: ben_benefit_actions_api.create_perf_benefit_actions
5864: (p_validate => FALSE
5865: ,p_benefit_action_id => l_benefit_action_id
5866: ,p_process_date => l_effective_date
5867: ,p_uneai_effective_date => NULL

Line 6695: from ben_benefit_actions ben

6691: select pgm_id
6692: ,pl_id
6693: ,business_group_id
6694: ,process_date
6695: from ben_benefit_actions ben
6696: where ben.benefit_action_id = p_benefit_action_id;
6697:
6698:
6699: cursor c_range_err is

Line 6824: FROM ben_benefit_actions bba

6820: ,bba.benefit_action_id
6821: ,bba.business_group_id
6822: ,bba.process_date
6823: ,bba.request_id
6824: FROM ben_benefit_actions bba
6825: WHERE bba.pl_id = c_ext_rslt_id
6826: AND bba.pgm_id = c_ext_dfn_id
6827: AND bba.business_group_id = c_business_group_id;
6828: l_org_req csr_org_req%ROWTYPE;

Line 7009: from ben_benefit_actions ben

7005: ,pl_id
7006: ,benefit_action_id
7007: ,business_group_id
7008: ,process_date
7009: from ben_benefit_actions ben
7010: where ben.request_id = p_concurrent_request_id;
7011: l_parameters c_parameters%rowtype;
7012:
7013: cursor c_range_err is