APPS.GHR_SF52_DO_UPDATE dependencies on PAY_INPUT_VALUES_F

Line 4792: pay_input_values_f ipv,

4788: ) is
4789: select eev.screen_entry_value screen_entry_value,
4790: ele.element_entry_id
4791: from pay_element_types_f elt,
4792: pay_input_values_f ipv,
4793: pay_element_entries_f ele,
4794: pay_element_entry_values_f eev
4795: where trunc(eff_date)
4796: between elt.effective_start_date and elt.effective_end_date

Line 4850: pay_input_values_f inp,

4846: Cursor Cur_Sal_Basis_name(p_bg_id NUMBER,p_ele_name VARCHAR2)
4847: IS
4848: Select pb.pay_basis_id
4849: From pay_element_types_f ele,
4850: pay_input_values_f inp,
4851: per_pay_bases pb
4852: where ele.business_group_id=p_bg_id
4853: and upper(element_name)=upper(p_ele_name)
4854: and ele.business_group_id=inp.business_group_id

Line 4921: ll_input_value_id pay_input_values_f.input_value_id%type;

4917: l_proposal_id NUMBER;
4918: l_pay_intg BOOLEAN:=FALSE;
4919:
4920: ll_element_link_id pay_element_links_f.element_link_id%type;
4921: ll_input_value_id pay_input_values_f.input_value_id%type;
4922: ll_element_entry_id pay_element_entries_f.element_entry_id%type;
4923: ll_value pay_element_entry_values_f.screen_entry_value%type;
4924: ll_object_version_number pay_element_entries_f.object_version_number%type;
4925: ll_multiple_error_flag varchar2(50);

Line 6702: pay_input_values_f ipv,

6698: ipv.uom,
6699: eev.screen_entry_value screen_entry_value,
6700: ele.object_version_number
6701: from pay_element_types_f elt,
6702: pay_input_values_f ipv,
6703: pay_element_entries_f ele,
6704: pay_element_entry_values_f eev
6705: where trunc(eff_date) between elt.effective_start_date
6706: and elt.effective_end_date

Line 6737: l_input_value_id1 pay_input_values_f.input_value_id%type;

6733: l_amount2 pay_element_entry_values_f.screen_entry_value%type;
6734: l_date1 pay_element_entry_values_f.screen_entry_value%type;
6735: l_date2 pay_element_entry_values_f.screen_entry_value%type;
6736: l_business_group_id per_business_groups.business_group_id%type;
6737: l_input_value_id1 pay_input_values_f.input_value_id%type;
6738: l_input_value_id2 pay_input_values_f.input_value_id%type;
6739: l_input_value_id3 pay_input_values_f.input_value_id%type;
6740: l_element_entry_id pay_element_entries_f.element_entry_id%type;
6741: l_object_version_number pay_element_entries_f.object_version_number%type;

Line 6738: l_input_value_id2 pay_input_values_f.input_value_id%type;

6734: l_date1 pay_element_entry_values_f.screen_entry_value%type;
6735: l_date2 pay_element_entry_values_f.screen_entry_value%type;
6736: l_business_group_id per_business_groups.business_group_id%type;
6737: l_input_value_id1 pay_input_values_f.input_value_id%type;
6738: l_input_value_id2 pay_input_values_f.input_value_id%type;
6739: l_input_value_id3 pay_input_values_f.input_value_id%type;
6740: l_element_entry_id pay_element_entries_f.element_entry_id%type;
6741: l_object_version_number pay_element_entries_f.object_version_number%type;
6742: l_update_mode VARCHAR2(25);

Line 6739: l_input_value_id3 pay_input_values_f.input_value_id%type;

6735: l_date2 pay_element_entry_values_f.screen_entry_value%type;
6736: l_business_group_id per_business_groups.business_group_id%type;
6737: l_input_value_id1 pay_input_values_f.input_value_id%type;
6738: l_input_value_id2 pay_input_values_f.input_value_id%type;
6739: l_input_value_id3 pay_input_values_f.input_value_id%type;
6740: l_element_entry_id pay_element_entries_f.element_entry_id%type;
6741: l_object_version_number pay_element_entries_f.object_version_number%type;
6742: l_update_mode VARCHAR2(25);
6743: l_ctr NUMBER;