APPS.PAY_NL_LSS_FUNCTIONS dependencies on STANDARD

Line 276: -- Assignments that have a Last Standard Process Date

272: AND active_flag = 'Y')
273: AND l_date BETWEEN effective_start_date and effective_end_date);
274:
275: --
276: -- Assignments that have a Last Standard Process Date
277: -- Greater than the termination Date
278: --
279: -- Secondary assignments and LSP date equal to the
280: -- termination date ( cases where the assignment is end dated as within the year

Line 354: ('Wage In Money Standard Tax SI',l_asg_ytd);

350: -- Getting Defined_Balance_Type_Id of 12 balances required to calculate
351: -- Remunuration Report Col6 Value
352:
353: OPEN csr_get_def_bal_type_id
354: ('Wage In Money Standard Tax SI',l_asg_ytd);
355: FETCH csr_get_def_bal_type_id
356: INTO l_def_bal_type_id(1);
357: CLOSE csr_get_def_bal_type_id;
358:

Line 366: ('Retro Wage In Money Standard Tax SI',l_asg_ytd);

362: INTO l_def_bal_type_id(2);
363: CLOSE csr_get_def_bal_type_id;
364:
365: OPEN csr_get_def_bal_type_id
366: ('Retro Wage In Money Standard Tax SI',l_asg_ytd);
367: FETCH csr_get_def_bal_type_id
368: INTO l_def_bal_type_id(3);
369: CLOSE csr_get_def_bal_type_id;
370:

Line 378: ('Wage In Kind Standard Tax SI',l_asg_ytd);

374: INTO l_def_bal_type_id(4);
375: CLOSE csr_get_def_bal_type_id;
376:
377: OPEN csr_get_def_bal_type_id
378: ('Wage In Kind Standard Tax SI',l_asg_ytd);
379: FETCH csr_get_def_bal_type_id
380: INTO l_def_bal_type_id(5);
381: CLOSE csr_get_def_bal_type_id;
382:

Line 390: ('Retro Wage In Kind Standard Tax SI',l_asg_ytd);

386: INTO l_def_bal_type_id(6);
387: CLOSE csr_get_def_bal_type_id;
388:
389: OPEN csr_get_def_bal_type_id
390: ('Retro Wage In Kind Standard Tax SI',l_asg_ytd);
391: FETCH csr_get_def_bal_type_id
392: INTO l_def_bal_type_id(7);
393: CLOSE csr_get_def_bal_type_id;
394:

Line 402: ('Tips and Fund Payments Standard Tax SI',l_asg_ytd);

398: INTO l_def_bal_type_id(8);
399: CLOSE csr_get_def_bal_type_id;
400:
401: OPEN csr_get_def_bal_type_id
402: ('Tips and Fund Payments Standard Tax SI',l_asg_ytd);
403: FETCH csr_get_def_bal_type_id
404: INTO l_def_bal_type_id(9);
405: CLOSE csr_get_def_bal_type_id;
406:

Line 414: ('Retro Tips and Fund Payments Standard Tax SI',l_asg_ytd);

410: INTO l_def_bal_type_id(10);
411: CLOSE csr_get_def_bal_type_id;
412:
413: OPEN csr_get_def_bal_type_id
414: ('Retro Tips and Fund Payments Standard Tax SI',l_asg_ytd);
415: FETCH csr_get_def_bal_type_id
416: INTO l_def_bal_type_id(11);
417: CLOSE csr_get_def_bal_type_id;
418: