APPS.HXC_HXCMISTC_XMLP_PKG dependencies on PER_ASSIGNMENTS_F

Line 125: opt_hint2 := '/*+ LEADING(paf) INDEX(paf per_assignments_f_pk) */';

121:
122: if p_define_missing = '01'
123: then
124: status_condition := 'and paf.assignment_id = -1 ';
125: opt_hint2 := '/*+ LEADING(paf) INDEX(paf per_assignments_f_pk) */';
126: else
127: status_condition := ' ';
128: end if;
129: -- commit;

Line 149: opt_hint := ' INDEX(asm per_assignments_f_fk15) ';

145: if p_organization is not null then
146: p_organization_label := hxc_tpd_end.get_org_name(p_organization);
147: org_condition := ' and asm.organization_id = :p_organization';
148: org_condition2 := ' and paf.organization_id = :p_organization';
149: opt_hint := ' INDEX(asm per_assignments_f_fk15) ';
150: else
151: org_condition := ' ';
152: org_condition2 := ' ';
153: end if;

Line 160: opt_hint := ' INDEX(asm per_assignments_f_n7) ';

156: p_payroll_label := hxc_tpd_end.get_payroll_name(p_payroll);
157:
158: payroll_condition := ' and asm.payroll_id = :p_payroll';
159: payroll_condition2 := ' and paf.payroll_id = :p_payroll';
160: opt_hint := ' INDEX(asm per_assignments_f_n7) ';
161: else
162: payroll_condition := ' ';
163: payroll_condition2 := ' ';
164: end if;

Line 171: opt_hint := ' INDEX(asm per_assignments_f_fk8) ';

167: p_location_label := hxc_tpd_end.get_locn_name(p_location);
168:
169: locn_condition := 'and asm.location_id = :p_location';
170: locn_condition2 := 'and paf.location_id = :p_location';
171: opt_hint := ' INDEX(asm per_assignments_f_fk8) ';
172: else
173: locn_condition := ' ';
174: locn_condition2 := ' ';
175: end if;

Line 189: opt_hint := ' INDEX(asm per_assignments_f_n10) ';

185: fetch c_per_dtl into p_supervisor_label, lv_dummy;
186: close c_per_dtl;
187: sup_condition := ' and asm.supervisor_id = :p_supervisor ';
188: sup_condition2 := ' and paf.supervisor_id = :p_supervisor ';
189: opt_hint := ' INDEX(asm per_assignments_f_n10) ';
190: else
191: sup_condition := ' ';
192: sup_condition2 := ' ';
193: end if;

Line 288: L_ASG_STATUS_TYPE_ID PER_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID%TYPE;

284: END AFTERPFORM;
285:
286:
287: FUNCTION CF_APPLICATIONFORMULA RETURN CHAR IS
288: L_ASG_STATUS_TYPE_ID PER_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID%TYPE;
289: L_PAYROLL_ID PER_ASSIGNMENTS_F.PAYROLL_ID%TYPE;
290: L_SOFT_CODING_KEYFLEX_ID PER_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID%TYPE;
291: L_PAY_SYSTEM_STATUS PER_ASSIGNMENT_STATUS_TYPES.PAY_SYSTEM_STATUS%TYPE;
292: L_PAYROLL_NAME PAY_PAYROLLS_F.PAYROLL_NAME%TYPE;

Line 289: L_PAYROLL_ID PER_ASSIGNMENTS_F.PAYROLL_ID%TYPE;

285:
286:
287: FUNCTION CF_APPLICATIONFORMULA RETURN CHAR IS
288: L_ASG_STATUS_TYPE_ID PER_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID%TYPE;
289: L_PAYROLL_ID PER_ASSIGNMENTS_F.PAYROLL_ID%TYPE;
290: L_SOFT_CODING_KEYFLEX_ID PER_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID%TYPE;
291: L_PAY_SYSTEM_STATUS PER_ASSIGNMENT_STATUS_TYPES.PAY_SYSTEM_STATUS%TYPE;
292: L_PAYROLL_NAME PAY_PAYROLLS_F.PAYROLL_NAME%TYPE;
293: L_SCL_TCARD_REQ VARCHAR2(5);

Line 290: L_SOFT_CODING_KEYFLEX_ID PER_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID%TYPE;

286:
287: FUNCTION CF_APPLICATIONFORMULA RETURN CHAR IS
288: L_ASG_STATUS_TYPE_ID PER_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID%TYPE;
289: L_PAYROLL_ID PER_ASSIGNMENTS_F.PAYROLL_ID%TYPE;
290: L_SOFT_CODING_KEYFLEX_ID PER_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID%TYPE;
291: L_PAY_SYSTEM_STATUS PER_ASSIGNMENT_STATUS_TYPES.PAY_SYSTEM_STATUS%TYPE;
292: L_PAYROLL_NAME PAY_PAYROLLS_F.PAYROLL_NAME%TYPE;
293: L_SCL_TCARD_REQ VARCHAR2(5);
294: BEGIN