APPS.PQP_SCHEDULE_CALCULATION_PKG dependencies on PAY_USER_COLUMNS

Line 29: g_last_used_work_pattern pay_user_columns.user_column_name%TYPE;

25: -- cache for load_work_pattern_into_cache
26: g_last_business_group_id pay_user_tables.business_group_id%TYPE;
27: g_last_max_effective_start_dt DATE;
28: g_last_min_effective_end_dt DATE;
29: g_last_used_work_pattern pay_user_columns.user_column_name%TYPE;
30: g_asg_work_pattern_start_day_n BINARY_INTEGER;
31: g_asg_work_pattern_start_date DATE;
32: g_work_pattern_cache t_work_pattern_cache_type;
33:

Line 247: pay_user_columns puc,

243: FROM pay_user_rows_f pur
244: WHERE pur.user_row_id IN
245: (SELECT DISTINCT uci.user_row_id
246: FROM pay_user_tables put,
247: pay_user_columns puc,
248: pay_user_column_instances_f uci
249: WHERE put.user_table_name = g_udt_name
250: AND put.legislation_code = g_legislation_code -- Added on 02/01/2003
251: AND puc.user_table_id = put.user_table_id

Line 680: l_alt_work_pattern pay_user_columns.user_column_name%TYPE;

676: r_wp_dets c_wp_dets%ROWTYPE;
677: r_def_wp_dets c_wp_dets%ROWTYPE;
678: r_tmp_wp_dets c_wp_dets%ROWTYPE;
679: l_working_dates t_working_dates;
680: l_alt_work_pattern pay_user_columns.user_column_name%TYPE;
681:
682: l_error_code NUMBER := 0;
683: l_err_msg_name fnd_new_messages.message_name%TYPE;
684: l_working_dates_nc t_working_dates;

Line 1777: l_work_pattern_to_use pay_user_columns.user_column_name%TYPE;

1773: ,p_date_start_day_index OUT NOCOPY BINARY_INTEGER
1774: )
1775: IS
1776:
1777: l_work_pattern_to_use pay_user_columns.user_column_name%TYPE;
1778: l_user_column_id pay_user_columns.user_column_id%TYPE;
1779: l_pqp_assignment_attributes c_wp_dets_up%ROWTYPE;
1780: l_day_NN_name pay_user_rows_f.row_low_range_or_name%TYPE;
1781: l_asg_work_pattern_start_day_n BINARY_INTEGER;

Line 1778: l_user_column_id pay_user_columns.user_column_id%TYPE;

1774: )
1775: IS
1776:
1777: l_work_pattern_to_use pay_user_columns.user_column_name%TYPE;
1778: l_user_column_id pay_user_columns.user_column_id%TYPE;
1779: l_pqp_assignment_attributes c_wp_dets_up%ROWTYPE;
1780: l_day_NN_name pay_user_rows_f.row_low_range_or_name%TYPE;
1781: l_asg_work_pattern_start_day_n BINARY_INTEGER;
1782: i BINARY_INTEGER;

Line 1802: ,pay_user_columns ucs

1798: ,p_legislation_code VARCHAR2
1799: ) IS
1800: SELECT ucs.user_column_id
1801: FROM pay_user_tables uts
1802: ,pay_user_columns ucs
1803: WHERE uts.user_table_name = p_user_table_name -- PQP_COMPANY_WORK_PATTERNS
1804: AND uts.business_group_id IS NULL
1805: AND uts.legislation_code = p_legislation_code -- as one table is seeded per legislation
1806: AND ucs.user_table_id = uts.user_table_id -- only work patterns that belong to the above table

Line 1821: (p_user_column_id pay_user_columns.user_column_id%TYPE

1817: --local cursor to pull work pattern this will looped and cached into t_work_pattern_cache_type
1818: --
1819:
1820: CURSOR csr_work_pattern_hours
1821: (p_user_column_id pay_user_columns.user_column_id%TYPE
1822: ,p_business_group_id NUMBER
1823: ,p_legislation_code VARCHAR2
1824: ,p_effective_date DATE
1825: ) IS

Line 2214: l_work_pattern_used pay_user_columns.user_column_name%TYPE;

2210: ) RETURN DATE
2211: IS
2212:
2213: l_work_pattern_days t_work_pattern_cache_type;
2214: l_work_pattern_used pay_user_columns.user_column_name%TYPE;
2215: l_asg_work_pattern_start_day_n BINARY_INTEGER;
2216: l_asg_work_pattern_start_date DATE;
2217: l_date_start_day_index BINARY_INTEGER;
2218: i BINARY_INTEGER;