[Home] [Help]
35:
36: cursor csr_last_dt is
37: Select NVL( max( tp.end_date), p_start_date )
38: From per_time_periods tp,
39: pay_payroll_actions ppa,
40: per_all_assignments_f aaf
41: Where aaf.assignment_id = p_assignment_id
42: and (aaf.effective_end_date >= p_start_date and aaf.effective_start_date <= p_end_date)
43: and ppa.payroll_id = aaf.payroll_id
54: cursor csr_last_dt is
55: Select NVL( tp.end_date, p_start_date )
56: from pay_assignment_actions paa,
57: per_all_assignments_f paf,
58: pay_payroll_actions ppa,
59: pay_action_classifications pac,
60: per_time_periods tp
61: where paf.assignment_id = p_assignment_id
62: and (paf.effective_end_date >= p_start_date
781: PAY_RUN_RESULTS RES,
782: (
783: Select tp.start_date, tp.end_date, aac.assignment_action_id
784: From per_time_periods tp,
785: pay_payroll_actions ppa,
786: PAY_ASSIGNMENT_ACTIONS AAC
787: Where tp.payroll_id=p_payroll_id
788: AND (tp.start_date <= p_actuals_end_date and tp.end_date >= p_actuals_start_date)
789: and tp.payroll_id = ppa.payroll_id
819: PAY_RUN_RESULTS RES,
820: (
821: Select tp.start_date, tp.end_date, aac.assignment_action_id
822: From per_time_periods tp,
823: pay_payroll_actions ppa,
824: PAY_ASSIGNMENT_ACTIONS AAC
825: Where tp.payroll_id=p_payroll_id
826: AND (tp.start_date <= p_actuals_end_date and tp.end_date >= p_actuals_start_date)
827: and tp.payroll_id = ppa.payroll_id
928: PAY_RUN_RESULTS RES,
929: (
930: Select tp.start_date, tp.end_date, aac.assignment_action_id
931: From per_time_periods tp,
932: pay_payroll_actions ppa,
933: PAY_ASSIGNMENT_ACTIONS AAC
934: Where tp.payroll_id=p_payroll_id
935: AND (tp.start_date <= p_actuals_end_date and tp.end_date >= p_actuals_start_date)
936: and tp.payroll_id = ppa.payroll_id
1014:
1015: Cursor csr_pay_date Is
1016: Select max(tp.end_date)
1017: From per_time_periods tp,
1018: pay_payroll_actions ppa,
1019: PAY_ASSIGNMENT_ACTIONS AAC
1020: Where tp.payroll_id=p_payroll_id
1021: and (tp.start_date <= p_actuals_end_date and tp.end_date >= p_actuals_start_date)
1022: and tp.payroll_id = ppa.payroll_id
1109: -- and RUN_BALANCE_STATUS = 'V';
1110:
1111: cursor csr_asg_action(c_assignment_id number, c_effective_date date) is
1112: select paa.assignment_action_id
1113: from pay_assignment_actions paa, pay_payroll_actions ppa
1114: where paa.payroll_action_id = ppa.payroll_action_id
1115: and paa.source_action_id is null
1116: and paa.assignment_id = c_assignment_id
1117: and ppa.effective_date = (select max(effective_date) from pay_payroll_actions ppa1
1113: from pay_assignment_actions paa, pay_payroll_actions ppa
1114: where paa.payroll_action_id = ppa.payroll_action_id
1115: and paa.source_action_id is null
1116: and paa.assignment_id = c_assignment_id
1117: and ppa.effective_date = (select max(effective_date) from pay_payroll_actions ppa1
1118: where ppa1.payroll_action_id = paa.payroll_action_id
1119: and paa.assignment_id = c_assignment_id
1120: and ppa.effective_date <= c_effective_date);
1121:
1322: Cursor csr_asg_time_periods is
1323: Select /*+ ORDERED */
1324: tp.start_date,tp.end_date, aac.assignment_action_id
1325: From per_time_periods tp,
1326: pay_payroll_actions ppa,
1327: PAY_ASSIGNMENT_ACTIONS AAC
1328: Where tp.payroll_id=p_payroll_id
1329: AND (tp.start_date <= p_actuals_end_date
1330: and
4067: and ASSG.effective_start_date <= p_actuals_end_date
4068: AND assg.position_id = p_position_id
4069: -- and assg.assignment_id <> p_ex_assignment_id
4070: ) a,
4071: pay_payroll_actions ppa,
4072: PAY_ASSIGNMENT_ACTIONS AAC,
4073: PAY_COSTS pc,
4074: PAY_ELEMENT_TYPES_F PET,
4075: PAY_INPUT_VALUES_F INV,
4123: and ASSG.effective_start_date <= p_actuals_end_date
4124: AND assg.position_id = p_position_id
4125: -- and assg.assignment_id <> p_ex_assignment_id
4126: ) a,
4127: pay_payroll_actions ppa,
4128: PAY_ASSIGNMENT_ACTIONS AAC,
4129: PAY_COSTS pc,
4130: PAY_ELEMENT_TYPES_F PET,
4131: PAY_INPUT_VALUES_F INV