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 1783: l_work_pattern_to_use pay_user_columns.user_column_name%TYPE;

1779: ,p_date_start_day_index OUT NOCOPY BINARY_INTEGER
1780: )
1781: IS
1782:
1783: l_work_pattern_to_use pay_user_columns.user_column_name%TYPE;
1784: l_user_column_id pay_user_columns.user_column_id%TYPE;
1785: l_pqp_assignment_attributes c_wp_dets_up%ROWTYPE;
1786: l_day_NN_name pay_user_rows_f.row_low_range_or_name%TYPE;
1787: l_asg_work_pattern_start_day_n BINARY_INTEGER;

Line 1784: l_user_column_id pay_user_columns.user_column_id%TYPE;

1780: )
1781: IS
1782:
1783: l_work_pattern_to_use pay_user_columns.user_column_name%TYPE;
1784: l_user_column_id pay_user_columns.user_column_id%TYPE;
1785: l_pqp_assignment_attributes c_wp_dets_up%ROWTYPE;
1786: l_day_NN_name pay_user_rows_f.row_low_range_or_name%TYPE;
1787: l_asg_work_pattern_start_day_n BINARY_INTEGER;
1788: i BINARY_INTEGER;

Line 1808: ,pay_user_columns ucs

1804: ,p_legislation_code VARCHAR2
1805: ) IS
1806: SELECT ucs.user_column_id
1807: FROM pay_user_tables uts
1808: ,pay_user_columns ucs
1809: WHERE uts.user_table_name = p_user_table_name -- PQP_COMPANY_WORK_PATTERNS
1810: AND uts.business_group_id IS NULL
1811: AND uts.legislation_code = p_legislation_code -- as one table is seeded per legislation
1812: AND ucs.user_table_id = uts.user_table_id -- only work patterns that belong to the above table

Line 1827: (p_user_column_id pay_user_columns.user_column_id%TYPE

1823: --local cursor to pull work pattern this will looped and cached into t_work_pattern_cache_type
1824: --
1825:
1826: CURSOR csr_work_pattern_hours
1827: (p_user_column_id pay_user_columns.user_column_id%TYPE
1828: ,p_business_group_id NUMBER
1829: ,p_legislation_code VARCHAR2
1830: ,p_effective_date DATE
1831: ) IS

Line 2226: l_work_pattern_used pay_user_columns.user_column_name%TYPE;

2222: ) RETURN DATE
2223: IS
2224:
2225: l_work_pattern_days t_work_pattern_cache_type;
2226: l_work_pattern_used pay_user_columns.user_column_name%TYPE;
2227: l_asg_work_pattern_start_day_n BINARY_INTEGER;
2228: l_asg_work_pattern_start_date DATE;
2229: l_date_start_day_index BINARY_INTEGER;
2230: i BINARY_INTEGER;