APPS.PQH_GSP_UTILITY dependencies on PAY_INPUT_VALUES_F

Line 1635: l_input_value_id pay_input_values_f.Input_Value_id%TYPE;

1631:
1632: Return Number Is
1633:
1634: L_Cur_Sal Per_pay_Proposals.PROPOSED_SALARY_N%TYPE;
1635: l_input_value_id pay_input_values_f.Input_Value_id%TYPE;
1636: L_FREQUENCY per_time_period_types.period_type%TYPE;
1637: L_ANNUAL_SALARY Per_pay_Proposals.PROPOSED_SALARY_N%TYPE;
1638: L_PAY_BASIS Varchar2(5);
1639: L_REASON_CD Per_pay_Proposals.proposal_reason%TYPE;

Line 1647: pay_input_values_f piv,

1643:
1644: Cursor Sal is
1645: Select pev.screen_entry_value
1646: From pay_element_entries_f pee,
1647: pay_input_values_f piv,
1648: pay_element_entry_values_f pev
1649: Where pee.Assignment_id = P_Assignment_id
1650: and P_Effective_Date
1651: between pee.Effective_Start_Date and pee.Effective_End_Date

Line 5545: FROM pay_input_values_f_tl ptl

5541: IS
5542: CURSOR csr_input_val_name
5543: IS
5544: SELECT ptl.NAME
5545: FROM pay_input_values_f_tl ptl
5546: WHERE ptl.LANGUAGE = USERENV ('LANG')
5547: AND ptl.input_value_id = p_input_value_id;
5548:
5549: l_input_val_name pay_input_values_f_tl.NAME%TYPE;

Line 5549: l_input_val_name pay_input_values_f_tl.NAME%TYPE;

5545: FROM pay_input_values_f_tl ptl
5546: WHERE ptl.LANGUAGE = USERENV ('LANG')
5547: AND ptl.input_value_id = p_input_value_id;
5548:
5549: l_input_val_name pay_input_values_f_tl.NAME%TYPE;
5550: BEGIN
5551:
5552: OPEN csr_input_val_name;
5553: FETCH csr_input_val_name INTO l_input_val_name;