DBA Data[Home] [Help]

APPS.BEN_EXT_THREAD dependencies on BEN_BENEFIT_ACTIONS

Line 5468: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;

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

Line 5869: ben_benefit_actions_api.create_perf_benefit_actions

5865:
5866:
5867:
5868: --
5869: ben_benefit_actions_api.create_perf_benefit_actions
5870: (p_validate => FALSE
5871: ,p_benefit_action_id => l_benefit_action_id
5872: ,p_process_date => l_effective_date
5873: ,p_uneai_effective_date => NULL

Line 6736: from ben_benefit_actions ben

6732: select pgm_id
6733: ,pl_id
6734: ,business_group_id
6735: ,process_date
6736: from ben_benefit_actions ben
6737: where ben.benefit_action_id = p_benefit_action_id;
6738:
6739:
6740: cursor c_range_err is

Line 6865: FROM ben_benefit_actions bba

6861: ,bba.benefit_action_id
6862: ,bba.business_group_id
6863: ,bba.process_date
6864: ,bba.request_id
6865: FROM ben_benefit_actions bba
6866: WHERE bba.pl_id = c_ext_rslt_id
6867: AND bba.pgm_id = c_ext_dfn_id
6868: AND bba.business_group_id = c_business_group_id;
6869: l_org_req csr_org_req%ROWTYPE;

Line 7050: from ben_benefit_actions ben

7046: ,pl_id
7047: ,benefit_action_id
7048: ,business_group_id
7049: ,process_date
7050: from ben_benefit_actions ben
7051: where ben.request_id = p_concurrent_request_id;
7052: l_parameters c_parameters%rowtype;
7053:
7054: cursor c_range_err is