APPS.PY_ZA_TX_01011001 dependencies on PAY_USER_COLUMNS

Line 1475: l_fixed_column_id pay_user_columns.user_column_id%TYPE;

1471:
1472: -- Variables
1473: --
1474: l_user_table_id pay_user_tables.user_table_id%TYPE;
1475: l_fixed_column_id pay_user_columns.user_column_id%TYPE;
1476: l_limit_column_id pay_user_columns.user_column_id%TYPE;
1477: l_percentage_column_id pay_user_columns.user_column_id%TYPE;
1478: l_bracket_row pay_user_rows_f.user_row_id%TYPE;
1479: l_fixed pay_user_column_instances_f.value%TYPE;

Line 1476: l_limit_column_id pay_user_columns.user_column_id%TYPE;

1472: -- Variables
1473: --
1474: l_user_table_id pay_user_tables.user_table_id%TYPE;
1475: l_fixed_column_id pay_user_columns.user_column_id%TYPE;
1476: l_limit_column_id pay_user_columns.user_column_id%TYPE;
1477: l_percentage_column_id pay_user_columns.user_column_id%TYPE;
1478: l_bracket_row pay_user_rows_f.user_row_id%TYPE;
1479: l_fixed pay_user_column_instances_f.value%TYPE;
1480: l_limit pay_user_column_instances_f.value%TYPE;

Line 1477: l_percentage_column_id pay_user_columns.user_column_id%TYPE;

1473: --
1474: l_user_table_id pay_user_tables.user_table_id%TYPE;
1475: l_fixed_column_id pay_user_columns.user_column_id%TYPE;
1476: l_limit_column_id pay_user_columns.user_column_id%TYPE;
1477: l_percentage_column_id pay_user_columns.user_column_id%TYPE;
1478: l_bracket_row pay_user_rows_f.user_row_id%TYPE;
1479: l_fixed pay_user_column_instances_f.value%TYPE;
1480: l_limit pay_user_column_instances_f.value%TYPE;
1481: l_percentage pay_user_column_instances_f.value%TYPE;

Line 1515: from pay_user_columns

1511: WHERE user_table_name = 'ZA_TAX_TABLE';
1512:
1513: select user_column_id
1514: into l_fixed_column_id
1515: from pay_user_columns
1516: where user_table_id = l_user_table_id
1517: and user_column_name = 'Fixed';
1518:
1519: select user_column_id

Line 1521: from pay_user_columns

1517: and user_column_name = 'Fixed';
1518:
1519: select user_column_id
1520: into l_limit_column_id
1521: from pay_user_columns
1522: where user_table_id = l_user_table_id
1523: and user_column_name = 'Limit';
1524:
1525: select user_column_id

Line 1527: from pay_user_columns

1523: and user_column_name = 'Limit';
1524:
1525: select user_column_id
1526: into l_percentage_column_id
1527: from pay_user_columns
1528: where user_table_id = l_user_table_id
1529: and user_column_name = 'Percentage';
1530:
1531: select purf.user_row_id