APPS.PQH_GSP_UTILITY dependencies on PAY_INPUT_VALUES_F

Line 1754: l_input_value_id pay_input_values_f.Input_Value_id%TYPE;

1750:
1751: Return Number Is
1752:
1753: L_Cur_Sal Per_pay_Proposals.PROPOSED_SALARY_N%TYPE;
1754: l_input_value_id pay_input_values_f.Input_Value_id%TYPE;
1755: L_FREQUENCY per_time_period_types.period_type%TYPE;
1756: L_ANNUAL_SALARY Per_pay_Proposals.PROPOSED_SALARY_N%TYPE;
1757: L_PAY_BASIS Varchar2(5);
1758: L_REASON_CD Per_pay_Proposals.proposal_reason%TYPE;

Line 1766: pay_input_values_f piv,

1762:
1763: Cursor Sal is
1764: Select pev.screen_entry_value
1765: From pay_element_entries_f pee,
1766: pay_input_values_f piv,
1767: pay_element_entry_values_f pev
1768: Where pee.Assignment_id = P_Assignment_id
1769: and P_Effective_Date
1770: between pee.Effective_Start_Date and pee.Effective_End_Date

Line 5664: FROM pay_input_values_f_tl ptl

5660: IS
5661: CURSOR csr_input_val_name
5662: IS
5663: SELECT ptl.NAME
5664: FROM pay_input_values_f_tl ptl
5665: WHERE ptl.LANGUAGE = USERENV ('LANG')
5666: AND ptl.input_value_id = p_input_value_id;
5667:
5668: l_input_val_name pay_input_values_f_tl.NAME%TYPE;

Line 5668: l_input_val_name pay_input_values_f_tl.NAME%TYPE;

5664: FROM pay_input_values_f_tl ptl
5665: WHERE ptl.LANGUAGE = USERENV ('LANG')
5666: AND ptl.input_value_id = p_input_value_id;
5667:
5668: l_input_val_name pay_input_values_f_tl.NAME%TYPE;
5669: BEGIN
5670:
5671: OPEN csr_input_val_name;
5672: FETCH csr_input_val_name INTO l_input_val_name;