DBA Data[Home] [Help]

APPS.PAY_MX_SSAFFL_SALARY dependencies on PAY_USER_COLUMNS

Line 950: pay_user_columns puc

946:
947: cursor c_rww(cp_workschedule in varchar2) is
948: select sum(decode(to_number(puci.value),0,0,1))
949: from pay_user_column_instances_f puci,
950: pay_user_columns puc
951: where puc.user_column_name = cp_workschedule
952: and puc.legislation_code='MX'
953: and puc.user_column_id = puci.user_column_id ;
954:

Line 1009: pay_user_columns puc

1005: ,national_identifier CURP
1006: from per_all_assignments_f paf,
1007: per_all_people_f ppf,
1008: hr_soft_coding_keyflex hsc,
1009: pay_user_columns puc
1010: where paf.assignment_id = cp_assignment_id
1011: and paf.person_id = ppf.person_id
1012: and paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id (+)
1013: and hsc.segment4 = puc.user_column_id(+)