APPS.PQP_FTE_UTILITIES dependencies on PAY_USER_COLUMNS

Line 38: g_annual_hours_col_id pay_user_columns.user_column_id%TYPE;

34: g_status fnd_product_installations.status%TYPE;
35:
36: -- cache for load_cached_constants
37: g_pqp_contract_table_id pay_user_tables.user_table_id%TYPE;
38: g_annual_hours_col_id pay_user_columns.user_column_id%TYPE;
39: g_period_divisor_col_id pay_user_columns.user_column_id%TYPE;
40: g_not_cached_constants BOOLEAN:=TRUE;
41:
42: -- cache for chk_fte_exists

Line 39: g_period_divisor_col_id pay_user_columns.user_column_id%TYPE;

35:
36: -- cache for load_cached_constants
37: g_pqp_contract_table_id pay_user_tables.user_table_id%TYPE;
38: g_annual_hours_col_id pay_user_columns.user_column_id%TYPE;
39: g_period_divisor_col_id pay_user_columns.user_column_id%TYPE;
40: g_not_cached_constants BOOLEAN:=TRUE;
41:
42: -- cache for chk_fte_exists
43: g_fte_exists_assignment_id per_all_assignments_f.assignment_id%TYPE;

Line 474: FROM pay_user_columns

470: (p_user_table_id IN NUMBER
471: ,p_user_column_name IN VARCHAR2
472: ) IS
473: SELECT user_column_id
474: FROM pay_user_columns
475: WHERE user_table_id = p_user_table_id
476: AND UPPER(user_column_name) = UPPER(p_user_column_name)
477: AND legislation_code = 'GB';
478:

Line 1376: l_annual_hours_col_id pay_user_columns.user_column_id%TYPE;

1372: l_contract_details csr_contract_details%ROWTYPE;
1373: l_assignment_contract csr_assignment_contract%ROWTYPE;
1374:
1375: l_pqp_contract_table_id pay_user_tables.user_table_id%TYPE;
1376: l_annual_hours_col_id pay_user_columns.user_column_id%TYPE;
1377: l_period_divisor_col_id pay_user_columns.user_column_id%TYPE;
1378:
1379: BEGIN -- get_contract_details
1380:

Line 1377: l_period_divisor_col_id pay_user_columns.user_column_id%TYPE;

1373: l_assignment_contract csr_assignment_contract%ROWTYPE;
1374:
1375: l_pqp_contract_table_id pay_user_tables.user_table_id%TYPE;
1376: l_annual_hours_col_id pay_user_columns.user_column_id%TYPE;
1377: l_period_divisor_col_id pay_user_columns.user_column_id%TYPE;
1378:
1379: BEGIN -- get_contract_details
1380:
1381: IF g_debug THEN

Line 1711: l_annual_hours_col_id pay_user_columns.user_column_id%TYPE;

1707: i BINARY_INTEGER:=0;
1708: l_max_iterations BINARY_INTEGER:= 10000;
1709:
1710: l_pqp_contract_table_id pay_user_tables.user_table_id%TYPE;
1711: l_annual_hours_col_id pay_user_columns.user_column_id%TYPE;
1712: l_period_divisor_col_id pay_user_columns.user_column_id%TYPE;
1713:
1714:
1715:

Line 1712: l_period_divisor_col_id pay_user_columns.user_column_id%TYPE;

1708: l_max_iterations BINARY_INTEGER:= 10000;
1709:
1710: l_pqp_contract_table_id pay_user_tables.user_table_id%TYPE;
1711: l_annual_hours_col_id pay_user_columns.user_column_id%TYPE;
1712: l_period_divisor_col_id pay_user_columns.user_column_id%TYPE;
1713:
1714:
1715:
1716: -- there is no need for the change type column in the following cursor