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 457: FROM pay_user_columns

453: (p_user_table_id IN NUMBER
454: ,p_user_column_name IN VARCHAR2
455: ) IS
456: SELECT user_column_id
457: FROM pay_user_columns
458: WHERE user_table_id = p_user_table_id
459: AND UPPER(user_column_name) = UPPER(p_user_column_name)
460: AND legislation_code = 'GB';
461:

Line 1353: l_annual_hours_col_id pay_user_columns.user_column_id%TYPE;

1349: l_contract_details csr_contract_details%ROWTYPE;
1350: l_assignment_contract csr_assignment_contract%ROWTYPE;
1351:
1352: l_pqp_contract_table_id pay_user_tables.user_table_id%TYPE;
1353: l_annual_hours_col_id pay_user_columns.user_column_id%TYPE;
1354: l_period_divisor_col_id pay_user_columns.user_column_id%TYPE;
1355:
1356: BEGIN -- get_contract_details
1357:

Line 1354: l_period_divisor_col_id pay_user_columns.user_column_id%TYPE;

1350: l_assignment_contract csr_assignment_contract%ROWTYPE;
1351:
1352: l_pqp_contract_table_id pay_user_tables.user_table_id%TYPE;
1353: l_annual_hours_col_id pay_user_columns.user_column_id%TYPE;
1354: l_period_divisor_col_id pay_user_columns.user_column_id%TYPE;
1355:
1356: BEGIN -- get_contract_details
1357:
1358: IF g_debug THEN

Line 1665: l_annual_hours_col_id pay_user_columns.user_column_id%TYPE;

1661: i BINARY_INTEGER:=0;
1662: l_max_iterations BINARY_INTEGER:= 10000;
1663:
1664: l_pqp_contract_table_id pay_user_tables.user_table_id%TYPE;
1665: l_annual_hours_col_id pay_user_columns.user_column_id%TYPE;
1666: l_period_divisor_col_id pay_user_columns.user_column_id%TYPE;
1667:
1668:
1669:

Line 1666: l_period_divisor_col_id pay_user_columns.user_column_id%TYPE;

1662: l_max_iterations BINARY_INTEGER:= 10000;
1663:
1664: l_pqp_contract_table_id pay_user_tables.user_table_id%TYPE;
1665: l_annual_hours_col_id pay_user_columns.user_column_id%TYPE;
1666: l_period_divisor_col_id pay_user_columns.user_column_id%TYPE;
1667:
1668:
1669:
1670: -- there is no need for the change type column in the following cursor