APPS.GHR_SF52_DO_UPDATE dependencies on PAY_INPUT_VALUES_F

Line 5051: pay_input_values_f ipv,

5047: ) is
5048: select eev.screen_entry_value screen_entry_value,
5049: ele.element_entry_id
5050: from pay_element_types_f elt,
5051: pay_input_values_f ipv,
5052: pay_element_entries_f ele,
5053: pay_element_entry_values_f eev
5054: where trunc(eff_date)
5055: between elt.effective_start_date and elt.effective_end_date

Line 5109: pay_input_values_f inp,

5105: Cursor Cur_Sal_Basis_name(p_bg_id NUMBER,p_ele_name VARCHAR2)
5106: IS
5107: Select pb.pay_basis_id
5108: From pay_element_types_f ele,
5109: pay_input_values_f inp,
5110: per_pay_bases pb
5111: where ele.business_group_id=p_bg_id
5112: and upper(element_name)=upper(p_ele_name)
5113: and ele.business_group_id=inp.business_group_id

Line 5180: ll_input_value_id pay_input_values_f.input_value_id%type;

5176: l_proposal_id NUMBER;
5177: l_pay_intg BOOLEAN:=FALSE;
5178:
5179: ll_element_link_id pay_element_links_f.element_link_id%type;
5180: ll_input_value_id pay_input_values_f.input_value_id%type;
5181: ll_element_entry_id pay_element_entries_f.element_entry_id%type;
5182: ll_value pay_element_entry_values_f.screen_entry_value%type;
5183: ll_object_version_number pay_element_entries_f.object_version_number%type;
5184: ll_multiple_error_flag varchar2(50);

Line 6978: pay_input_values_f ipv,

6974: ipv.uom,
6975: eev.screen_entry_value screen_entry_value,
6976: ele.object_version_number
6977: from pay_element_types_f elt,
6978: pay_input_values_f ipv,
6979: pay_element_entries_f ele,
6980: pay_element_entry_values_f eev
6981: where trunc(eff_date) between elt.effective_start_date
6982: and elt.effective_end_date

Line 7013: l_input_value_id1 pay_input_values_f.input_value_id%type;

7009: l_amount2 pay_element_entry_values_f.screen_entry_value%type;
7010: l_date1 pay_element_entry_values_f.screen_entry_value%type;
7011: l_date2 pay_element_entry_values_f.screen_entry_value%type;
7012: l_business_group_id per_business_groups.business_group_id%type;
7013: l_input_value_id1 pay_input_values_f.input_value_id%type;
7014: l_input_value_id2 pay_input_values_f.input_value_id%type;
7015: l_input_value_id3 pay_input_values_f.input_value_id%type;
7016: l_element_entry_id pay_element_entries_f.element_entry_id%type;
7017: l_object_version_number pay_element_entries_f.object_version_number%type;

Line 7014: l_input_value_id2 pay_input_values_f.input_value_id%type;

7010: l_date1 pay_element_entry_values_f.screen_entry_value%type;
7011: l_date2 pay_element_entry_values_f.screen_entry_value%type;
7012: l_business_group_id per_business_groups.business_group_id%type;
7013: l_input_value_id1 pay_input_values_f.input_value_id%type;
7014: l_input_value_id2 pay_input_values_f.input_value_id%type;
7015: l_input_value_id3 pay_input_values_f.input_value_id%type;
7016: l_element_entry_id pay_element_entries_f.element_entry_id%type;
7017: l_object_version_number pay_element_entries_f.object_version_number%type;
7018: l_update_mode VARCHAR2(25);

Line 7015: l_input_value_id3 pay_input_values_f.input_value_id%type;

7011: l_date2 pay_element_entry_values_f.screen_entry_value%type;
7012: l_business_group_id per_business_groups.business_group_id%type;
7013: l_input_value_id1 pay_input_values_f.input_value_id%type;
7014: l_input_value_id2 pay_input_values_f.input_value_id%type;
7015: l_input_value_id3 pay_input_values_f.input_value_id%type;
7016: l_element_entry_id pay_element_entries_f.element_entry_id%type;
7017: l_object_version_number pay_element_entries_f.object_version_number%type;
7018: l_update_mode VARCHAR2(25);
7019: l_ctr NUMBER;