APPS.PY_ZA_TX_UTL_01082000 dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 2034: l_TableValue pay_user_column_instances_f.value%TYPE;

2030: , p_RowValue IN NUMBER
2031: , p_EffectiveDate IN DATE
2032: ) RETURN VARCHAR2
2033: AS
2034: l_TableValue pay_user_column_instances_f.value%TYPE;
2035: BEGIN
2036:
2037: SELECT pucif.value
2038: INTO l_TableValue

Line 2039: FROM pay_user_column_instances_f pucif

2035: BEGIN
2036:
2037: SELECT pucif.value
2038: INTO l_TableValue
2039: FROM pay_user_column_instances_f pucif
2040: , pay_user_columns puc
2041: , pay_user_rows_f pur
2042: , pay_user_tables put
2043: WHERE upper(put.user_table_name) = upper(p_TableName)

Line 2074: l_fixed pay_user_column_instances_f.value%TYPE;

2070: AS
2071:
2072: -- Variables
2073: --
2074: l_fixed pay_user_column_instances_f.value%TYPE;
2075: l_limit pay_user_column_instances_f.value%TYPE;
2076: l_percentage pay_user_column_instances_f.value%TYPE;
2077: l_effective_date pay_payroll_actions.effective_date%TYPE;
2078: tax_liability NUMBER(15,2);

Line 2075: l_limit pay_user_column_instances_f.value%TYPE;

2071:
2072: -- Variables
2073: --
2074: l_fixed pay_user_column_instances_f.value%TYPE;
2075: l_limit pay_user_column_instances_f.value%TYPE;
2076: l_percentage pay_user_column_instances_f.value%TYPE;
2077: l_effective_date pay_payroll_actions.effective_date%TYPE;
2078: tax_liability NUMBER(15,2);
2079: l_TxbAmt NUMBER(15,2);

Line 2076: l_percentage pay_user_column_instances_f.value%TYPE;

2072: -- Variables
2073: --
2074: l_fixed pay_user_column_instances_f.value%TYPE;
2075: l_limit pay_user_column_instances_f.value%TYPE;
2076: l_percentage pay_user_column_instances_f.value%TYPE;
2077: l_effective_date pay_payroll_actions.effective_date%TYPE;
2078: tax_liability NUMBER(15,2);
2079: l_TxbAmt NUMBER(15,2);
2080: