DBA Data[Home] [Help]

APPS.PAY_MWS_MAGTAPE_REPORTING dependencies on PER_ASSIGNMENTS_F

Line 116: We will check for the primary flag of PER_ASSIGNMENTS_F to be Y, in

112:
113:
114:
115: /* Get all the employees belonging to an organization of the worksite.
116: We will check for the primary flag of PER_ASSIGNMENTS_F to be Y, in
117: order to see that it is the primary assignment of the employee */
118:
119: cursor us_mws_organization_employees is
120: select 'ASSIGNMENT_ACTION_ID=C', paa.assignment_action_id,

Line 127: PER_ASSIGNMENTS_F paf,

123: 'TRANSFER_ASG_START_DATE=P',to_char(paf.effective_start_date,'DD-MM-YYYY'),
124: 'TRANSFER_ASG_END_DATE=P', to_char(paf.effective_end_date,'DD-MM-YYYY')
125: from PAY_PAYROLL_ACTIONS ppa,
126: PAY_ASSIGNMENT_ACTIONS paa,
127: PER_ASSIGNMENTS_F paf,
128: PER_PEOPLE_F ppf,
129: HR_SOFT_CODING_KEYFLEX scl
130: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value
131: ('TRANSFER_PAYROLL_ACTION_ID')