DBA Data[Home] [Help]

APPS.PAY_PSD_BUS dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 3334: pay_user_column_instances_f pucif,

3330: if p_old_age_contribution is null then
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'

Line 3357: pay_user_column_instances_f pucif,

3353: if p_pension_contribution is null then
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'

Line 3379: pay_user_column_instances_f pucif,

3375: if p_sickness_contribution is null then
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'

Line 3400: pay_user_column_instances_f pucif,

3396: if p_work_injury_contribution is null then
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'

Line 3421: pay_user_column_instances_f pucif,

3417: if p_labor_contribution is null then
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'

Line 3443: pay_user_column_instances_f pucif,

3439: if p_health_contribution is null then
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'

Line 3465: pay_user_column_instances_f pucif,

3461: if p_unemployment_contribution is null then
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'