[Home] [Help]
1160: )
1161: IS
1162: SELECT asg.assignment_id, asg.payroll_id, asg.organization_id,
1163: asg.effective_start_date, asg.effective_end_date
1164: FROM per_all_assignments_f asg, per_assignment_status_types ast
1165: WHERE asg.person_id = c_person_id
1166: AND asg.assignment_type <> 'C'
1167: AND asg.primary_flag = 'Y'
1168: AND asg.assignment_status_type_id = ast.assignment_status_type_id
2178: asg.organization_id,
2179: asg.location_id,
2180: asg.pay_basis_id,
2181: asg.employment_category
2182: from per_all_assignments_f asg
2183: where asg.assignment_id = c_asg_id
2184: and c_eff_date
2185: between asg.effective_start_date and asg.effective_end_date;
2186: --
2228: ,c_eff_date date
2229: )
2230: is
2231: select el.element_link_id
2232: from per_all_assignments_f asg,
2233: pay_element_links_f el
2234: where asg.assignment_id = c_asg_id
2235: and el.business_group_id = asg.business_group_id
2236: and el.element_type_id = c_elt_id
3412: CURSOR c_pay_period_strt_dt(p_effective_start_date date
3413: ) IS
3414: SELECT ptp.start_date
3415: FROM per_time_periods ptp
3416: ,per_all_assignments_f asg
3417: WHERE ptp.regular_payment_date >= p_effective_start_date
3418: and ptp.payroll_id = asg.payroll_id
3419: AND ptp.start_date <= p_effective_start_date
3420: AND p_business_group_id = asg.business_group_id
3501: cp_effective_date date,
3502: cp_orig_effective_date date
3503: ) is
3504: select pay.period_type
3505: from per_all_assignments_f asg,
3506: pay_payrolls_f pay,
3507: per_all_assignments_f asg2,
3508: pay_payrolls_f pay2
3509: where asg.person_id = cp_person_id
3503: ) is
3504: select pay.period_type
3505: from per_all_assignments_f asg,
3506: pay_payrolls_f pay,
3507: per_all_assignments_f asg2,
3508: pay_payrolls_f pay2
3509: where asg.person_id = cp_person_id
3510: and asg.assignment_type <> 'C'
3511: and asg.business_group_id = cp_business_group_id
7239: pet.element_name,
7240: pet.multiple_entries_allowed_flag,
7241: pel.element_type_id,
7242: pev.input_value_id
7243: from per_all_assignments_f asg,
7244: pay_element_links_f pel,
7245: pay_element_types_f pet,
7246: pay_element_entries_f pee,
7247: pay_element_entry_values_f pev
8681: pee.original_entry_id,
8682: pee.entry_type,
8683: pee.element_link_id,
8684: pev.screen_entry_value
8685: from per_all_assignments_f asg,
8686: pay_element_links_f pel,
8687: pay_element_entries_f pee,
8688: pay_element_entry_values_f pev
8689: where asg.person_id = p_person_id
8777:
8778: cursor c_ass_type (c_assignment_id number,
8779: c_effective_date date) is
8780: select paa.primary_flag
8781: from per_all_assignments_f paa
8782: where paa.assignment_id = c_assignment_id
8783: and c_effective_date between paa.effective_start_date and paa.effective_end_date;
8784:
8785: l_ass_type c_ass_type%rowtype;
8843: --
8844: ---------Bug 7687104
8845: cursor c_chk_payroll_chg(p_rt_end_date date,p_payroll_id number)is
8846: select pay2.payroll_id old_payroll_id,pay.payroll_id new_payroll_id
8847: from per_all_assignments_f asg,
8848: pay_payrolls_f pay,
8849: per_all_assignments_f asg2,
8850: pay_payrolls_f pay2
8851: where asg.person_id = p_person_id
8845: cursor c_chk_payroll_chg(p_rt_end_date date,p_payroll_id number)is
8846: select pay2.payroll_id old_payroll_id,pay.payroll_id new_payroll_id
8847: from per_all_assignments_f asg,
8848: pay_payrolls_f pay,
8849: per_all_assignments_f asg2,
8850: pay_payrolls_f pay2
8851: where asg.person_id = p_person_id
8852: and asg.business_group_id = p_business_group_id
8853: and asg.primary_flag = 'Y'