APPS.PY_ZA_TX_UTL_01032000 dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 1311: l_TableValue pay_user_column_instances_f.value%TYPE;

1307: , p_RowValue IN NUMBER
1308: , p_EffectiveDate IN DATE
1309: ) RETURN VARCHAR2
1310: AS
1311: l_TableValue pay_user_column_instances_f.value%TYPE;
1312: BEGIN
1313:
1314: SELECT pucif.value
1315: INTO l_TableValue

Line 1316: FROM pay_user_column_instances_f pucif

1312: BEGIN
1313:
1314: SELECT pucif.value
1315: INTO l_TableValue
1316: FROM pay_user_column_instances_f pucif
1317: , pay_user_columns puc
1318: , pay_user_rows_f pur
1319: , pay_user_tables put
1320: WHERE upper(put.user_table_name) = upper(p_TableName)

Line 1351: l_fixed pay_user_column_instances_f.value%TYPE;

1347: AS
1348:
1349: -- Variables
1350: --
1351: l_fixed pay_user_column_instances_f.value%TYPE;
1352: l_limit pay_user_column_instances_f.value%TYPE;
1353: l_percentage pay_user_column_instances_f.value%TYPE;
1354: l_effective_date pay_payroll_actions.effective_date%TYPE;
1355: tax_liability NUMBER(15,2);

Line 1352: l_limit pay_user_column_instances_f.value%TYPE;

1348:
1349: -- Variables
1350: --
1351: l_fixed pay_user_column_instances_f.value%TYPE;
1352: l_limit pay_user_column_instances_f.value%TYPE;
1353: l_percentage pay_user_column_instances_f.value%TYPE;
1354: l_effective_date pay_payroll_actions.effective_date%TYPE;
1355: tax_liability NUMBER(15,2);
1356: l_TxbAmt NUMBER(15,2);

Line 1353: l_percentage pay_user_column_instances_f.value%TYPE;

1349: -- Variables
1350: --
1351: l_fixed pay_user_column_instances_f.value%TYPE;
1352: l_limit pay_user_column_instances_f.value%TYPE;
1353: l_percentage pay_user_column_instances_f.value%TYPE;
1354: l_effective_date pay_payroll_actions.effective_date%TYPE;
1355: tax_liability NUMBER(15,2);
1356: l_TxbAmt NUMBER(15,2);
1357: