APPS.PAY_PSD_BUS dependencies on PAY_USER_COLUMNS

Line 547: l_legislation_code pay_user_columns.legislation_code%TYPE;

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
551: from pay_user_columns puc, pay_user_tables put

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 3335: pay_user_columns puc,

3331: select pucif.value
3332: into p_old_age_contribution
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'

Line 3358: pay_user_columns puc,

3354: select pucif.value
3355: into p_pension_contribution
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'

Line 3380: pay_user_columns puc,

3376: select pucif.value
3377: into p_sickness_contribution
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'

Line 3401: pay_user_columns puc,

3397: select pucif.value
3398: into p_work_injury_contribution
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'

Line 3422: pay_user_columns puc,

3418: select pucif.value
3419: into p_labor_contribution
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'

Line 3444: pay_user_columns puc,

3440: select pucif.value
3441: into p_health_contribution
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'

Line 3466: pay_user_columns puc,

3462: select pucif.value
3463: into p_unemployment_contribution
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'