APPS.PAY_PSD_BUS dependencies on PAY_USER_TABLES

Line 546: l_user_table_name pay_user_tables.user_table_name%TYPE;

542: l_proc varchar2(72);
543: l_api_updating boolean;
544: l_exists varchar2(1);
545:
546: l_user_table_name pay_user_tables.user_table_name%TYPE;
547: l_legislation_code pay_user_columns.legislation_code%TYPE;
548:
549: cursor csr_emp_social_security_info is
550: select null

Line 551: from pay_user_columns puc, pay_user_tables put

547: l_legislation_code pay_user_columns.legislation_code%TYPE;
548:
549: cursor csr_emp_social_security_info is
550: select null
551: from pay_user_columns puc, pay_user_tables put
552: where puc.user_table_id = put.user_table_id
553: and put.user_table_name = l_user_table_name
554: and put.legislation_code = l_legislation_code
555: and puc.user_column_name = p_emp_social_security_info;

Line 3337: pay_user_tables put

3333: from
3334: pay_user_column_instances_f pucif,
3335: pay_user_columns puc,
3336: pay_user_rows_f purf,
3337: pay_user_tables put
3338: where put.user_table_name ='PL_EMPLOYEE_SOCIAL_SECURITY_INFORMATION'
3339: and put.legislation_code = 'PL'
3340: and purf.legislation_code = 'PL'
3341: and purf.user_table_id = put.user_table_id

Line 3360: pay_user_tables put

3356: from
3357: pay_user_column_instances_f pucif,
3358: pay_user_columns puc,
3359: pay_user_rows_f purf,
3360: pay_user_tables put
3361: where put.user_table_name ='PL_EMPLOYEE_SOCIAL_SECURITY_INFORMATION'
3362: and put.legislation_code = 'PL'
3363: and purf.legislation_code = 'PL'
3364: and purf.user_table_id = put.user_table_id

Line 3382: pay_user_tables put

3378: from
3379: pay_user_column_instances_f pucif,
3380: pay_user_columns puc,
3381: pay_user_rows_f purf,
3382: pay_user_tables put
3383: where put.user_table_name ='PL_EMPLOYEE_SOCIAL_SECURITY_INFORMATION'
3384: and put.legislation_code = 'PL'
3385: and purf.legislation_code = 'PL'
3386: and purf.user_table_id = put.user_table_id

Line 3403: pay_user_tables put

3399: from
3400: pay_user_column_instances_f pucif,
3401: pay_user_columns puc,
3402: pay_user_rows_f purf,
3403: pay_user_tables put
3404: where put.user_table_name ='PL_EMPLOYEE_SOCIAL_SECURITY_INFORMATION'
3405: and put.legislation_code = 'PL'
3406: and purf.legislation_code = 'PL'
3407: and purf.user_table_id = put.user_table_id

Line 3424: pay_user_tables put

3420: from
3421: pay_user_column_instances_f pucif,
3422: pay_user_columns puc,
3423: pay_user_rows_f purf,
3424: pay_user_tables put
3425: where put.user_table_name ='PL_EMPLOYEE_SOCIAL_SECURITY_INFORMATION'
3426: and put.legislation_code = 'PL'
3427: and purf.legislation_code = 'PL'
3428: and purf.user_table_id = put.user_table_id

Line 3446: pay_user_tables put

3442: from
3443: pay_user_column_instances_f pucif,
3444: pay_user_columns puc,
3445: pay_user_rows_f purf,
3446: pay_user_tables put
3447: where put.user_table_name ='PL_EMPLOYEE_SOCIAL_SECURITY_INFORMATION'
3448: and put.legislation_code = 'PL'
3449: and purf.legislation_code = 'PL'
3450: and purf.user_table_id = put.user_table_id

Line 3468: pay_user_tables put

3464: from
3465: pay_user_column_instances_f pucif,
3466: pay_user_columns puc,
3467: pay_user_rows_f purf,
3468: pay_user_tables put
3469: where put.user_table_name ='PL_EMPLOYEE_SOCIAL_SECURITY_INFORMATION'
3470: and put.legislation_code = 'PL'
3471: and purf.legislation_code = 'PL'
3472: and purf.user_table_id = put.user_table_id